It is a documented statement that from oracle 8.1,
Oracle does not allow you to store the LOBINDEX
in a tablespace other than the LOBSEGMENT
tablespace, and none of the LOBINDEX storage
details are supposed to be usable (although some
still appear to work some of the time).
--
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
Mike F wrote in message ...
>We have a table with a LOB datatype.
>
> COLUMN_NAME SEGMENT_NAME
> ------------------------- ------------------------------
> "GEOLOC"."SDO_ELEM_INFO" SYS_LOB0000022254C00017$$
>
>INDEX_NAME
>------------
>SYS_IL0000022254C00017$$
>
>We want to seperate the index with the LOB
>
>we did
>
>SQL> alter table test
> 2 modify lob (SYS_LOB0000022254C00017$$)
> 3 store as
> 4 (index (SYS_IL0000022254C00017$$)
> 5 tablespace (indx));
>store as
>*
>ERROR at line 3:
>ORA-00906: missing left parenthesis
>
>SQL> alter table site
> 2 modify lob (SYS_LOB0000022254C00017$$)
> 3 store as
> 4 (tablespace (indx));
>store as
>*
>ERROR at line 3:
>ORA-00906: missing left parenthesis
>
>What we did was wrong?
>
>Thanks for your help.
>
>
>
>
>
>
>
>--
>Sent by dbadba62 from hotmail within area com
>This is a spam protected message. Please answer with reference header.
>Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Mar 14 2002 - 04:12:57 CST
