SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synonym for Schema Names

User_D9WKADec 4 2020 — edited Dec 4 2020

I have an app that spans several schemas. Call them A, B, and C.
I want to be able to create a dev version in the same database with schemas A_DEV, B_DEV, and C_DEV.
But synonyms don't work for schema names. How can I have an app that has several schemas with different names for dev, test, and prod?

This post has been answered by Frank Kulash on Dec 4 2020

Jump to Answer

Added on Dec 4 2020

#plsql

3 comments

269 views