Stack Overflow
Stack Overflow

Questions tagged [impdp]

Oracle Data Dump is a newer, faster and more flexible alternative to the exp and imp utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables.

166 questions
3
votes
0 answers

invalid argument value and bad dump file specification when I try to impdp in Oracle 11g

I'm trying get the SQL DDL statements from a Data Pump dmp file. However I'm getting this when I run impdp: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-39001: invalid argument value ORA-39000: bad dump…
Mr.RV
  • 31
  • 1
  • 2
3
votes
1 answer

Import Oracle Database 12c Enterprise Edition Release 12.1.0.1.0

I want to import a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production using the command : impdp SOLVIA/SOLVIA900@IMMBO DUMPFILE=week_exp_immbo.dmp LOGFILE=week_exp_immbo.log REUSE_DATAFILES=YES exclude=tablespace:"IN…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
3
votes
1 answer

Oracle: Import existing table from dmp into new table

I was able to export the table using below command exp usr1/user1@tes tables=table1 file=/myfoler/export/parties.dmp log=/myfoler/export/parties.log statistics=none direct=y But when I am trying to import the dmp file into new table it is failing…
user2854333
  • 640
  • 6
  • 20
3
votes
0 answers

Oracle "impdp" the 11g dump file to 12c - Unable to create user during import

I have an Oracle datapump dump file exported from Oracle 11gR2 which has been proven working fine when importing to another Oracle 11gR2 environment. I want to import this dump file to my new environment which is running Oracle 12c. I ran the…
TaoPR
  • 5,932
  • 3
  • 25
  • 35
3
votes
1 answer

importing a dmp file into Oracle 11g XE

I have a few dmp files (generated by different a user) I need to import into MS SQL. I realize that I first need to import the files into Oracle (I have 11g XE). My problem is that I can't figure our how to import the files into Oracle. I'm trying…
mikimr
  • 311
  • 3
  • 8
  • 18
3
votes
2 answers

Having trouble exporting and importing Oracle tables

I'm using Oracle 11 and I'm having trouble moving tables between two databases. I've successfully exported a datadumb as follows: expdp.exe www/www@xe tables=TABLE1,TABLE2,TABLE3 directory=dmpdir dumpfile=tables.dmp When I try to: impdp.exe…
Tõnis Ojandu
  • 3,486
  • 4
  • 20
  • 28
2
votes
2 answers

oracle 11g impdp returns invalid operation and object was not found

I wanted to transfer an oracle table between two users using expdp and impdp commands. First of all, I created a directory and granted proper privileges to source and destination users: SQL> CREATE OR REPLACE DIRECTORY TEST_DIR AS…
Zeinab Abbasimazar
  • 9,835
  • 23
  • 82
  • 131
2
votes
1 answer

Oracle Export and Import

Some Background: Somewhere around Oracle 10, which was about a decade ago (give or take), Oracle added a new method of exporting and importing databases called the Oracle Data Pump. Aside from the silly name, the functionality works mostly the same…
theMayer
  • 15,456
  • 7
  • 58
  • 90
2
votes
2 answers

Importing DB with index without reindexing

I want to import a DB using impdp. I would like to import the INDEX NAMES and after that, rebuild it manually. I used the option EXCLUDE=index but then I can't find the index in the table all_indexes Is there a way to import the index without build…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
2
votes
3 answers

How to have oracle imp 11gr2 and 12cr2 on the same machine and just choose the one that I want to use

I'm currently developing an application to import oracle dbs. In order to do that I'm using Data Pump and the original imp client (version 12.2.0.1). However I cannot use that imp client against an 11gr2 database, I need to use the 11gr2 imp…
the_ccalderon
  • 2,006
  • 2
  • 13
  • 24
2
votes
0 answers

Datatype changed after IMPORT of schema

please advice on EXPDP and IMPDP utilities, Oracle 12c DB administration. We exported schema TEST (DB 11.2.0.4) using EXPDB utility and imported dump file to new DB (DB 12.2.0.1.0) using IMPDP utility. After import we checked one of tables -…
Bulat Makhmutov
  • 555
  • 2
  • 8
  • 14
2
votes
1 answer

SQLPlus - Data Pump (expdp and impdp)

some time ago, I installed Oracle SQLPlus without full Oracle database package. Now I need expdp and impdp utility. Is it possible to copy important files from a full Oracle installation and pasting them into SQLPlus directory? Or maybe is there any…
KamilK
  • 319
  • 1
  • 6
  • 16
2
votes
0 answers

Single Byte to Multi Byte Conversion

We are converting a Oracle Single Byte instance into Multi-Byte. Following is the summery of steps we have following: Take an export of Single Byte schema Generate DDL file from exported Dump in step 1(Only table Definitions). Run these table…
Maddy
  • 3,726
  • 9
  • 41
  • 55
2
votes
1 answer

Oracle: importing data pump dump without knowledge dump file content

Old approach for exporting/importing whole schema: exp user/pwdp@server FILE=export.dmp OWNER=user ROWS=Y imp newuser/pwd@server FULL=Y FILE=export.dmp New approach: expdp user/pwdp@server DUMPFILE=export.dp DIRECTORY=exportfolder However had…
Michael Pakhantsov
  • 24,855
  • 6
  • 60
  • 59
2
votes
1 answer

ORA-00942: table or view does not exist error using impdp

I've been provided with a Oracle database dump which I'm attempting to import using the following: impdp myuser/myuser DUMPFILE=/u01/app/oracle/oradata/dumpfile.dmp FULL=y LOGFILE=/u01/app/oracle/oradata/dumplog.log The output is Import: Release…
Loftx
  • 1,760
  • 4
  • 29
  • 50
1
2
3
…
11 12