Solutions to EXPDP ORA-39006 and ORA-39065 in Oracle

The new company to work the next day, received a task: the data on the production library to the development of the library, when I am ready to use EXPDP export data, the following internal error, no wonder before the DBA placed EXPDP/IMPDP this sharp weapon does not have to use the old exp/ Imp, it turns out, is plagued by this problem.

Ora-39006:internal error  
ora-39065:unexpected Master process exception in DISPATCH  
ora-01403:no data found
 
  ora-39097:data Pump Job encountered unexpected error 100
 

This problem is easy to solve, and the following script is used to regenerate the views and tables that the DataPump API uses:

Sqlplus/as sysdba  
sql>@ $ORACLE _home/rdbms/admin/catmeta.sql   
sql>@ $ORACLE _home/rdbms/admin/ Catmet2.sql   
sql>@ $ORACLE _home/rdbms/admin/utlrp.sql

Now I can finally replace the old exp/imp with EXPDP/IMPDP, work efficiency can improve a large section, so said, encounter problems do not shrink, once resolved, you can greatly facilitate later.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/