EXPDP Not Exporting Database Links
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms