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