OraFAQ Forum: Server Utilities » Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered

Home » RDBMS Server » Server Utilities » Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240832]

Sat, 26 May 2007 05:33

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
Fix/correct or drop this package.

Report message to a moderator

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

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....

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

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 ?

Report message to a moderator

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

BlackSwan
Messages: 26766
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

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...

Report message to a moderator

Previous Topic:	importing in 9i
Next Topic:	Import Excel Data into Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 00:47:30 CDT 2024