Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

exp schema

616200Jan 24 2009 — edited Jan 24 2009
i tried to export my particular schema
this is my test database.but all the tables exported properly
this is my export cmd:


exp userid=tsmsys1/tsmsys1@orclbkp file=tsmsys1.dmp log=tsmsys1.log

imp userid=tsmsys2/tsmsys2@orclbk file=tsmsys1.dmp log=tsmsys2.log ignore=y full=y

i ran a script below

sqlplus '/ as sysdba'
spool CreateDBCatalog.log
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/catalog.sql;
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/catexp7.sql;
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/catblock.sql;
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/catproc.sql;
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/catoctk.sql;
@$ORACLE_HOME/product/10.2.0.1.0/rdbms/admin/owminst.plb;
connect SYSTEM/manager
@$ORACLE_HOME/product/10.2.0.1.0/sqlplus/admin/pupbld.sql;
connect SYSTEM/manager
set echo on
spool sqlPlusHelp.log
@$ORACLE_HOME//product/10.2.0.1.0/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
spool off
exit;


i got the following error...


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 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_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP"
ORA-06512: at "SYS.DBMS_FILE_GROUP_EXP", line 634
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_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
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 TSMSYS1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TSMSYS1
About to export TSMSYS1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TSMSYS1's tables via Conventional Path ...
. . exporting table QQ 4 rows exported
. 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_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_SYS_EXP_INTERNAL"
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUE_TABLES", line 40
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUE_TABLES.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 "SYS.DBMS_FILE_GROUP_EXP", line 634
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_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
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 statistics
Export terminated successfully with warnings.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2009
Added on Jan 24 2009
3 comments
4,592 views