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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 22 Sep 1998 20:10:41 GMT
Message-ID: <01bde664$a0263ae0$0300a8c0@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
(don't move
> things out of system). changing some of the storage options can be
beneficial,
> especially in versions that didn't have the unlimited options on
extents (i've
> seen system tablespaces that get 'stuck' because some objects went
into max
> extents.
>

Note: the Oracle 8 manual (somewhere) now states that you are permitted
to change the storage clauses in sql.bsq without voiding your warranty.

I remember one version where there was a special 'sql_big.bsq' supplied by
Oracle Corp which you were allowed to use, just so long as you were aware
that your system was not supported if you chose to use it. Received on Tue Sep 22 1998 - 15:10:41 CDT