Re: Oracle and Tablespaces

Create a DATA tablespace for your tables, an INDEX tablespace for the indexes, a TEMP tablespace for temporary storage (needed when sorting large result sets), and of course a ROLLBACK tablespace.

ALTER your users, so they get the DATA tablespace as their default tablespace and TEMP as their temporary tablespace:

ALTER USER <username> DEFAULT TABLESPACE DATA TEMPORARY TABLESPACE TEMP;

Drop the tables that were created in the SYSTEM tablespace, then recreate them in DATA, and their indexes in INDEX.

Good luck :)

dandrews_at_email101.freeserve.co.uk wrote:
>
> HI all,
> We have just had Oracle 8i installed and the supplier installed and
> left us to our own devices. We started to enter tables directly into
> the SYSTEM tablespace as all users (created by the supplier) were
> assigned the SYSTEM tablespace as their default tablespace.
>
> I belive that we should create a new tablespace and associated
> datafiles to hold our user objects. Not knowing anything much about
> Oracle I am wondering is this a valid approach?
>
> Any comments welcome.
>
> TIA
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 24 2001 - 15:28:36 CST