Oracle Error 4068 Encountered
! Exp ORACLE error 4068 encountered in oracle 9i If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: URGENT ! Exp ORACLE error 4068 encountered in oracle 9i Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-09-2003,05:52 AM #1 castlerock View Profile View Forum Posts Member Join Date Jan 2003 Posts 141 URGENT ! Exp ORACLE error 4068 encountered in oracle 9i hi, When taking full export dump i got the following error.Can anyone tell me how to solve the problem. . exporting posttables actions EXP-00008: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: has errors ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120 ORA-06512: at "SYS.DBMS_SQL", line 316 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 86 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 137 ORA-06512: at line 1 EXP-00000: Export terminated unsuccessfully Thanks, Ramesh Reply With Quote 01-09-2003,06:48 AM #2 adewri View Profile View Forum Posts Visit Homepage Oracle Monk Join Date Nov 2002 Location New Delhi, INDIA Posts 1,796 run 'catnoqueue.sql' then try. HTH Amar Amar "There is a difference between knowing the path and walking the path." Reply With Quote 01-09-2003,07:08 AM #3 castlerock View Profile View Forum Posts Member Join Date Jan 2003 Posts 141 EXP error 04068 error in oracle 9i hel needed hi , Thanks for the reply,When i run the catnoque.sql ..i got some errors. drop type sys.aq$_recipients * ERROR at line 1: ORA-02303: cannot drop
error... From: Denmark Weatherburne friend Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered [message #240832] Sat, 26 May 2007 05:33 Alpicus Messages: 4Registered: 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: 24958Registered: 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: 4Registered: 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: ident