Re: Doing some housekeeping -- is this legit?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 30 Apr 2004 07:20:46 +1000
Message-ID: <409171b0$0$29255$afc38c87@news.optusnet.com.au>

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
>>users.
>>
>>SELECT comments
>>FROM ng_participants;

>
>
>
> COMMENT
> ---------------------------------------------------------------
> 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.

Regards
HJR Received on Thu Apr 29 2004 - 16:20:46 CDT