Hi,

I have the following tablespace:

SELECT TABLESPACE_NAME, BLOCK_SIZE, INITIAL_EXTENT, MIN_EXTENTS,
EXTENT_MANAGEMENT, SEGMENT_SPACE_MANAGEMENT
FROM USER_TABLESPACES;

TABLESPACE BLOCK_SIZE INITIAL_EXTENT MIN_EXTENTS EXTENT_MAN
---------- ---------- -------------- ----------- ----------
EXAMPLE 8192 65536 1 LOCAL


When I query my tables, I have the following:

SELECT TABLE_NAME, TABLESPACE_NAME, INITIAL_EXTENT, MIN_EXTENTS
FROM USER_TABLES;

TABLE_NAME TABLESPACE INITIAL_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- -----------
TABLE_E EXAMPLE 16384 1


If you look at the initial extent of TABLE_E, it shows 16384. I am wondering how oracle derived this. I've read it somewhere that in a Locally-Managed Tablespace, the minimum extent is 3 data blocks. In my example above, the data block is 8K, so I am assuming that any table created in the tablespace will have at least 24K. But this does not seem to be the case as showed by TABLE_E which has 16K.

Any Ideas?

Thanks
toshi