| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: The use of schemas
There is no problem with asking him and I will for sure ask the consultant about the reason behind this.
But here is the frustrating part. The consultant have no knowledge of
the application! He is brought in by the hosting company which we use
to help us deploy the application.
And he is trying to do too much and in this case without understanding
the application. Anyways, this is a obviously a separate issue that
I have to work out who is responsible for what.
>From: "Grabowy, Chris" <cgrabowy_at_fcg.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: The use of schemas
>Date: Wed, 13 Feb 2002 11:44:17 -0800
>
>There is the three schema method for security and integrity purposes, not
>quite sure why you would break it up the consultant's way.
>
>Is there a problem with asking the consultant about the split? What are
>the
>advantages? Is there some business requirement? S(he) may know of some
>requirement that you are not aware of??
>
>HTH
>
>Chris
>
>-----Original Message-----
>Sent: Wednesday, February 13, 2002 2:09 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi all,
>
>Our consultant has presented a schema design which I have never seen
>(not that I have seen all the designs in the world) but I also failed
>to see the advantage.
>
>Basically our application consists of 35 tables and all is under one
>schema named after the application. Granted, the application has many
>components such as billing tables, event tables etc.
>
>Now the consultant wants to split all 35 tables into as many as 8
>different schemas! Such as a billing schema, a event schema. To me
>this only complicates the whole thing as now you have to manage 8
>schemas and manage many grants, synonyms. Not to mention some tables
>are not clear cut as which component it belongs to. I just don't see
>what this buys us.
>
>Has anyone seen such a approach? And what's the benefit of doing so?
>
>Thanks
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oracle dba
> INET: oracle12i_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: oracle12i_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Feb 13 2002 - 14:42:22 CST
 |
 |