Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[4]: What Sort of Privilege?
Peter,
You said it best. Nobody is right or wrong here.
If you are running an ERP, then the decision is made for you.
If you are running a home-grown system, and you prefer one schema, then you
are correct.
If you are running a home-grown system, and you prefer multi-schemas, then
you are correct.
It all really comes down to personal preference. I actually got a chuckle yesterday when I was told that I was WRONG! Lol!
Have a great day.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Peter Robson [mailto:pgro_at_bgs.ac.uk]
Sent: Wednesday, August 25, 2004 4:57 AM
To: oracle-l_at_freelists.org
Subject: Re[4]: What Sort of Privilege?
Having started this hare running I better qualify those original comments.
In principle, based on our experience of an un-disciplined user community, the one-schema approach has worked very well. We adopted this with version 5, so the subsequent enhancements in later versions of Oracle leaves me in little mood to re-engineer our architecture. (note - why is it, time after time after time, Oracle provides a solution to a problem we solved long ago? :-) )
Of course there is no reason why a multi-schema approach cannot work fine, but it requires a degree of advance planning and understanding to cover all those additional complexities which are simply absent from the one schema approach. So yes, Jackie - I think you guys have been careful!
So nobody is WRONG or RIGHT here, it is a question of understanding your environment, and choosing the most appropriate solution. Having said that, I am still more sympathetic to the position originally outlined, and endorsed so emphatically by Tom (thanks, Tom!).
peter
edinburgh
............
JB> Interesting - not something I've ever encountered. I have JB> encountered issues with indexing (the effects of the referencing JB> columns not being indexed, that is), but never with the number of JB> schemas that referenced it. Have I (and my co-workers) just been JB> overly careful? JB> -----Original Message----- JB> From: Peter Robson [mailto:pgro_at_bgs.ac.uk]=20 JB> Sent: Tuesday, August 24, 2004 2:57 AM JB> To: Jackie Brock
JB> Whoa there everybody!
<skip)
-- mailto:pgro_at_bgs.ac.uk ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. However, the information contained in this e-mail may subsequently be subject to public disclosure under the Freedom of Information Act 2000 and, unless the information is legally exempt from disclosure, the confidentially of this e-mail and your reply cannot be guaranteed. If this message was not intended for you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. http://www.bgs.ac.uk *********************************************************************Received on Wed Aug 25 2004 - 07:24:03 CDT
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
![]() |
![]() |