Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP error when trying to import a table from another database

2819810Sep 3 2014 — edited Sep 3 2014

I ran the impdp command below but got the errors. First time trying to copy a table from the production database to a dev database. The dev database was created recently from a RMAN restore of the production database so the users/tablespaces/directories...etc everything should be the same. The dev database shows DB_EXPORT_DIR already exists so I'm asusming this "schemauser" is maybe not allowed?

impdp schemauser/password@devdb TABLES=TEST directory=DB_EXPORT_DIR dumpfile=TEST.dmp LOGFILE-impdpTEST.log

ORA-39002: Invalid Operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DB_EXPORT_DIR is invalid

Another thought I had was if I run impdp as SYS/password@devdb how can I get it to import the table into the "schemauser" schema?