導(dǎo)出報(bào)如下錯(cuò)誤：
連接到: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已導(dǎo)出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即將導(dǎo)出整個(gè)數(shù)據(jù)庫...
. 正在導(dǎo)出表空間定義
. 正在導(dǎo)出概要文件
. 正在導(dǎo)出用戶定義
. 正在導(dǎo)出角色
. 正在導(dǎo)出資源成本
. 正在導(dǎo)出回退段定義
. 正在導(dǎo)出數(shù)據(jù)庫鏈接
. 正在導(dǎo)出序號
. 正在導(dǎo)出目錄別名
. 正在導(dǎo)出上下文名稱空間
. 正在導(dǎo)出外部函數(shù)庫名
. 導(dǎo)出 PUBLIC 類型同義詞
. 正在導(dǎo)出專用類型同義詞
. 正在導(dǎo)出對象類型定義
. 正在導(dǎo)出系統(tǒng)過程對象和操作
. 正在導(dǎo)出 pre-schema 過程對象和操作
. 正在導(dǎo)出簇定義
. 即將導(dǎo)出 SYSTEM 的表通過常規(guī)路徑...
. . 正在導(dǎo)出表 DEF$_AQCALL
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
. . 正在導(dǎo)出表 DEF$_AQERROR
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
. . 正在導(dǎo)出表 DEF$_CALLDEST
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
. . 正在導(dǎo)出表 DEF$_DEFAULTDEST
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
. . 正在導(dǎo)出表 DEF$_DESTINATION
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
. . 正在導(dǎo)出表 DEF$_ERROR
EXP-00008: 遇到 ORACLE 錯(cuò)誤 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
解決方法：
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO user_doing_export;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO user_doing_export;
