Unable to use data pump utility in Oracle to import data to another server

0 votes

1 answer

245 views

backup restore linux oracle-12c datapump

                          I am using this command:

    impdp atif/atif@192.168.67.68: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?

Asked by dbafix (64 rep)

May 10, 2023, 05:45 PM
Last activity: May 29, 2025, 10:05 AM

Unable to use data pump utility in Oracle to import data to another server

Related Questions