Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm using a command:

$ exp userid=apex_public_user/apex_public_user OWNER=apex_public_user DIRECT=Y CONSISTENT=Y FILE=/home/oracle/apex_public_user.dmp

and getting following output:

Export: Release 10.2.0.1.0 - Production on Fr May 18 11:55:20 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
. exporting foreign function library names for user APEX_PUBLIC_USER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user APEX_PUBLIC_USER
About to export APEX_PUBLIC_USER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export APEX_PUBLIC_USER's tables via Direct Path ...
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

What can be wrong with the way how I export a schema? The same error appears while exporting any other schemas.

share|improve this question
    
Is this a production database, because it's very broken? You need to run some scripts to recreate internal database objects.... –  FreshPhilOfSO May 18 '12 at 8:35
    
Yes, this base is in use on the server. –  Kremchik May 18 '12 at 8:45
add comment

migrated from superuser.com May 18 '12 at 8:27

This question came from our site for computer enthusiasts and power users.

1 Answer

Your database is unhappy.

Login to your Linux box as the DB owner user (usually oracle), restart it & then do the following to recreate the broken data dictionary objects:

sqlplus / as sysdba

@?/rdbms/admin/catrepr.sql

@?/rdbms/admin/catrep.sql 

@?/rdbms/admin/utlrp.sql

Restart the database once done.

This is an unusual situation to be in - Has the DB been recently upgraded?

share|improve this answer
    
Thank you Phil! I don't have catrepr.sql file, though. I have catreps.sql instead. So, should I do the following: 1) shutdown 2) startup 3) run scripts 4) shutdown 5) startup? –  Kremchik May 18 '12 at 15:48
    
Yes. In that order –  FreshPhilOfSO May 18 '12 at 17:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.