alter tablespce

[smit_sign]

hi
i am new at this platform but i want to know if the initial extent size of SYSTEM tablspace is not mention at the time of DB creation then can we specify if afterward?
is there any alter Tablespace command and SYSTEM tablespace is LOCAL.

[Yogeeraj_1]

hi,

If the SYSTEM tablespace has EXTENT_MANAGEMENT set to LOCAL then you really have nothing to worry about.

Can you post the output of the following query:
select * from dba_tablespaces where tablespace_name='SYSTEM';

Typical values are:
----------------------------------------
TABLESPACE_NAME : SYSTEM
BLOCK_SIZE : 8192
INITIAL_EXTENT : 65536
NEXT_EXTENT :
MIN_EXTENTS : 1
MAX_EXTENTS : 2147483645
PCT_INCREASE :
MIN_EXTLEN : 65536
STATUS : ONLINE
CONTENTS : PERMANENT
LOGGING : LOGGING
FORCE_LOGGING : NO
EXTENT_MANAGEMENT : LOCAL
ALLOCATION_TYPE : SYSTEM
PLUGGED_IN : NO
SEGMENT_SPACE_MANAGEMENT : MANUAL
DEF_TAB_COMPRESSION : DISABLED
RETENTION : NOT APPLY
BIGFILE : NO
-----------------

hope this helps!

kind regards
Yogeeraj