What is default in 9i and 10g

[Bore]

Hmmmm,
That's strange. In 10g release 2 default segment space management is AUTO as seen here
http://download.oracle.com/docs/cd/B...s.htm#i1013496
also tested:
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 14 08:10:56 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create tablespace test
2 datafile '/u01/app/oracle/oradata/test.dbf' size 5m;

Tablespace created.

SQL> select tablespace_name,extent_management,segment_space_management
2 from dba_tablespaces;

TABLESPACE_NAME EXTENT_MAN SEGMEN
------------------------------ ---------- ------
SYSTEM LOCAL MANUAL
UNDOTBS1 LOCAL MANUAL
SYSAUX LOCAL AUTO
TEMP LOCAL MANUAL
USERS LOCAL AUTO
EXAMPLE LOCAL AUTO
INVENTORY LOCAL AUTO
HR_TEST LOCAL AUTO
TEST LOCAL AUTO

9 rows selected.


Did not found that however in the rel 1 docs.
Seems it's different

So please avoid colloring in blue and upper case your conclusions

Regards