OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » EXP ERROR -Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP ERROR -Urgent [message #197858]

Thu, 12 October 2006 23:23

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?

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: 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.

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: 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.

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: 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.

Report message to a moderator

Re: EXP ERROR -Urgent [message #197940 is a reply to message #197899]

Fri, 13 October 2006 06:27

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:52:29 CDT 2024