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. [EMAIL PROTECTED] -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) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: question: about table(s) ?
Hi, I think you could use different schema's to distinguish between different companies. Jack -Original Message- Sent: vrijdag 29 november 2002 2:44 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) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Jack van Zanen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: question: about table(s) ?
I would not advise anybody to create objects using a graphical tools, rely on scripts instead. You can separate tables in a physical way and in a logical way. Physically you can use schemas and tablespaces to separate tables. Logically , use a good naming convention and then organise your stuff. --- Yechiel Adar <[EMAIL PROTECTED]> a écrit : > On windows you can use the DBA console/OEM console > (on 9i): > select the database then go to space->tablespaces. > Right click on tablespaces you get: Create. > > Or - read about the create tablespace command in the > manual. > (which you need to do anyway to understand what the > GUI is doing). > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Sent: Friday, November 29, 2002 3:43 AM > > > > > > 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) > > > > __ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > > http://mailplus.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: john > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Yechiel Adar > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: question: about table(s) ?
On windows you can use the DBA console/OEM console (on 9i): select the database then go to space->tablespaces. Right click on tablespaces you get: Create. Or - read about the create tablespace command in the manual. (which you need to do anyway to understand what the GUI is doing). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, November 29, 2002 3:43 AM > > 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) > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: john > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
