Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Doing some housekeeping -- is this legit?

Re: Doing some housekeeping -- is this legit?

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 30 Apr 2004 07:40:32 -0500
Message-ID: <>

On Fri, 30 Apr 2004 07:20:46 +1000, "Howard J. Rogers" <> wrote:

>Brian Peasland wrote:
>>>I always thought that the only thing that should be in the SYSTEM
>>>tablespace is the objects owned by SYS. But it appears that,at least
>>>in some cases, these particular segments were created during DB
>>>creation, before one gets a chance to alter the defaults for these
>>>SELECT comments
>>>FROM ng_participants;
>> ---------------------------------------------------------------
>> The SYSTEM tablespace should only contain data dictionary
>> objects.
>> This means those tables owned by SYS.
>> Oracle 10g improves this with the SYSAUX tablespace to store
>> things like OUTLN tables, AQ$ tables, etc.
>That's all true... but before you encourage people with pre-10g
>databases to start moving Advance Queuing tables, Stored Outline tables
>(and even AUD$) etc. into non-SYSTEM tablespace, please get them to
>check the Oracle support status for doing so first. Because as far as I
>can remember, it is not supported to move any of these things, and
>therefore you just have to live with them being in SYSTEM.
>AUD$ is a particularly tricky example, because although Oracle's
>documentation actually recommends moving it, it is unsupported to
>actually do so!
>Just watch out for support issues before 'house-cleaning' the lot
>somewhere new, is all I'm saying.
Well, I'm not planning on moving anything just yet, if at all. I was really looking for some more serious issues, like obvous user tables, but was mildly surprised to find these segments in there. I just checked an 8.1 db I created a couple of weeks ago on a Solaris system. I created it using DBCA (or whatever it was called in 8.1) and the only thing I did post-creation was change the default tablespaces for all users (which were all created under DBCA). That DB has 48 segments owned by either OUTLN or SYSTEM that are in the SYSTEM tablespace. Received on Fri Apr 30 2004 - 07:40:32 CDT

Original text of this message