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