Symptoms:
DataPump job fails with the following errors:
[oracle@ebsdb01 expdp]$ expdp system/manager tables=employees directory=EXPDP dumpfile=emp_data.dmp logfile=expdp.log
Export: Release 11.2.0.4.0 - Production on Thu Jun 10 15:19:55 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
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
Cause:
Some DataPump Metadata stored in the METANAMETRANS$ table was missing. You can verify this by selecting from the table which will likely return no rows.
SQL> connect / as sysdba
SQL> select count(*) from metanametrans$;
COUNT(*)
----------
0
While on a database where this table is correctly populated, should return many rows similar to the following run against a 11.2.0.4 database:
SQL> select count(*) from metanametrans$;
COUNT(*)
----------
3393
Solution:
Run the following scripts connected as SYSDBA to correctly populate this table required by DataPump, then re-run the export. The database does not need to be in restricted mode to run the scripts.
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/catmet2.sql
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Compile the invalid objects.
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
Check the count of the METANAMETRANS$ table now.
SQL> select count(*) from metanametrans$;
COUNT(*)
----------
3393
Run the export job again.
[oracle@ebsdb01 expdp]$ expdp system/manager tables=employees directory=EXPDP dumpfile=emp_data.dmp logfile=expdp.log
The export operation runs successfully now.