| 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
Multiple schemas can be handy if there's a reason to isolate functional areas. One reason might be so that when you fire up a tool that does ERD's you can tell it to do just the BILLING schema. Or if you wanted to export just a section to load into a test database to do development. You could make use of the multiple schemas to help assign roles.
On the other hand, 35 tables really doesn't scream for such a division. Personally, I like to keep logical areas in the 8-20 tables range, but that's just because that's what is easy for me to grasp.
Also, such schema divisions should really be part of the original design and should facilitate the design. Shoe horning an existing design into a mold just to be pretty can be frustrating.
-rje
o> Our consultant has presented a schema design which I have never seen o> (not that I have seen all the designs in the world) but I also failed o> to see the advantage. o> Basically our application consists of 35 tables and all is under oneo> schema named after the application. Granted, the application has many o> components such as billing tables, event tables etc.
o> Now the consultant wants to split all 35 tables into as many as 8 o> different schemas! Such as a billing schema, a event schema. To me o> this only complicates the whole thing as now you have to manage 8 o> schemas and manage many grants, synonyms. Not to mention some tables o> are not clear cut as which component it belongs to. I just don't see o> what this buys us.
o> Has anyone seen such a approach? And what's the benefit of doing so?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Eskridge
INET: bryny_at_dfweahs.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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:02:22 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |