Re: SYSTEM schema in SYSTEM tablespace

> I have been often advised that the only schema that should own objects in
the
> SYSTEM tablespace is SYS; that even SYSTEM should be assigned to other
> tablespaces just like any other user.
>
> All of our db's still have SYSTEM assigned to the system tablespace
(though his
> temp tablespace has been reassigned to a temp ts). I have discussed this
with
> my partner and he says he sees no need to create the recommended TOOLS ts
and
> move SYSTEM's objects to it. I have nothing to counter except "everyone
says to
> do it that way." Is there any demo/test I could do to demonstrate to both
of us
> why this is good practice?

If you fill up your SYSTEM tablespace, you are screwed. This isn't as tragic now that oracle as auto expansion on tablespaces, but if your SYSTEM tablespace won't automatically allocate more space and it is full, you are in trouble. Same logic that you shouldn't your complete disk the root partition in UNIX, ie make /var /usr and /opt a partition as well.

Tom
www.oraclepower.com Received on Wed Jan 23 2002 - 20:10:09 CST