My Oracle Support Banner

TTS DataPump NETWORK_LINK Import With Private Database Link Fails With ORA-04054 (Doc ID 2128750.1)

Last updated on MAY 17, 2021

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


The following steps describe the scenario when ORA-04054 is hit:

- 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 <LOGIN>/<PASSWORD> network_link=<DB_LINK_NAME> directory=<directory_name> transport_tablespaces=<TBS_NAME> TRANSPORT_DATAFILES=<PATH>/<DATAFILE_NAME>.dbf

Connected to: Oracle Database 12c Enterprise Edition Release - 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





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.