IMPDP Over Database Link From A Remote Server Fails With ORA-03106 (Doc ID 1916314.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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>


 
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')"

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms