OraFAQ Forum: Server Administration » one schema vs multiple schema

Home » RDBMS Server » Server Administration » one schema vs multiple schema (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

one schema vs multiple schema [message #441523]

Mon, 01 February 2010 16:10

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

Mahesh Rajendran
Messages: 10707
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

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

ramoradba
Messages: 2456
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

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Previous Topic:	system01.dbf
Next Topic:	Concurrency

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:48:23 CDT 2024