Re: Oracle and Tablespaces

> 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?

The approach is valid only if you wish to come back later and be paid huge amounts of money to fix a problem of your own making.

Were this a vendor of mine I would demand some percentage of the money paid back in order to hire someone to fix the mess.

No tables or indexes should ever be put into the SYSTEM tablespace nor should any schema owner other than one created by Oracle's own installation program ever have the SYSTEM tablespace as its default or have any rights to build any object within it.

Given what this vendor did I'd also check that the TEMP tablespace is actually a temp space (not permanent) and that all schemas are assigned that tablespace for TEMPORARY TABLESPACE. I'll put odds on this one.

Daniel A. Morgan Received on Wed Jan 24 2001 - 22:44:38 CST