| 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: question: about table(s) ?
John - How many tables are we talking about here? In Oracle, you normally
use separate schemas (usernames) to separate unrelated objects. I was just
discussing this issue with developers recently. In past projects, sometimes
we've ended up with many tables, but no dividing principle. Other times,
we've ended up with many schemas with just a few tables and spent a lot of
time granting permissions and creating synonyms. I don't know that there is
any magic answer. Sometimes you just have to make the best decisions you can
based on the information everyone begins the projects with. If there is any
chance of a future division, say that one application will be moved to a
different server, then for heaven's sake, keep those in separate schemas.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, November 28, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L
can we arrange tables in a heirarchy form, just like we have folders and under folders we have files. so this way we sort of divide workspace.
say for company_A i create folder A and in it we can place files for that company. and similarly we can create a folder for company_B. Hence we can separate workspaces for better organization and management etc.
so how can we accomplish as above, when we work with database ? is there a way we can arrange tables (of the database) in a heirarchy similar to folders and files ?
say i have one installation of oracle on a particular computer. so how does one create separate table spaces, say for two different company or projects ? (say company_A and company_B are unrelated to each other)
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Fri Nov 29 2002 - 14:23:37 CST
 |
 |