Home » RDBMS Server » Server Utilities » Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered
Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240832] Sat, 26 May 2007 05:33 Go to next message
Alpicus
Messages: 4
Registered: May 2007
Junior Member
Hi,

Using Oracle 9.2.0.3, I receive the following error : EXP-00056: ORACLE error 4068 encountered
when exporting from Enterprise Manager console...I?ve searched on the web for a solution withuout result.

Thanks in advance.

Below the end of the export log :

. exporting operators
. exporting referential integrity constraints
. exporting triggers
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Phil
Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240851 is a reply to message #240832] Sat, 26 May 2007 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
Fix/correct or drop this package.
Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240857 is a reply to message #240851] Sat, 26 May 2007 10:29 Go to previous messageGo to next message
Alpicus
Messages: 4
Registered: May 2007
Junior Member
anacedent wrote on Sat, 26 May 2007 08:55
>ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
Fix/correct or drop this package.


When I compile, I have these errors below. If I drop the package, I suppose the export will not work either...

(some keywords are in french because Win2003 has french regional settings) :

Numéro de ligne = 63 Numéro de colonne = 17 Texte d'erreur = PLS-00306: wrong number or types of arguments in call to 'IS_HIERARCHY_ENABLED_INTERNAL'
Numéro de ligne = 63 Numéro de colonne = 7 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 76 Numéro de colonne = 29 Texte d'erreur = PLS-00302: component 'GENERATE_TRGNM' must be declared
Numéro de ligne = 76 Numéro de colonne = 7 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 110 Numéro de colonne = 37 Texte d'erreur = PLS-00302: component 'TRUNCATE_NAME' must be declared
Numéro de ligne = 110 Numéro de colonne = 9 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 125 Numéro de colonne = 7 Texte d'erreur = PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared
Numéro de ligne = 125 Numéro de colonne = 7 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 137 Numéro de colonne = 37 Texte d'erreur = PLS-00302: component 'TRUNCATE_NAME' must be declared
Numéro de ligne = 137 Numéro de colonne = 9 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 155 Numéro de colonne = 33 Texte d'erreur = PLS-00302: component 'TRUNCATE_NAME' must be declared
Numéro de ligne = 155 Numéro de colonne = 9 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 170 Numéro de colonne = 7 Texte d'erreur = PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared
Numéro de ligne = 170 Numéro de colonne = 7 Texte d'erreur = PL/SQL: Statement ignored
Numéro de ligne = 183 Numéro de colonne = 33 Texte d'erreur = PLS-00302: component 'TRUNCATE_NAME' must be declared
Numéro de ligne = 183 Numéro de colonne = 9 Texte d'erreur = PL/SQL: Statement ignored

So it cannot be compiled....
Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240860 is a reply to message #240832] Sat, 26 May 2007 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Possible known bug.
Note:256548.1
One possible solution is to upgrade to V9.2.0.5 or higher
Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240861 is a reply to message #240860] Sat, 26 May 2007 12:24 Go to previous messageGo to next message
Alpicus
Messages: 4
Registered: May 2007
Junior Member
anacedent wrote on Sat, 26 May 2007 12:19
Possible known bug.
Note:256548.1
One possible solution is to upgrade to V9.2.0.5 or higher


I couldn't find any upgrade on Oracle website so I suppose it's in Metalink but I don't have any credentials to enter in.

Where can I find the upgrade ?
Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240862 is a reply to message #240832] Sat, 26 May 2007 12:36 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Where can I find the upgrade ?
http://metalink.oracle.com is the only place I know which contains all the patchsets.
You're On Your Own (YOYO)!

[Updated on: Sat, 26 May 2007 12:37] by Moderator

Report message to a moderator

Re: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240863 is a reply to message #240862] Sat, 26 May 2007 12:39 Go to previous message
Alpicus
Messages: 4
Registered: May 2007
Junior Member
anacedent wrote on Sat, 26 May 2007 12:36
>Where can I find the upgrade ?
http://metalink.oracle.com is the only place I know which contains all the patchsets.
You're On Your Own (YOYO)!


OKay. Thanks for your help and advice to upgrade. I will go to this direction...
Previous Topic: importing in 9i
Next Topic: Import Excel Data into Oracle
Goto Forum:
  


Current Time: Sat Dec 10 20:17:38 CST 2016

Total time taken to generate the page: 0.16791 seconds