Full Data Pump Export Does Not Export Synonyms With Database Links
Last updated on NOVEMBER 22, 2013
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 to 184.108.40.206 [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.
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