Help:LOB problem

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Wed, 13 Mar 2002 21:39:23 GMT
Message-ID: <l.1016055564.1381958007@[64.94.198.252]>

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 Wed Mar 13 2002 - 15:39:23 CST