Data pump network_link import with private Database Link Fails with ORA-04054 (Doc ID 2128750.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Running import with network_link using private connect to database link.
Query across the dblink works fine.

A data import across same network_link works fine.
Only the TTS network_link import fails with this error.

impdp system/oracle network_link=DPLINK logfile=nettimp.log
directory=dp_test_dir transport_tablespaces=TBSL
TRANSPORT_DATAFILES=/testcases/3-11877564441/joy.dbf

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing and Unified Auditing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-04054: database link DPLINK does not exist
ORA-39097: Data Pump job encountered unexpected error -4054

 

Cause

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