CODEWITHSUNDEEP
oracle-databaseimpdp
Ashish Sahu
Ashish Sahu

Reputation: 1

when i have running the impdp commands

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/nav_db_dir/cmODF_odf_nav_db/ashsahu/gabq418/RDF_ANT_181G0/RDF_WTA_181G0_ANT.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Below is my command I have created directory DirectoryName Path directoryObject /import/datatest 

impdp username/password@sid table_exists_action=REPLACE tables=SCHMEA.TABLE1,SCHMEA.TABLE2, SCHMEA.TABLE3, SCHMEA.TABLE4, SCHMEA.TABLE5 DIRECTORY=directoryObject remap_schema=SCHMEA:username remap_tablespace=SCHMEA_DA:username_DA dumpfile=file.dmp exclude=grant nologfile=y

And I have given the full access to this directory using chmod 777 /import/datatest (rwxrwxrwx) –

Upvotes: 0

Views: 2450

Answers (2)

Adam vonNieda
Adam vonNieda

Reputation: 1745

To add to what @Littlefoot said

Example: 

Create directory datapump as '/import/datatest';
Grant read,write on directory datapump to scott;

And then the dump file should reside @ /import/datatest

Make sure also that the username that Oracle is running as, let's say "oracle", has access to both the "/import" directory, and the "/import/datatest" directory. Make sure that the user can "cd" into /import/datatest

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 143113

You should have posted the whole IMPDP command.

I suspect that you misunderstood/misused the DIRECTORY parameter.

It is an Oracle object, created by SYS, and is only (generally speaking) a "pointer" to a physical directory on the database server's hard disk. After it is created, SYS should give you (i.e. the user which is running the IMPDP command) read (and, possibly, write) privileges on that directory.

Then you'd use it as 

impdp scott/tiger@orcl directory=IMP_DIR dumpfile=mydump.dmp logfile=imp.log
      -----                      -------
      is granted READ privilege  |
                                 directory object

Finally, mydump.dmp (or whatever its name is) must reside in that directory on the server.

Upvotes: 1

Related Questions