透過Database Link/IMPDP，同步10G、11G資料庫失敗

源庫10.2.0.1，目標庫11.2.0.3

impdp system/"xxxx" network_link=wdyx_prod schemas=wd_web,wanda parallel=4 TABLE_EXISTS_ACTION=REPLACE directory=dumpdir logfile=wdyx_trans.log VERSION=10.2

Import: Release 11.2.0.3.0 - Production on Tue Dec 20 23:13:02 2011

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
ORA-39006: internal error
ORA-39113: Unable to determine database version
ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 3
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from WDYX_PROD

ORA-39097: Data Pump job encountered unexpected error -4052

[@more@]

IMPDP From 10g TO 11g Gives ORA-39113, ORA-4052 & ORA-6544 PL/SQL: internal error, arguments: [55916]

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.