EXP-00056：ORA-06550:PLS-00201: identifier ‘SYS.DBMS_EXPORT_EXTENSION’ must be declared

1.问题

EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 15:
PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored

EXP-00000: Export terminated unsuccessfully

发现DBMS_EXPORT_EXTENSION已经失效

给某一用户授权后
使用该用户进行exp成功，DBMS_EXPORT_EXTENSION恢复有效。

2.解决办法

linux系统

su - oracle

管理员身份登陆

sqlplus 'h*****ross/"password"' as  sysdba

修改导出权限给某一用户g*****ross

GRANT execute on SYS.DBMS_EXPORT_EXTENSION to g*****ross;

--同样导入 GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO g*****ross;

参考：https://oracledbazone.com/2012/05/25/pls-00201-identifier-sys-dbms_export_extension-must-be-declared/

http://www.360doc.com/content/10/1231/09/5287961_82832537.shtml