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博客 ” ，链接：http://blog.itpub.net/24032200/viewspace-676247/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24032200/viewspace-676247/