Data Pump Import of Large Partitioned Table Is Failing Over Db Link
(Doc ID 2478093.1)
Last updated on NOVEMBER 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Import
Data pump across dblink with large partitioned table is failing with the following errors:
ORA-31693: Table data object "<OWNER>"."<TABLE_NAME>":"<PARTITION_NAME>" 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