Re: Doing some housekeeping -- is this legit?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 04 May 2004 08:53:56 +1000
Message-ID: <4096cd7b$0$32558$afc38c87@news.optusnet.com.au>

Ed Stevens wrote:

[snip]
>
> But I would assume that it is still considered 'best practice' to
> alter SYSTEM's (the user) default TS as soon as you get the database
> on it's feet, to prevent the prevent the inadvertent introduction of
> other (mostly very non-essential) segments into the SYSTEM ts?
>

Yes, change it. DBAs have a habit of logging on as SYSTEM to do the most mundane asministrative task, and it would be a good idea not to allow such work to accidentally introduce extra stuff into SYSTEM (the tablespace). But the stuff that's already there, leave there (I think you might find it is unsupported to move it).

Don't alter SYS's default tablespace, though.

Regards
HJR Received on Mon May 03 2004 - 17:53:56 CDT