Full Data Pump Export Does Not Export Synonyms With Database Links

(Doc ID 820703.1)

Last updated on NOVEMBER 22, 2013

Applies to:

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

Symptoms

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.

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