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 <adar76_at_inter.net.il> 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
> <ORACLE-L_at_fatcity.com>
> 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: john_g123_9_at_yahoo.com
> >
> > 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).
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> 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).
>
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
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: stephane_paquette_at_yahoo.com
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 - 09:13:45 CST
