Home » RDBMS Server » Server Administration » EXP ERROR -Urgent
EXP ERROR -Urgent [message #197858] Thu, 12 October 2006 23:23 Go to next message
suvv
Messages: 17
Registered: 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 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?

Re: EXP ERROR -Urgent [message #197889 is a reply to message #197858] Fri, 13 October 2006 02:29 Go to previous messageGo to next message
pareshjavkar
Messages: 7
Registered: 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.
Re: EXP ERROR -Urgent [message #197899 is a reply to message #197858] Fri, 13 October 2006 03:19 Go to previous messageGo to next message
suvv
Messages: 17
Registered: 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.
Re: EXP ERROR -Urgent [message #197905 is a reply to message #197899] Fri, 13 October 2006 04:26 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Try running utlrp.sql and see if that helps..(the script is in <oracle_home>/rdbms/admin folder.

If still the error persists, then it means that your installation is having problems. You may take a cold backup of the database, deinstall oracle and reinstall it. The error should be gone. Or you can first open a TAR with oracle support and get their advice.
Re: EXP ERROR -Urgent [message #197940 is a reply to message #197899] Fri, 13 October 2006 06:27 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This is to do with XML/XDB objects.
If you are not using those, just uninstall them.
If you ar using those or would like to leave it as-is,
login as SYS
run catmetx.sql then
run utlrp.sql


Previous Topic: grant problems
Next Topic: Best practices for implementing schema changes
Goto Forum:
  


Current Time: Thu Dec 12 04:08:51 CST 2024