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