cancel
Showing results for 
Search instead for 
Did you mean: 

alter tablespce

smit_sign
Occasional Visitor

alter tablespce

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.
1 REPLY
Yogeeraj_1
Honored Contributor

Re: alter tablespce

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)