Home » RDBMS Server » Server Administration » one schema vs multiple schema (Oracle 10g)
one schema vs multiple schema [message #441523] Mon, 01 February 2010 16:10 Go to next message
Richard2009
Messages: 21
Registered: October 2009
Location: London
Junior Member
Hi Experts,

Please share your experience on single schema setup or multiple schema setups for an application development. Which option is recommended and pros and cons of these methods?

Regards,
Richard
Re: one schema vs multiple schema [message #441532 is a reply to message #441523] Mon, 01 February 2010 16:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Multiple apps with same schema?
Recipe for disaster.
Re: one schema vs multiple schema [message #441543 is a reply to message #441523] Mon, 01 February 2010 18:00 Go to previous messageGo to next message
Richard2009
Messages: 21
Registered: October 2009
Location: London
Junior Member
Hi Mahesh,

Here I am talking about multiple components(eg., deals,security etc..) of an application and not multiple applications under one schema.

Please share your thoughts on the same.
Re: one schema vs multiple schema [message #441554 is a reply to message #441543] Mon, 01 February 2010 20:59 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
My choice is Multiple schemas for an application.
Some of them having more privileges than read only schema(we granted like that)... Laughing

sriram Smile
Re: one schema vs multiple schema [message #441569 is a reply to message #441523] Mon, 01 February 2010 23:38 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As always there is no general rules, sometimes one schema, some times several schemas is better.
It depends on many many things.

Regards
Michel
Previous Topic: system01.dbf
Next Topic: Concurrency
Goto Forum:
  


Current Time: Sun Dec 04 04:24:23 CST 2016

Total time taken to generate the page: 0.05968 seconds