alter tablespce

smit_sign — Thu, 07 Jun 2007 00:11:15 GMT

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.

Re: alter tablespce

Yogeeraj_1 — Thu, 07 Jun 2007 06:10:17 GMT

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

topic Re: alter tablespce in Operating System - HP-UX

alter tablespce

Re: alter tablespce