0

I am using this command:

impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log

to import data from one server to another.

this is my data_pump_dir path:/u01/app/oracle/admin/serv1/dpdump/

I have granted these privileges to the user:

grant datapump_exp_full_database to atif;
grant datapump_imp_full_database to atif;
grant read, write on directory data_pump_dir to system;

When I run the command, I get the following errors:

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file `"/u01/app/oracle/admin/serv1/dpdump/mltpltblbkp.dmp" for read`
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

can someone help here?

1 Answer 1

0

Data Pump runs on the database server and a Data Pump dumpfile import expects the dumpfile to be accessible on the database server, and not on the remote location where you started impdp. This is not the traditional import (imp) utility.

Copy the file to the specified location on the database server.

1
  • Thanks for your help!
    – dbafix
    May 10, 2023 at 18:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.