IMPDP failing with ORA-06512: at "SYS.UTL_FILE", line 536
Hi,
I am using Oracle DB SEONE 11.2.0.4 on Oracle Linux Updated 4.
I am trying to do an import of a dump file created by database 11.2.0.1.
This is the command I am using:
impdp directory=DATA_PUMP_DIR \
schemas= ABC,DBV,NMB \
dumpfile=DATA_PUMP_DIR:sqa.dmp logfile=DATA_PUMP_DIR:sqaimp.log
The user I am trying to impdp is SYSTEM and I did grant user 'system' read, write privileges on directory DATA_PUMP_DIR which points to /tmp/oracle/export.
IMPDP is being run by the user 'oracle' at os level and it has privileges to create,read files in /tmp/oracle/export.
I am using Oracle DB SEONE 11.2.0.4 on Oracle Linux Updated 4.
I am trying to do an import of a dump file created by database 11.2.0.1.
This is the command I am using:
impdp directory=DATA_PUMP_DIR \
schemas= ABC,DBV,NMB \
dumpfile=DATA_PUMP_DIR:sqa.dmp logfile=DATA_PUMP_DIR:sqaimp.log
The user I am trying to impdp is SYSTEM and I did grant user 'system' read, write privileges on directory DATA_PUMP_DIR which points to /tmp/oracle/export.
IMPDP is being run by the user 'oracle' at os level and it has privileges to create,read files in /tmp/oracle/export.
0