Tracing datapump

Handy if you get a ORA-00942 from a datapump import - you can track down where it actually went wrong and work out how to fix it

impdp DUMPFILE=expdp.dmp LOGFILE=expdp.log TRACE=1FF0300

In our case some of the objects in the source database (oralce interal ones) were not the current version (no idea why)

catalog/catproc fixed the issue and the problem went away - the key was to find out which table was missing and track that back to the source files under @?/rdbms/admin

Comments