dbafix
Reputation: 83
Unable to use data pump utility in Oracle to import data to another server
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?
Upvotes: 0
Views: 651