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

Metalink Note 464672.1 lists the problem as Bug 6392040 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 Metalink Note 464672.1:

“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
Metalink Note 464862.1 - “EXP-00008 PLS-00201 When Performing Full Database Export After Applying CPUOCT2007″

Bug 6510213 - “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
  • 访问量
    232567