源端：

SQL> SELECT OBJECT_TYPE,STATUS,COUNT(*) cnt FROM dba_OBJECTS
2 Where owner=‘HSFSK’
3 GROUP BY OBJECT_TYPE,STATUS order by 1;

OBJECT_TYPE STATUS CNT

---

FUNCTION INVALID 1
FUNCTION VALID 158
INDEX VALID 1222
INDEX PARTITION VALID 579
LOB VALID 81
PROCEDURE VALID 688
SEQUENCE VALID 12
SYNONYM VALID 1
TABLE VALID 3576
TABLE PARTITION VALID 5682
TYPE VALID 2
VIEW VALID 65

12 rows selected

SQL> select count(*) from dba_OBJECTS
2 Where owner=‘HSFSK’;

COUNT(*)

 12067

目标端：

SQL> SELECT OBJECT_TYPE,STATUS,COUNT(*) cnt FROM dba_OBJECTS
2 Where owner=‘HSFSK’
3 GROUP BY OBJECT_TYPE,STATUS order by 1;

OBJECT_TYPE STATUS CNT

---

FUNCTION INVALID 159
INDEX VALID 1222
INDEX PARTITION VALID 579
LOB VALID 78
PROCEDURE INVALID 681
PROCEDURE VALID 7
SEQUENCE VALID 12
SYNONYM INVALID 1
TABLE VALID 3576
TABLE PARTITION VALID 4626
TYPE VALID 2
VIEW INVALID 61
VIEW VALID 4

13 rows selected

SQL> select count(*) from dba_OBJECTS
2 Where owner=‘HSFSK’;

COUNT(*)

 11008

导入导出语句

---

expdp system/sysdba@ORCLTEST directory=EXP_IMP_DATA dumpfile=06.dmp logfile=06.log SCHEMAS=HSFSK
impdp system/sysdba@orcl directory=DATA_PUMP_DIR dumpfile=06.dmp logfile=06.log schemas=HSFSK table_exists_action=replace

日志报错：

除了已存在和编译失效以外并无其他报错

附加问题：ALTER_PROCEDURE为什么会编译失效，使用@$ORACLE_HOME/rdbms/admin/utlrp.sql脚本结果为

OBJECTS WITH ERRORS

              0

ERRORS DURING RECOMPILATION

                      0

好像还是没编译成功。。。