Re: Creating lobindexes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 6 Apr 2002 12:27:35 +0100
Message-ID: <1018092891.175.2.nnrp-10.9e984b29@news.demon.co.uk>

Example from the book:

     lob (raw_content) store as raw_lob(
          tablespace auto_data
          -- could have a storage clause here: storage ( etc )
          disable storage in row
          index raw_lob_i
     );

However - also from the book:

    The feature of being able to name the index segment is     no longer documented in Oracle 8.1, and the use of the     'lobindex clause' is deprecated.
    Under 8.0 a LOB segment and its index could be in separate     tablespaces, but under 8.1 they must both be in the same     tablespace.
    I have used this clause to name the index because I dislike     having objects in the database with unrecognisable names.

--

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Sue Borella wrote in message ...


>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 Sat Apr 06 2002 - 05:27:35 CST