My Oracle Support Banner

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

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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