Synonyms and distributed databases
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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.
| 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 |