impdp 遭遇ORA-39113
源库：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produser :zjk，dba权限
table:t_zs_grjfmx
目标库：Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
user：zjk_test
已建源库的DBLink：zjk_link
使用impdp network_link 命令把源库中表t_zs_grjfmx的数据迁移到目标库的zjk_test用户下，命令impdp zjk_test/zjk_test@testDB network_link=zjk_link remap_schema=zjk:zjk_test remap_tablespace=TS_XT_DATA01:USERS TABLES=t_zs_grjfmx TABLES=t_sfzj_grjfmx
报错信息：
Import: Release 11.2.0.1.0 - Production on 星期二 6月 24 18:27:05 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: 内部错误
ORA-39113: 无法确定数据库版本
ORA-04052: 在查找远程对象 SYS.DBMS_UTILITY@MMZJKCS_LINK 时出错
ORA-00604: 递归 SQL 级别 3 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: , [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误
ORA-02063: 紧接着 2 lines (起自 MMZJKCS_LINK)
ORA-39097: 数据泵作业出现意外的错误 -4052
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.1.0
Information in this document applies to any platform.
***Checked for relevance on 13-Mar-2013***
SYMPTOMS
Datapump import fails with the following errors when importing into an 11g database from a 10g export:
ORA-39006: internal error
ORA-39113: Unable to determine database version
ORA-04052: error occurred when looking up remote object SYS.DBMS_UTILITY@<tns alias>
ORA-00604: error occurred at recursive SQL level 3
ORA-06544: PL/SQL: internal error, arguments: , [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error
ORA-02063: preceding 2 lines from <tns alias>
ORA-39097: Data Pump job encountered unexpected error -4052
ORA-39006: internal error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5233
ORA-06512: at line 2
CAUSE
This is due to unpublished bug 4511371 fixed in 11.1 and 10.2.0.2, where an interoperability issue occurs during remote PLSQL lookup of an object between 10g and 11g, as documented in Note:4511371.8.
SOLUTION
Apply the latest patchset to the 10g database, e.g.: 10.2.0.4 or 10.1.0.5.
REFERENCES
NOTE:4511371.8 - Bug 4511371 - ORA-6544 / ORA-4052 using PLSQL between 10g and 11g
相关内容
产品
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS
关键字
DATAPUMP;DBMS_UTILITY;IMPDP;INTEROPERABILITY;PLSQL
错误
ORA-2063;ORA-39006;ORA-39097;ORA-39113;ORA-4052;ORA-604;ORA-6512;ORA-6544;ORA-6553;PLS-801
具体参考：IMPDP From 10g TO 11g Gives ORA-39113, ORA-4052 & ORA-6544 PL/SQL: internal error, arguments: (文档 ID 1062428.1)
页:
[1]