Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Tablespaces
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