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!

Multiple Instances and schemas to One

EfficientoracleJul 18 2013 — edited Jul 18 2013

Hi,

Good Morning to all gurus.

Using Oracle Version 11.2.0.2

We have a database With 4 instances and Each Instance will be having 10 to 15 schemas Based on Countries. Here in all schemas we will be having Huge data's (count may be 3 to 5 crores for some 10 tables)

Now am keen to Know If i change the above to a single instance and Single Schema(Common for all countries) What Pros and cons Will be there (Technical).

Any Links or Answers are highly appreciated.

HOPE GURUS Here can help me study and understand the above scenarios.

Regards,

Simma....

This post has been answered by Ankit Ashok Aggarwal on Jul 18 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 15 2013

Added on Jul 18 2013

#general-database-discussions

9 comments

1,007 views