Database Data Pump Export fails with PLS-00201 identifier must be declared
出现问题如下：
ORA-39127: unexpected error from call to export_string :=EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp('HNMJSYS',1,1,'10.02.00.01.00',newblock)
ORA-06550: line 1, column 12:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_METADATA", line 5419
ORA-39127: unexpected error from call to export_string :=EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp('HNMJPRIV',1,1,'10.02.00.01.00',newblock)
ORA-06550: line 1, column 12:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_METADATA", line 5419
上METALINK上查看了一下
出现这个错误有两种原因：
1、用户EXFSYS用户事物处于无效状态
2、用户EXFSYS用户的事物被删除
通过select username,user_id from dba_users where username='EXFSYS';
查无此用户
解决方法：
1、Start SQLPlus.
2、Connect with user SYS as SYSDBA and issue the following commands:
SQL>DELETE FROM exppkgact$ WHERE SCHEMA='EXFSYS';
SQL>EXIT
问题解决！
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24032200/viewspace-676247/ ，如需转载，请注明出处，否则将追究法律责任。
