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