Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Database design issues : Oracle synonyms : Synonyms and distributed databases
 
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 7. 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