Jmodic, thanks very much for your quick reply.

However for Q1, pls see the following result running in 9i and 8i:
===========================================================
In 9i, the default is LMT
SQL> create tablespace local_storage datafile 'd:\testlocal.dbf' size 2m
2 default storage (initial 100k next 120k minextents 2);

Tablespace created.

SQL> select INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, EXTENT_MANAGEMENT from dba_tablespaces
2 where TABLESPACE_NAME='LOCAL_STORAGE';

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS EXTENT_MAN
-------------- ----------- ----------- ----------
65536                   &nbsp 1 LOCAL

Though the storage can be used, but it doesn't really affect the space allocating.


In 8i, the default is DMT
SQL> create tablespace local_storage datafile '$ORACLE_BASE/oradata/local_storage.dbf'
2 size 2m extent management local
3 default storage (initial 120k);
create tablespace local_storage datafile '$ORACLE_BASE/oradata/local_storage.dbf'
*
ERROR at line 1:
ORA-25143: default storage clause is not compatible with allocation policy

error return
===========================================================

For Q2:
You said "Oracle will prealocate 2 extents at table creation time", do you mean oracle will preallocate "100k+120k" space, because the first 2 extents is "100k and 120k". Am I right?

Thanks!

[Edited by ly on 10-10-2002 at 05:01 AM]