This content has been marked as final. Show 4 replies
Is there any error in alert.log? Please see:
How To Resolve The Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 When DataPump Export Fails [ID 790163.1]
DataPump Export (EXPDP) To A Windows Mapped Network Drive Returns Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 [ID 858401.1]
I was trying to import into a database which i have only the details, but i have no access to db machine, which i think was the problem.
dmp file easily got imported to database present in the systems which i had access.
Following are my conclusions based on the experiments, correct me if I'm wrong:
1. Basically these are errors when db system cant read/write/access the directory structure pointed by directory in database.
2. This can be achieved by mounting the directory in which dmp is present to the system where database is present.
2. We cannot import using impdp just by having tns details of the db, we need to have access to db system.