I would like to create a table with a lobsegment. When the lobsegment
is created a system generated lobindex is also created. How do you
specify a particular lobindex name (rather than a system generated
Lobindex) and specify a specific tablespace.
This is the statement I'm using to create a table with a lobsegment -
CREATE TABLE "TEST_FSDEL" ("CDBREGNO" NUMBER(9, 0),
"FSDELETE" BLOB) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
TABLESPACE "DATA_20M" LOB
("FSDELETE") STORE AS "TEST_FSDEL_LOB0" (TABLESPACE
"LOBSEGMENT_1M" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION
10 CACHE ) ;
When this statement is run a system generated lobindex is created in
the lobsegment tablespace LOBSEGMENT_1M
Received on Wed Apr 03 2002 - 04:23:44 CST
