PLS-00201和IMP-00013
来源:互联网 发布:网络电视机参数看哪些 编辑:程序博客网 时间:2024/05/17 03:16
春节上班的第二天,在导入一个用户数据的时候,发现一个报错:
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
巡查环境,发现数据库oracle被安全加固(各种限制sys用户下的东西不让普通用户使用)了
解决方法:
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO <user_name>;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO <user_name>;
开始重新导入,又有报错
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V11.01.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
猜想又是安全加固搞的鬼,导致权限缺失
解决方法:
grant dba to <user_name>;
开始重新导入,又有报错:
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>67,WHAT=>'P_ADD_PARTITION_WAREID;',NEXT_DATE="
">TO_DATE('2014-02-12:00:00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'trunc(sy"
"sdate + 1)',NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'DBMS_JOB' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
Import terminated successfully with warnings.
猜想又是安全加固搞的鬼,导致权限缺失
解决办法:
GRANT EXECUTE ON SYS.DBMS_JOB TO <user_name>;
总结:
1. GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO wsj;
2. GRANT DBA TO wsj;
3. GRANT EXECUTE ON SYS.DBMS_JOB TO wsj;
- PLS-00201和IMP-00013
- imp PLS-00302: component 'SET_NO_OUTLINES' must be declared【转载】
- pls:00201 00304
- set_sql_trace_in_session PLS-00201
- oracle pls-00201 问题
- Error: PLS-00201
- Error: PLS-00201
- Error: PLS-00201
- PLS-00201错怎么解决
- PLS-00201 DBMS_AQ 看不到问题
- imp报IMP-00010,IMP-00013错误
- IMP-00013
- IMP-00013
- imp-00013
- imp PLS-00302: component 'SET_NO_OUTLINES' must be declared 问题的处理
- 嵌套表事例和PLS-00642问题
- PLS-00201:必须说明标识符‘SHOW_SPACE'
- 创建oracle快照时报PLS-00201:
- iOS上下左右-滑动手势
- hdu——3785——寻找大富翁
- java.sql.SQLException: ORA-00907: missing right parenthesis
- progra~1
- oracle常用ASM操作命令
- PLS-00201和IMP-00013
- 深入浅出函数副作用
- css3可折叠式/手风琴式面板(ie8及以下不兼容)
- 【PAT1032】Sharing 找两单词链表的相同后缀
- 用PS从图片上找配色方案
- Bug笔记:Google Map第一次缩放位置偏移
- 业务逻辑和算法
- 起初的挑食对于孩子来说是自然反应
- myeclipse手动安装android插件(摘抄)