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).