How to change Oracle default data pump directory to import dumpfile?

database oracle impdp
acfreitas picture acfreitas · Mar 16, 2015 · Viewed 113.8k times · Source

I'm using impdp to import a backup. But I want change default directory dumpfile.

$ impdp system/password@$ORACLE_SID schemas=USER_SCHEMA dumpfile=mydumpfile.dmp logfile=impdpmydumpfile.log

Import: Release 11.2.0.3.0 - Production on Mon Mar 16 09:32:05 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/admin/mydatabase/dpdump/mydumpfile.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Answer

Alex Poole picture Alex Poole · Mar 16, 2015

With the directory parameter:

impdp system/password@$ORACLE_SID schemas=USER_SCHEMA directory=MY_DIR \
  dumpfile=mydumpfile.dmp logfile=impdpmydumpfile.log

The default directory is DATA_PUMP_DIR, which is presumably set to /u01/app/oracle/admin/mydatabase/dpdump on your system.

To use a different directory you (or your DBA) will have to create a new directory object in the database, which points to the Oracle-visible operating system directory you put the file into, and assign privileges to the user doing the import.

Related questions

Oracle data pump impdp to remote server

We have a dump file that we want to import to an Amazon rds server. This is what I did: Create a public db link and verify it works: create public database link rdsdblink connect to dbuser identified by dbpsw …

Read More
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 www2/…

Read More
impdp with PARALLEL not working

I would like to load Oracle dump files in parallel. I have 23 cores on my machine. All the dump files were created using expdp. To do so, I ran this command: impdp $RMS_SCHEMA/amadeus@$TWO_TASK directory=RMS_DUMP_…

Read More