Oracle Database Discussions

hi

i am trying to store table with blob with minimum storage allocation.

my db_block size is 8192

i created new tablespace block size is as 32768

i am trying to change the chunk size of the table to be 8192 and disable store  inline .

but after the create statement below, i select the chunk size from dba_lobs , and i still get the 32768 ;

SYS#vibeprod>

SYS#vibeprod> drop table "VIBE_UAT"."GROUP_COUNTER";

SYS#vibeprod> CREATE TABLE "VIBE_UAT"."GROUP_COUNTER"

  2     (    "ID" NUMBER(19,0) NOT NULL ENABLE,

  3          "COUNT" NUMBER(19,0) NOT NULL ENABLE,

  4          "END_DATE" TIMESTAMP (6) NOT NULL ENABLE,

        "START_DATE" TIMESTAMP (6) NOT NULL ENABLE,

        "GROUP_KEY_ID" NUMBER(19,0) NOT NULL ENABLE,

        "TOTAL_AMOUNT" NUMBER(19,2),

        "TRADES_INFO" BLOB

   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING

  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "VIBE_UAT_DATA"

  5    6    7    8    9   10   11   12   13  LOB ("TRADES_INFO")

14     STORE AS BASICFILE (

   TABLESPACE VIBE_UAT_DATA

   DISABLE STORAGE IN ROW

   CHUNK 8192

  NOCACHE LOGGING

  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645) )

;

15   16   17   18   19   20  SYS#vibeprod>

SYS#vibeprod>

SYS#vibeprod>

SYS#vibeprod> select IN_ROW,chunk from dba_lobs

  2  where owner='VIBE_UAT' and column_name='TRADES_INFO'

  3  /

NO       32768

and event after alter table move command, the chuk size stays as 32768

why isnt the chuk size is getting the size i wanted?

please help

Thanks

Sigal