I was running a data pump export (expdp) when I get
these errors ORA-391326 and ORA-04067:
unexpected fatal error in
executed, package body "SYS.DBMS_METADATA" does not exist
How can I stop this error and continue my
Answer: The dbms_metadata
package was not create at database install time, and that is
the root cause of the ORA-38136 and ORA-04067 error.
The solution is to add these dbms_metadata packages
to the data dictionary by executing these scripts:
You can cinform that this is the root cause by running
this SQL query:
Here are the scripts to run as a SYSDBA user to install
the dbms_metadata packages:
Running these script will install dbms_metadata
and prevent these expdp errors.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.