Re: ATTN: T.KYTE: Re: Fragmented System Tablespace

From: Ross Mohan <nonspam_rmohan_at_ix.netcom.com>
Date: Wed, 23 Sep 1998 12:38:26 -0400
Message-ID: <6ue715$ets@sjx-ixn10.ix.netcom.com>

I have done this on dozens of databases over the past few years.

Everything works great. SYSTEM and objects look fairly well behaved.

You can, ex post facto, change indexes on *some* of the tables, e.g. SOURCE$ while
those needed for startup e.g. OBJ$ are verboten....the engine actually catches you.

Happy hunting....

Jonathan Lewis wrote in message <01bde664$a0263ae0$0300a8c0_at_WORKSTATION>...
>
>
>Thomas Kyte <tkyte_at_us.oracle.com> wrote in article
><3614bfdb.94462399_at_192.86.155.100>...
>>
>> go ahead and change the storage params but *not* the location of
Received on Wed Sep 23 1998 - 11:38:26 CDT