Re: Creating lobindexes

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Wed, 3 Apr 2002 19:01:45 +0000 (UTC)
Message-ID: <a8fjip$mpd$1@helle.btinternet.com>

INDEX index_name

> 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 ) INDEX my_index_name ;

                          ^^^^^^^^^^^^^^^^

Adrian

"Sue Borella" <sbs8928_at_gsk.com> wrote in message news:ff90cbdd.0204030223.4e9805b_at_posting.google.com...
> 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 - 13:01:45 CST