What is default in 9i and 10g

Hi, what is default of segment space management in 9i& and 10g.please help me.
Thanx in advance,
:confused: KVL Narayana:confused:

what happened when you created a tablespace and found out?

9i -Dictionary managed TS + Manual SSM
10g - Locally managed TS + ASSM

10g - Locally managed TS + ASSM

bore,Are you sure ASSM is default in oracle 10g!!!

C:\>sqlplus/nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 13 22:33:55 2007

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

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> create tablespace test
2 datafile 'e:\test.dbf' size 10m;

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
TEST LOCAL MANUAL
11 rows selected.

the default behavior of oracle 10g is MANUAL, for segment space management.

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