Re: changing SYSTEM-tablespace to automatic segment-space management

Anno Domini 11-11-2005 16:47, Moritz Klein sprak aldus:

> Hello all,
> after my update from 10gR1 to 10gR2 went out smoothly I am faced with
> a info from OEM I am not really sure if I should take it or not. OEM
> says that my SYSTEM-tablespace is set to manual segment-space
> management which should be auto. As I already have taken down any
> applications that have to interact with the database this would be the
> time to implement the advise. What I really don't know at the moment
> is what are the implications when taking SYSTEM from manual to
> automatic segemtn-space management?
>
> Thanks for any help,
> Moritz
> --
> Environment:
> Oracle 10gR2
> Windows 2003 Server SP1 fully patched

Why should your system tablespace be set to automatic space management if you don't know the difference with manual space management?

With manual space management, the tables have all the old storage proparties such as pctused, initial extent, next extent, etc. With automatic segment space management, oracle takes care of most of this automaticly, except pctfree.

Since in the system tablespace only tables and indexes from sys and system should be there, I wonder why bother?

And I don't think it's possible to alter the storage parameters of a locally managed tablespace, let alone system, without doing a full export, drop the tablespace (in your case the entire database) and doing a full import. Received on Fri Nov 11 2005 - 10:05:34 CST