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
Post a Comment