导出命令：
exp fmc/fmc file=ccasrtdb_meta.dmp rows=n log=exp.log
结果： Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in US7ASCII character set and AL16UTF16 NCHAR character set Note: table data (rows) will not be exported
About to export specified users ... . exporting pre-schema procedural objects and actions EXP-00008: ORACLE error 4063 encountered ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_RGT_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_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 . exporting foreign function library names for user FMC . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user FMC About to export FMC's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export FMC's tables via Conventional Path ... . . exporting table ACTIVITY_TEMPL . . exporting table ACTIVITY_WORK_ITEM . . exporting table ACT_NOT_TEMPL . . exporting table ACT_TEMPL_RES_ASG . . exporting table AUDIT_TRAIL . . exporting table BLOCK_ACT_INST . . exporting table BLOCK_INST . . exporting table BLOCK_TEMPL . . exporting table CATEGORY . . exporting table CONTAINER . . exporting table CONTAINER_DATA_SEG . . exporting table CONTAINER_TEMPL . . exporting table CONTROL_CONNECTOR . . exporting table DATA_CONNECTOR . . exporting table DATA_STRUCTURE . . exporting table DATA_STRUCT_TEMPL . . exporting table DOMAIN . . exporting table ERROR_LOG . . exporting table GCON_MAPPING . . exporting table LEVEL_WF . . exporting table LOC_W_I_STUBS_SEG . . exporting table NOTIFICATION_ITEM . . exporting table ORGANIZATION . . exporting table ORG_HIERARCHY . . exporting table PERSON . . exporting table PERSON_WI_AMOUNT . . exporting table PER_AUTH_FOR_CATEG . . exporting table PER_AUTH_FOR_WITMS . . exporting table PER_HAS_ROLE . . exporting table PRIVATE_AI_LIST . . exporting table PRIVATE_PI_LIST . . exporting table PRIVATE_PT_LIST . . exporting table PRIVATE_WORK_LIST . . exporting table PROCESS_ACT_INST . . exporting table PROCESS_INST . . exporting table PROCESS_MODEL . . exporting table PROCESS_MODEL_SEG . . exporting table PROCESS_TEMPL . . exporting table PROC_INST_EXEC_RES . . exporting table PROC_SET_TEMPL . . exporting table PROGRAM . . exporting table PROGRAM_ACT_INST . . exporting table PROGRAM_EXEC_AGENT . . exporting table PROGRAM_IMPL_TEMPL . . exporting table PROGRAM_REG_TEMPL . . exporting table PUBLIC_AI_LIST . . exporting table PUBLIC_PI_LIST . . exporting table PUBLIC_PT_LIST . . exporting table PUBLIC_WORK_LIST . . exporting table QUEUE_MANAGER . . exporting table REM_W_I_STUBS_SEG . . exporting table ROLE_WF . . exporting table SERVER . . exporting table SESSION_WF . . exporting table SVR_INSTANCE_STATE . . exporting table SYSTEM_GROUP . . exporting table SYSTEM_LOG . . exporting table SYSTEM_STATE . . exporting table SYSTEM_WF . . exporting table SYS_GROUP_OID . . exporting table SYS_OBS_SYS . . exporting table WORK_ITEM . . exporting table WORK_ITEM_VIEW . 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_RGT_EXP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_RGT_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_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 . exporting statistics Export terminated successfully with warnings.
执行下面两个包后exp成功：
SQL > @$ORACLE_HOME/rdbms/admin/catalog.sql
SQL > @$ORACLE_HOME/rdbms/admin/catproc.sql
网上其它说明需要执行下面三个包，如果执行上面两个包的童鞋还是不成功可执行下面三个包试试。
执行包重建：
SQL > @$ORACLE_HOME/rdbms/admin/catalog.sql
SQL > @$ORACLE_HOME/rdbms/admin/catproc.sql
SQL > @$ORACLE_HOME/rdbms/admin/utlrp.sql
------
参考连接：http://www.boobooke.com/bbs/archiver/tid-54957.html
