exp schema
616200Jan 24 2009 — edited Jan 24 2009i 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.