Exp-00008 Oracle Error 4063
Contents |
12 October 2006 23:23 suvv Messages: 17Registered: October 2006 Junior Member Hi all, i am getting this error exp 00008 oracle error 904 encountered while doing export. Database 10.2.0 (Microsoft Windows Server 2003) ******************************************************
Exp 00008 Oracle Error 6552 Encountered
EXP-00008: ORACLE error 4063 encountered ORA-04063: package body "SYS.DBMS_FILE_GROUP_EXP" has errors ORA-06508: PL/SQL: could not find 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
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 http://www.orafaq.com/forum/t/70896/ posting is forbidden.Tek-Tips Posting Policies Jobs 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 http://www.tek-tips.com/viewthread.cfm?qid=1423444 HomeForumsProgrammersDBMS PackagesOracle: Oracle release 10g Forum I neeed major help, 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", l
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 JavaScript back on and reload this page. Please enter a title. You can not post a blank message. https://community.oracle.com/thread/1040955?start=15&tstart=0 Please type your message and try again. More discussions in General Database Discussions http://olashowunmi.blogspot.com/2015/06/exp-00008-ora-04063-ora-06508-exp-00083.html All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 Previous Next 32 Replies Latest reply on Apr 1, 2010 11:29 AM by 595435 Go to original post This content has been marked as final. Show 32 replies 15. Re: full DB export errors... shabs_dba Mar 5, 2010 8:51 AM (in response to 595435) hi, oracle error catproc is in invalid status. however, inaddition to this check the status of the DBMS_LOGREP_EXP package. select object_name,object_type,status from dba_objects where object_name='DBMS_LOGREP_EXP'; if status showing invalid then try to recompile the package. even after recompile,if its showing invalid then you need to rerun the catproc.sql thank you, Like Show 0 Likes(0) Actions 16. Re: full DB export errors... 595435 Mar 5, 2010 8:52 AM (in response to Neev) How does 00008 oracle error other users can do full DB export? Like Show 0 Likes(0) Actions 17. Re: full DB export errors... Neev Mar 5, 2010 8:58 AM (in response to Neev) . Like Show 0 Likes(0) Actions 18. Re: full DB export errors... 595435 Mar 5, 2010 8:57 AM (in response to shabs_dba) OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ---------------------------------------- DBMS_LOGREP_EXP PACKAGE BODY VALID DBMS_LOGREP_EXP PACKAGE VALID SQL> Like Show 0 Likes(0) Actions 19. Re: full DB export errors... Neev Mar 5, 2010 8:58 AM (in response to 595435) Invoking Export As SYSDBA SYSDBA is used internally and has specialized functions; its behavior is not the same as for generalized users. Therefore, you should not typically need to invoke Export as SYSDBA. However, there may be a few situations in which you need to do so, usually at the request of Oracle technical support. Like Show 0 Likes(0) Actions 20. Re: full DB export errors... 595435 Mar 5, 2010 9:48 AM (in response to Neev) okay, then how can I do the full DB export? Does any other user can do full db export except sys/system? Like Show 0 Likes(0) Actions 21. Re: full DB export errors... Neev Mar 5, 2010 9:51 AM (in response to 595435) Rakesh, Just provide s
procedural objects and actionsEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "WMSYS.LTUTIL" has errorsORA-06508: PL/SQL: 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 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 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 tem