IMPDP Over Database Link From A Remote Server Fails With ORA-03106
(Doc ID 1916314.1)
Last updated on SEPTEMBER 25, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
When importing Database/Schema and using NETWORK_LINK and PARALLEL the following errors are raised:
ORA-31693: Table data object "<schema>"."<table>" failed to load/unload and is being skipped due to error:
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from <network_link>
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from <network_link>
The import parameter file looks similar to this:
LOGFILE=DATA_PUMP_DIR:IMPORT.LOG
REMAP_TABLESPACE=USERS:DUMMY
NETWORK_LINK=DUMMY_LINK
PARALLEL=4
TABLE_EXISTS_ACTION=REPLACE
SCHEMAS=DUMMY
INCLUDE=TABLE:" IN ('A','B','C')"
REMAP_TABLESPACE=USERS:DUMMY
NETWORK_LINK=DUMMY_LINK
PARALLEL=4
TABLE_EXISTS_ACTION=REPLACE
SCHEMAS=DUMMY
INCLUDE=TABLE:" IN ('A','B','C')"
Solution
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
| Goal |
| Solution |
| References |