Hello!

I would be grateful if somebody clearify me the issue described below.
I don't know how is is posibble that the size of tablespace is smaller than
the size of index stored in this tablespace.


Tha max size of space allocated for index PK_MM2_TSDAT is 70 * 29360128 =
2055208960 (1960MB)

SQL> select INDEX_NAME, TABLE_NAME, TABLESPACE_NAME, INITIAL_EXTENT,
NEXT_EXTENT, MAX_EXTENTS from dba_indexes where INDEX_NAME ='PK_MM2_TSDAT';

INDEX_NAME: PK_MM2_TSDAT
TABLE_NAME: MM2
TABLESPACE_NAME: HF_IX
INITIAL_EXTENT: 29360128
NEXT_EXTENT: 29360128
MAX_EXTENTS: 70


The current size of space allocated for index PK_MM2_TSDAT is 557998080
(532,15M)

SQL> select SEGMENT_NAME, TABLESPACE_NAME, BYTES, EXTENTS, INITIAL_EXTENT,
NEXT_EXTENT, MAX_EXTENTS from dba_segments where
SEGMENT_NAME='PK_MM2_TSDAT';

SEGMENT_NAME: PK_MM2_TSDAT
TABLESPACE_NAME: HF_IX
BYTES: 557998080
EXTENTS: 19
INITIAL_EXTENT: 29360128
NEXT_EXTENT: 29360128
MAX_EXTENTS: 70


Tha max size of space allocated for tablespace HF_IX is 249 * 20480 =
5099520 (4,86MB) ONLY 4,86MB!!!

SQL> select TABLESPACE_NAME, INITIAL_EXTENT, NEXT_EXTENT, MAX_EXTENTS from
dba_tablespaces where TABLESPACE_NAME='HF_IX';

TABLESPACE_NAME: HF_IX
INITIAL_EXTENT: 204800
NEXT_EXTENT: 204800
MAX_EXTENTS: 249


There are 4 rawdevices which store tha data from HF_IX tablespace. Their
size is about 2047MB each.

I can't explain the fact that tablespace is set to store only 4,86MB of data
but there is an index which has the size of over 500MB.
Does anybody know the basic concept?

Regards,
Marcin