Question:
I was running a data pump export (expdp) when I get
these errors ORA-391326 and ORA-04067:
ORA-39126: Worker
unexpected fatal error in
KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04067: not
executed, package body "SYS.DBMS_METADATA" does not exist
How can I stop this error and continue my
export?
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:
select
owner,
object_name,
object_type,
status
from
dba_objects
where
object_name='DBMS_METADATA';
Here are the scripts to run as a SYSDBA user to install
the dbms_metadata packages:
$ORACLE_HOME/rdbms/admin/prvtmeta.plb
$ORACLE_HOME/rdbms/admin/utlrp.sql
Running these script will install dbms_metadata
and prevent these expdp errors.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
