Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Tablespaces

Re: Oracle and Tablespaces

From: Mark D Powell <markp7832_at_my-deja.com>
Date: Wed, 24 Jan 2001 21:30:40 GMT
Message-ID: <94nhi1$sln$1@nnrp1.deja.com>

In article <94ndbl$o7j$1_at_nnrp1.deja.com>,   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
>

Yes, you should create tablespaces other than system for your objects. You should have separate tablespaces for temp, rbs, user data, and user indexes at the minimum. You can alter your users to use the new temporary segment tablespace and to default for object creation:  alter user bob
 default tablespace user_data
 temporary tablespace temp;

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 24 2001 - 15:30:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US