Dear Gurus,

Just now i have created one tablespace like

SQL> create tablespace fin_users
2 datafile '/proddb/oracle/findata/find01.dbf' size 400m
3 extent management local autoallocate;

After creating my tablespace i use following command

select tablespace_name,extent_management,allocation_type from
dba_tablespaces;

FIN_USERS LOCAL SYSTEM


Can u please explain ALLOCATION_TYPE - SYSTEM means what?

I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.

Please explain ALLOCATION_TYPE - SYSTEM means what?

Thanks in advance,
Iyyappan.M