system tablespace extents question

Hello,

I was asked if it is possible to alter the system tablespace in a way that e.g. the existing 180 extents (max is 249) become 1 extent, in order to reduce the number of extents.

I personally have some information that this is not possible, and if it was, it would not be wise to make such
changes to the system tablespace, to avoid data dictionary fragmentation. But I am not sure.
Most docs suggest adding a new datafile to the system tablespace, or resize the old file.

The next question that came up to me is, when dealing with other tablespaces where schema objects are put in:

When we create a new tablespace, we set storage parameters like initial extent and next extent.

When we create a schema object like a table, we also set those storage parameters.
But, the schema objects are assigned to
a tablespace (different from system tablespace of course), and if we set storage parameters for the object that
differ from storage parameters of the tablespace, that suddenly starts to confuse me.
Before that I thought I understood the matter, now I feel that I donīt ...8|

What happens e.g. if initial and next extent of a tablespace is lets say 100k, and for a table in that tablespace we set 1M ?

ThanX in advance,
Jan=) Received on Wed Jul 24 2002 - 09:08:07 CDT