ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【转载-ORACLE】ORA-6512 During Full Export

【转载-ORACLE】ORA-6512 During Full Export

原创 Linux操作系统 作者:浪漫双鱼 时间:2012-01-17 10:50:21 0 删除 编辑

exp 全库时报错

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifierSYS.DBMS_DEFER_IMPORT_INTERNALmust be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at “SYS.DBMS_SYS_SQL”, line 1204
ORA-06512: at “SYS.DBMS_SQL”, line 323
ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 97
ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 126
ORA-06512: at line 1

lists the problem as and provides a solution.

GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO ;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO ;

One important statement to consider from :

“There is no fix in this bug because the export utility is no longer supported in 11g and should be replaced by the Data Pump Export.”

Additional References
- “EXP-00008 PLS-00201 When Performing Full Database Export After Applying CPUOCT2007″

- “INSTALLED CPUOCT2007; NOW EXP GETS THE ERRORS EXP-00008,ORA-06550,PLS-00201


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11088128/viewspace-715002/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    87
  • 访问量
    242648