DBMS_METADATA Is Missing During expdp

The Error Appear During The expdp Database , And Looks

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04067: not executed, package body “SYS.DBMS_METADATA” does not exist
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_METADATA”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 62
ORA-06512: at “SYS.KUPW$WORKER”, line 6226

Cause:

 SYS.DBMS_METADATA Is Missing .

Solution :

Check if the above object exists

SELECT owner, object_name, object_type, status FROM dba_objects WHERE  object_name=’DBMS_METADATA’;

Not Found :

$ORACLE_HOME/rdbms/admin/prvtmeta.plb
$ORACLE_HOME/rdbms/admin/utlrp.sql

2 responses to “DBMS_METADATA Is Missing During expdp”

  1. Hi Osama, I live in Kent, England, and I am trying to get hold of a copy of your book Oracle Penetration Testing but not having any enjoy .. Would it be possible for you to send me a link please or let me how I can order it..Many Thanks.Kevin

    Like

  2. Hi Kevin , the book is not published Yet , It will be Published in 2013 🙂

    Like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.