-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|