EXPDP Not Exporting Database Links (Doc ID 445129.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms

1] You are taking a full database export using expdp
2] Upon import from the expdp dump you see the database links are not present
3] In the expdp log file you see:

Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** full=y
.
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK <<<<
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

From the expdp log we see " TRUSTED_DB_LINK " .We do not see " DB_LINK ".
Ideally, We see reference to both.

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