Exp-00008 Oracle Error 4063 Encountered
Contents |
12 October 2006 23:23 suvv Messages: 17Registered: October 2006 Junior Member Hi all, i am getting this error while doing export. Database 10.2.0 (Microsoft Windows Server 2003) ****************************************************** EXP-00008: ORACLE error
Exp 00008 Oracle Error 904 Encountered
4063 encountered ORA-04063: package body "SYS.DBMS_FILE_GROUP_EXP" has errors ORA-06508: PL/SQL: could not find exp 00008 oracle error 6552 encountered program unit being called: "SYS.DBMS_FILE_GROUP_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp EXP-00008: ORACLE error 4063 encountered ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp . exporting foreign function library names for user SYSADM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user SYSADM About to export SYSADM's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions EXP-00056: ORACLE error 4063 encountered ORA-04063: view "SYS.KU$_XMLSCHEMA_VIEW" has errors EXP-00000: Export terminated unsuccessfully *************************************************************** I have run the utlrp.sql script to recompile the packages and I have recompile all invalid objects. Some object I can not recompile. The error messages gives that they missing SYS.KU$_SCHEMAOBJ_T.I also get the message that SYS.DBMS_REGISTRY_SYS has errors.There is no object with the name 'SYSTEM' in the database.How can I get the object SYS.KU$_SCHEMAOBJ_T back? Report message to a moderator Re: EXP ERROR -Urgent [message #197889 is a reply to message #197858] Fri, 13 October 2006 02:29 pareshjavkar Messages: 7Registered: October 2006 Location: Mumbai Junior Member Hi, Try and execute ORACLE_HOME\rdbms\admin\catexp.sql and retry export. Also, if you can post your exp command. Report message to a moderator Re: EXP ERROR -Urgent [message #197899 is a reply to message #197858] Fri, 13 October 2006 03:19 suvv Messages: 17Registered: October 2006 Junior Member Thanx for ur reply ! i have tried the catexp.sql but it is still giving the error. any other suggestion for this ORA-04063: view "SYS.KU$_XMLSCHEMA_VIEW" has errors. Report message to a moderator Re: EXP ERROR -Urgent [message #197905 is a reply to message #197899] Fri, 13 October 2006 04:26 orausern Messages: 817Registe
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs http://www.orafaq.com/forum/t/70896/ Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release 10g Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesOracle: Oracle release 10g Forum I neeed major help, http://www.tek-tips.com/viewthread.cfm?qid=1423444 sys package missing while exp thread1177-1423444 Forum Search FAQs Links MVPs I neeed major help, sys package missing while exp I neeed major help, sys package missing while exp sillyVM (TechnicalUser) (OP) 2 Nov 07 11:24 EXP-00008: ORACLE error 4063 encounteredORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_RGT_EXP"ORA-06512: at line 1EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_expEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REFRESH_EXP_LWM"ORA-06512: at line 1EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.schema_info_expEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87ORA-06512: at line 1EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_expEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700ORA-06512: at line 1EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_expThat's what's showing during my exp of one of
procedural objects and actionsEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "WMSYS.LTUTIL" has errorsORA-06508: PL/SQL: http://olashowunmi.blogspot.com/2015/06/exp-00008-ora-04063-ora-06508-exp-00083.html could not find program unit being called: "WMSYS.LTUTIL"ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 1688ORA-06512: at line 1EXP-00083: The previous problem occurred when calling WMSYS.LT_EXPORT_PKG.schema_info_exp. exporting statisticsExport terminated successfully with warnings. CAUSES: 1. There are invalid objects in the WORKSPACE, XDB schemas. 2. Absence of execute privilege on oracle error UTL_FILE package from PUBLIC. SOLUTION: CAUSE 1: Connect as SYS and run $ORACLE_HOME/rdbms/admin/owminst.plb to allow the LT_EXPORT_PKG to be validated. CAUSE 2: 1. Grant execute privilege on SYS.UTL_FILE package to WMSYS user. SQL> grant execute on SYS.UTL_FILE to WMSYS; 2. check for invalid objects 00008 oracle error in the WMSYS schema using following query, SQL> select object_name,object_type,status from dba_objects where status='INVALID' and owner='WMSYS'; 3. Run script $ORACLE_HOME/rdbms/admin/utlrp.sql SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql Run the export again. Posted by olanrewaju showunmi at 06:34 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2016 (2) ► July (2) ▼ 2015 (15) ► July (6) ▼ June (2) EXP-00008, ORA-04063, ORA-06508, EXP-00083 PL/SQL:... Oracle RAC 11gR2: Listener INTERMEDIATE status wit... ► May (3) ► April (2) ► March (1) ► January (1) ► 2014 (7) ► September (4) ► August (3) ► 2013 (6) ► October (1) ► September (1) ► August (1) ► July (3) About Me olanrewaju showunmi View my complete profile Ethereal template. Powered by Blogger.