Re: LOB Table space

this is the output,
thanks.

DBMS_METADATA.GET_DDL('TABLE','EVENEMENT')

  CREATE TABLE "HBGDECAINRS"."EVENEMENT"    ( "NO_SOCIETE" VARCHAR2(4) NOT NULL ENABLE,
"NO_PARC" VARCHAR2(4) NOT NULL ENABLE,
"NO_EVENEMENT" NUMBER(10,0) NOT NULL ENABLE,
"NO_PV" VARCHAR2(35),
"MARQUAGE" VARCHAR2(35) NOT NULL ENABLE,
"NATURE_EVENEMENT" CHAR(1) NOT NULL ENABLE,
"DATE_OPERATION" DATE NOT NULL ENABLE,
"CODE_OPERATEUR" VARCHAR2(10),
"DATE_PREVUE" DATE NOT NULL ENABLE,
"TRANSFERT" CHAR(1),
"EXPLICATION_RETARD" VARCHAR2(80),
"COMMENTAIRE" VARCHAR2(2000),
"TYPE_SORTIE" VARCHAR2(2),
"DATE_RETOUR" DATE,
"UTILISATEUR" VARCHAR2(100),
"CONSTAT" BLOB,
"OPERATION" VARCHAR2(32) NOT NULL ENABLE,
"ETAT" VARCHAR2(2),
"INSTRUCTION" VARCHAR2(20),
"APPROBATION" VARCHAR2(30),
"DATE_CREATION" DATE,

  CONSTRAINT "CKC_NATURE_EVENEMENT_EVENEMEN" CHECK (nature_evenement in ('A','T'
)) ENABLE,
  CONSTRAINT "PK_EVENEMENT" PRIMARY KEY ("NO_SOCIETE", "NO_PARC", "NO_EVENEMENT"
)
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255   STORAGE(INITIAL 516096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)   TABLESPACE "USER_INDEX" ENABLE,
  CONSTRAINT "FK_ANOMALIE_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "ANOMALIE")    REFERENCES "HBGDECAINRS"."ANOMALIE" ("NO_SOCIETE", "INTITULE") ENABLE,   CONSTRAINT "FK_CONCLUSION_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "CONCLUSION")
   REFERENCES "HBGDECAINRS"."CONCLUSION" ("NO_SOCIETE", "TEXTE") ENABLE,   CONSTRAINT "FK_DECISION_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "DECISION")    REFERENCES "HBGDECAINRS"."DECISION" ("NO_SOCIETE", "TEXTE") ENABLE,   CONSTRAINT "FK_INSTRUMENT_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "NO_PARC", "MA
RQUAGE")
   REFERENCES "HBGDECAINRS"."INSTRUMENT" ("NO_SOCIETE", "NO_PARC", "MARQUAGE") O
N DELETE CASCADE ENABLE,
  CONSTRAINT "FK_OPERATEUR_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "CODE_OPERATEUR
")

   REFERENCES "HBGDECAINRS"."OPERATEUR" ("NO_SOCIETE", "CODE") ENABLE,   CONSTRAINT "FK_OPERATION_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "OPERATION")
   REFERENCES "HBGDECAINRS"."OPERATION" ("NO_SOCIETE", "INTITULE") ENABLE,   CONSTRAINT "FK_TYPE_SORTIE_EVENEMENT" FOREIGN KEY ("NO_SOCIETE", "TYPE_SORTIE"
)

   REFERENCES "HBGDECAINRS"."TYPE_SORTIE" ("NO_SOCIETE", "CODE") ENABLE    ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)   TABLESPACE "USER_DATA"
 LOB ("CONSTAT") STORE AS (
  TABLESPACE "USER_LOB" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10   NOCACHE
  STORAGE(INITIAL 104857600 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) "Zot" <wiz_au_at_yahoo.com.au> a écrit dans le message de news: fuci9e$gl6$1_at_registered.motzarella.org...

> OD wrote,on my timestamp of 18/04/2008 11:46 PM:
>> Hello,
>>
>> I made a table with 1 blob  field, and a specific lob tablespace to store 
>> the lob column.
>>
>> If i insert a row with nothing in the blob field, 1 MB is reserved for it 
>> in the lob tablespace.
>> The blob field is NULL.
>>
>> Do someone have any idea ?
>>
>> Olivier.
>
>
> Run this:
> SQL> select dbms_metadata.get_ddl('TABLE','<table_name') from dual;
>
> substituting the table_name for what it is, then
> post here the results.
>
> Also, read this:
> http://dbasrus.blogspot.com/2007_02_01_archive.html
> for info on some LOB gotchas.