Skip to Main Content

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!

Creating synonyms to point to correct schema

user11942774Feb 26 2020 — edited Feb 27 2020

Hi All,

Currently we have one database in which there is currently one schema say with country A.  To access the different table data from GUI we have user (say gui_user), which access these table using synonyms which have been created.

Problem: Going forward for the same database we are going to create another schema B for different county with same tables & table names  as schema A.

               1)  is it possible to create the table synonyms for schema B with same table so that  gui_user can access the country specific tables A or B.

                     or have one same synonym pointing to different tables in sachems but can switch based on the location on runtime.

                2) How to we switch between the schema so that the gui_user can point to the correct country,

             

Thanks

Comments
Post Details
Added on Feb 26 2020
4 comments
971 views