Re: Creating lobindexes

Sue Borella wrote:

> 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

Version?

Lobindexes stopped being able to be housed in a separate tablespace around about version 8i. They go in the same tablespace as the lob segment itself, and no harm is done by doing so.

-- 
Regards
HJR
--------------------------------------------
Resources for Oracle : http://www.hjrdba.com
============================================