My Oracle Support Banner

Full Data Pump Export Does Not Export Synonyms With Database Links (Doc ID 820703.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***


Synonyms having database links in their definition are not exported by a full Data Pump export. The synonyms are created with no schema names in their definition.

The issue can be noticed by examining the dump file using impdp with SQLFILE parameter. In the file created by SQLFILE parameter the statements to create the synonyms with database links are missing.

A Data Pump schema level export does export these synonyms.


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.