Using DB schema clones in application
Hi,
I'm asking for a good advice, please.
We have a big Oracle application (PL/SQL + Forms), using DB schema "APP".
All code is written using schema name, "Select .. From APP.table_name" etc.
Now we need to add two more "clones" of APP schema (e.g. APP_A and APP_B), with same structure but data for two other counties.
Is it possible to use three instances of the application, for three different countries - and of course, without global code changing?
Thank you for any help,
G.R.
I'm asking for a good advice, please.
We have a big Oracle application (PL/SQL + Forms), using DB schema "APP".
All code is written using schema name, "Select .. From APP.table_name" etc.
Now we need to add two more "clones" of APP schema (e.g. APP_A and APP_B), with same structure but data for two other counties.
Is it possible to use three instances of the application, for three different countries - and of course, without global code changing?
Thank you for any help,
G.R.
0