exp遇到错误ORA-06512 SYS.DBMS_EXPORT_EXTENSION

Linux5.5

Oracle10.2.0.4.0

 

从windows客户端使用exp导出全库时出现以下错误：

 

. . 正在导出表                     DEF$_AQCALL
EXP-00008: 遇到 ORACLE 错误 6550
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
. . 正在导出表                    DEF$_AQERROR
EXP-00008: 遇到 ORACLE 错误 6510
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . 正在导出表                   DEF$_CALLDEST
EXP-00008: 遇到 ORACLE 错误 6550
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
. . 正在导出表                DEF$_DEFAULTDEST
EXP-00008: 遇到 ORACLE 错误 6510
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . 正在导出表                DEF$_DESTINATION
EXP-00008: 遇到 ORACLE 错误 6550
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
. . 正在导出表                      DEF$_ERROR
EXP-00008: 遇到 ORACLE 错误 6510
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1

 

查看metalink发现，这个错误与ID 464672.1十分相似。

 

 

ORA-06512 SYS.DBMS_EXPORT_EXTENSION And PLS-00201 SYS.DBMS_DEFER_IMPORT_INTERNAL in 11g Export Or After OCTCPU2007 [ID 464672.1]
		Modified 20-JAN-2011 Type PROBLEM Status PUBLISHED

In this Document

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6 - Release: 10.1 to 11.1
Information in this document applies to any platform.

Symptoms

Checked for relevance on 10-22-2010

Running export utility in 11g or in 10g (After applying the OCTCPU2007 patch) may fail with the following errors:

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
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_SQL", line 1501
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1

Cause

This is was discussed in Bug 6392040:ORA-6512 ON SYS.DBMS_EXPORT_EXTENSION WHEN TRYING TO RUN FULL EXPORT

There are two execute privileges missing in the DBA role and the EXP_FULL_DATABASE role.

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

Conventional export is no longer supported in 11g.
http://download.oracle.com/docs/cd/B28359_01/readmes.111/b28280/toc.htm#BABGIGDC
section "2":

"The original Export utility is no longer supported for general use. ..."

For 10g versions there is another bug fix (5870297) in OCTCPU2007 patch that caused the problem.

Solution

The workaround for the problem is to grant the two missing privileges explicitly to the user doing the export:

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

 

 

按照文中给出的solution,授权之后再次导出，错误未再出现。

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

转载于:http://blog.itpub.net/10640532/viewspace-735262/