Synonyms and distributed databases

Support for synonyms extends to distributed Oracle databases. You can include in the schema image synonyms that point to objects in remote databases as long as you select the links to those databases when you create the schema image. However, you can only use synonyms defined in linked databases that point to objects in that same database.

Synonyms for stored procedures and functions in linked databases are not supported. The following table describes the support for synonyms in local and distributed (remote) databases.

Table 1. Supported synonyms
Synonym Points to . . . Supported
CUSTOMER in local DB NY_CUSTOMER in local DB Yes
CUSTOMER in local DB NY_CUSTOMER in remote DB I Yes
CUSTOMER in remote DB I NY_CUSTOMER in remote DB I Yes
CUSTOMER in remote DB I NY_CUSTOMER in remote DB II No