Skip to Main Content

Oracle Database Discussions

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!

Single Schema or Multiple Schemas

user9173788Jul 13 2015 — edited Jul 20 2015

Hi,

Our current web-application is deployed for 25 countries where we have 25 different schema defined with same table layout and 25 different application instances pointing to each schema. with this structure when ever we enhance any feature our overhead of deployment is huge as i have to modify all the 25 tables with changes and deploy applications.

so we are leaning towards having only one application instance and one DB instance having the data of all the countries with an additional column country to identify which country user has logged in.

before we go ahead i wanted an expert advice on which is a better solution "single schema or multiple schema" with pro's and con's so that we can go with that approach.One point to note is that we will have millions of records in the tables.

Also someone was telling us that Oracle as a new way of storing data in single schema where it has partition system of having sub-schema structure which can store data accordingly - this may not be true but nevertheless wanted to check

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2015
Added on Jul 13 2015
22 comments
4,347 views