Exp-00008 Oracle Error 4068 Encountered
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn
Exp 00008 Oracle Error 904 Encountered
JavaScript back on and reload this page. Please enter a exp 00008 oracle error 6552 encountered title. You can not post a blank message. Please type your message and try again. More discussions in Advanced Queueing All PlacesDatabaseOracle Database + OptionsAdvanced Queueing This discussion is archived 1 Reply Latest reply on Feb 3, 2008 11:17 AM by zaffer khan, cisa ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77 - during export kogotok1 Jun 23, 2004 10:49 AM RDBMS Version: 8.1.7.3 Operating System and Version: Windows 2000 Error Number (if applicable): EXP-00008 Product (i.e. SQL*Loader, Import, etc.): Export EXP-00008: ORACLE error 1403 encountered I try to export 1 database user and get an error: . exporting posttables actions EXP-00008: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118 ORA-06512: at "SYS.DBMS_SQL", line 316 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135 ORA-06512: at line 1 EXP-00000: Export terminated unsuccessfully I've done some search on metallink for "EXP-00008: ORACLE error 1403 encount" and already found piece of advice to delete some system objects DELETE FROM SYS.EXPACT$ WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL' BUT I think it is not for me, because this database user has several queue tables: SELECT * FROM dba_queue_tables Extract from query output: CONTROL_QUEUE_TABLE OBJECT RIA.CONTROL_QUEUE_MESSAGE_T FEEDBACK_QUEUE_TABLE OBJECT RIA.FEEDBACK_QUEUE_MESSAGE_T INPUT_QUEUE_TABLE OBJECT RIA.INPUT_QUEUE_MESSAGE_T JOB_QUEUE_TABLE OBJECT RIA.JOB_QUEUE_MESSAGE_T OUTPUT_QUEUE_TABLE OBJECT RIA.OUTPUT_QUEUE_MESSAGE_T What could be the reason for the error and what could be the workaround ? Thanks in advance, Viacheslav 9852Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: ORA-06512
No.: 5,212 While exporting the database I got the following error in log file. Can anyone explain ho w to remove the error in export? EXP-00008: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 EXP-00083: The previous problem occurred https://community.oracle.com/thread/252990 when calling SYS.LT_EXPORT_PKG.schema_info_expDatabase version is Oracle9i Enterprise Edition Release 9.2.0.1.0. dave View Member Profile Oct 3 2006, 09:17 AM Post #2 Advanced Member Group: Members Posts: 5,208 Joined: 8-October 04 Member No.: 785 ORA-04063: package body "SYS.LT_EXPORT_PKG" has errorsfound out why and fix them milindb View Member Profile Oct 3 2006, 09:46 AM Post #3 Newbie http://dbaforums.org/oracle/index.php?showtopic=4781 Group: Members Posts: 5 Joined: 3-October 06 From: Pune Member No.: 5,212 I have compiled the package and it is perfectly fine and not giving error. Only during the time of export it shows the error... burleson View Member Profile Oct 3 2006, 01:11 PM Post #4 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 select comp_id, version, status from dba_registry;If status = "invalid", re-run AS SYS: catalog.sqlcatproc.sqlutlrp.sqlselect owner from dba_source where . . . = 'DBMS_METADATA'.and make sure it's owned by SYS -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference milindb View Member Profile Oct 5 2006, 01:09 AM Post #5 Newbie Group: Members Posts: 5 Joined: 3-October 06 From: Pune Member No.: 5,212 Thanks for the immediate reply. I tried the solution given by you. Now i am getting different error as,EXP-00056: ORACLE error 6502 encounteredORA-06502: PL/SQL: numeric or value errorLPX-00210: expected '<' instead of 'n'ORA-06512: at "SYS.UTL_XML", line 0ORA-06512: at "SYS.DBMS_METADATA_INT", line 3296ORA-
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 http://www.dbforums.com/showthread.php?994844-Oracle-8i-Export-failes you want to visit from the selection below. Results 1 to 1 of 1 http://www.cornbio.com/exp-00008-oracle-error-4067-encountered/ Thread: Oracle 8i Export failes Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-20-04,13:32 #1 alex_bg_99 View Profile View Forum Posts Visit Homepage Registered User Join Date Mar 2004 Posts 17 Unanswered: Oracle 8i Export failes Hello everyone I oracle error posted a question last week that my export failed. I got a response tried everything but still I am getting the same errors This is what I am doing exp SYSTEM/password FULL=y FILE=I:\data_exp\dba.dmp GRANTS=y ROWS=y log=I:\data_exp\exp_log.log I tried doing it as sys but I am getting the same thing I tried running catproc and catexp But still the same error occurs Also I was told to run owmcpkgb.plb to recreate SYS.LT_EXPORT_PKG package 00008 oracle error body, but I couldn't find the file anywhere in the oracle directory. So I am getting the following errors - this is the end of the log file. this is the beggining of the log file About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles EXP-00008: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141 ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting object type definitions . exporting system procedural objects and actions . exporting pre-schema procedural objects and actions EXP-00008: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body "ORDSYS.ORDTEXP" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling ORDSYS.ORDTEXP.schema_info_exp And this is the end . . exporting table PURCHASE_SONGS 0 rows exported . exporting referential integrity constraints .
ORA-04067: not executed, package body "SYSTEM.UTL_RAW" does not exist" I had no problem with exporting/importing in 8i, but I am having a hard time exporting with 10g. Read more 2012-05-03 22:16 EXP-00008: ORACLE error 600 encountered Export Problem I have following problem to export my database(Oracle9i Enterprise Edition Release 9.2.0.1.0 ). EXP-00008: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [26599], [1], [84], [], [], [], [], [] EXP-00000: Export terminated uns Read more 2012-05-28 16:47 export problen EXP-00008: ORACLE error 942 encountered oracle :9.2.0.6 os : linux problem : export I just installed oracle, without creating the database. (No database created) I just want to take an export backup of other server SID. I configured tnsnames.ora for the other. tnsping works fine. I connect Read more 2013-01-31 20:04 EXP-00008: ORACLE error 1555 encountered I'm doing an export full of my database and I received those errors . exporting post-schema procedural objects and actions EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14$" too sma Read more 2013-07-10 04:04 EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollb I am using 9i db With HP UX os While exporting we are geting the error like.. "EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small"" I am using UNDO ts which is having 2500 Read more 2013-10-26 20:48 EXP-00008: ORACLE error 1410 encountered EXP-00008: ORACLE error 1410 encountered ORA-01410: invalid ROWID Could anyone help me out to trouble shoot the error. Iam new to administration Read more 2014-01-24 21:19 Getting EXP-00008: ORACLE error 21779 encountered on export I'm trying to backup my database using export . But i'm getting following error. Here i'm giving the