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

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Multiple apps with same schema?
Recipe for disaster.

Report message to a moderator

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.

Report message to a moderator

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: 2457
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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 24 03:49:51 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.