EXP-00056: ORACLE error 4068 encountered
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: EXP-00056: ORACLE error 4068 encountered

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    99

    EXP-00056: ORACLE error 4068 encountered

    Hello All,

    Version Oracle : 9.2.0.4
    OS : AIX

    I am unale to export. I have searched for this error in almost all the user group, but I am not able to find a solution for this exp-00056 followed by 4068 error.
    I did drop the XDB user, tablespace and recreated it by executing @catqm.sql.
    I have executed catmeta.sql.
    I did most of the advice that I found in the user group.
    But still I am unable to exprot, I always have the following error
    could you please help me

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user MAUSER
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user MAUSER
    About to export MAUSER's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    EXP-00056: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been discarded
    ORA-04067: not executed, package body "SYS.DBMS_XMLGEN" does not exist
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "SYS.DBMS_METADATA", line 345
    ORA-06512: at "SYS.DBMS_METADATA", line 410
    ORA-06512: at "SYS.DBMS_METADATA", line 449
    ORA-06512: at "SYS.DBMS_METADATA", line 1156
    ORA-06512: at "SYS.DBMS_METADATA", line 1141
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully

    Thanks
    Naeem

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

    Re: EXP-00056: ORACLE error 4068 encountered

    Originally posted by Naeem
    Hello All,

    Version Oracle : 9.2.0.4
    OS : AIX

    I am unale to export. I have searched for this error in almost all the user group, but I am not able to find a solution for this exp-00056 followed by 4068 error.
    I did drop the XDB user, tablespace and recreated it by executing @catqm.sql.
    I have executed catmeta.sql.
    I did most of the advice that I found in the user group.
    But still I am unable to exprot, I always have the following error
    could you please help me

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user MAUSER
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user MAUSER
    About to export MAUSER's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    EXP-00056: ORACLE error 4068 encountered
    ORA-04068: existing state of packages has been discarded
    ORA-04067: not executed, package body "SYS.DBMS_XMLGEN" does not exist
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "SYS.DBMS_METADATA", line 345
    ORA-06512: at "SYS.DBMS_METADATA", line 410
    ORA-06512: at "SYS.DBMS_METADATA", line 449
    ORA-06512: at "SYS.DBMS_METADATA", line 1156
    ORA-06512: at "SYS.DBMS_METADATA", line 1141
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully

    Thanks
    can you compile that package

  3. #3
    Join Date
    Apr 2001
    Posts
    99
    Thanks for your reply,

    It was in the valid state. I have re-compiled it.
    No change.Still the same error
    Naeem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width