【第22期】观点:IT 行业加班,到底有没有价值?

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

原创 2016年08月29日 09:33:22

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

版权声明:本文为博主原创文章,未经博主允许不得转载。 举报

相关文章推荐

imp PLS-00302: component 'SET_NO_OUTLINES' must be declared 问题的处理

Subject:PLS-00302-SET_NO_OUTLINES must be declared When Using 10.2 Export UtilityDoc ID:NOTE:339062....
  • aicon
  • aicon
  • 2009-09-23 17:45
  • 716

存储过程异常 ORA-06550 PLS-00201: identifier 'STU_RS' must be declared

java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'STU_RS' must be declared ORA-06550: line 1, column 7: PL/SQL: St...

程序员升职加薪指南!还缺一个“证”!

CSDN出品,立即查看!

oracle adg PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared

在使用adg搭建第二个从库的时候,遇到了下面的错误提示: DBGSQL: TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end; DBGSQL:...

Oracle exp 报错:PLS-00302: component 'SET_NO_OUTLINES' must be declared

EXP-00056: 遇到 ORACLE 错误 6550 ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, colum...
  • Wuaner
  • Wuaner
  • 2010-12-30 22:05
  • 2945

Oracle 9i EXP XDB.DBMS_XDBUTIL_INT must be declared

AnexportfromanOracle9idatabasefailswith:<span style="font-family: 'Time
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)