Data Pump Import of Large Partitioned Table Is Failing Over Db Link
(Doc ID 2478093.1)
Last updated on DECEMBER 07, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
On : 220.127.116.11 version, Import
Data pump across dblink with large partitioned table is failing with the following errors:
ORA-31693: Table data object "ADVTP853"."F_FAC_DTL":"Y2018M04" failed to load/unload and is being skipped due to error:
ORA-02049: timeout: distributed transaction waiting for lock
The issue still occurs even if the Merge Patch 26365838 which contains the fix for Bug 26228988 ORA-2049 USING DBMS_DATAPUMP AND NETWORK_LINK was applied.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document