Oracle and Tablespaces

From: <dandrews_at_email101.freeserve.co.uk>
Date: Wed, 24 Jan 2001 20:19:13 GMT
Message-ID: <94ndbl$o7j$1@nnrp1.deja.com>

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 - 14:19:13 CST