Automatic Segment-Space Management Segments and LOBs

Hi everyone

As I know, Automatic Segment-Space management can not be used for tablespaces witch will contain LOBs.
This is what I've done and I got something else:

C:\Documents and Settings\Administrator>sqlplus "sys_at_testDb as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 28 17:50:31 2005

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

Enter password:

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> CREATE TABLESPACE TST_TBLSPC
  2 DATAFILE 'C:\ORACLE\PRODUCT\ORADATA\TESTDB\TST1.DBF' SIZE 15M   3 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 40K   4 SEGMENT SPACE MANAGEMENT AUTO; Tablespace created.

SQL> SELECT TABLESPACE_NAME, BLOCK_SIZE, SEGMENT_SPACE_MANAGEMENT   2 FROM DBA_TABLESPACES
  3 WHERE TABLESPACE_NAME = 'TST_TBLSPC';

TABLESPACE_NAME                BLOCK_SIZE SEGMEN


------------------------------------------------ -------------------

--------------

TST_TBLSPC                             8192              AUTO

SQL> CREATE TABLE TBL
  2 (FLD BLOB)
  3 TABLESPACE TST_TBLSPC; Table created.

SQL> SELECT TABLESPACE_NAME, BLOCK_SIZE, SEGMENT_SPACE_MANAGEMENT   2 FROM DBA_TABLESPACES
  3 WHERE TABLESPACE_NAME = 'TST_TBLSPC';

TABLESPACE_NAME                BLOCK_SIZE SEGMEN


------------------------------------------------ -------------------

--------------

TST_TBLSPC                             8192              AUTO

SQL> SELECT TABLE_NAME, TABLESPACE_NAME, STATUS   2 FROM DBA_TABLES
  3 WHERE TABLE_NAME = 'TBL';

TABLE_NAME                     TABLESPACE_NAME                STATUS


------------------------------------------

----------------------------------------------- --------

TBL                                     TST_TBLSPC
      VALID

Could someone explain this.

Thanks in Advance
Amir Received on Wed Dec 28 2005 - 04:06:39 CST