【轉載-ORACLE】ORA-6512 During Full Export

浪漫雙魚發表於2012-01-17
OracleExport

exp 全庫時報錯

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL’ must 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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章