[Oracle] expdp ORA-39006, ORA-39065 Solution

[Oracle] expdp ORA-39006, ORA-39065 solution the next day the new company went to work and received a task: migrating data from the production database to the development database, when I was eager to use expdp to export data, the following internal error occurred. It is no wonder that the DBA used expdp/impdp as a powerful tool, instead of using old exp/imp, it turns out to be plagued by this problem.

[SQL] 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. Execute the following script to regenerate the views and tables used by the datapump api:

[SQL] 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 use expdp/impdp to replace the old exp/imp, which can improve the work efficiency. So, do not back down the problem and solve it once, this greatly facilitates future work.