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_at_[64.94.198.252]>
We have a table with a LOB datatype.
SYS_IL0000022254C00017$$ We want to seperate the index with the LOB
Date: Wed, 13 Mar 2002 21:39:23 GMT
Message-ID: <l.1016055564.1381958007_at_[64.94.198.252]>
We have a table with a LOB datatype.
COLUMN_NAME SEGMENT_NAME
- ------------------------------ [Quoted] "GEOLOC"."SDO_ELEM_INFO" SYS_LOB0000022254C00017$$
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/newReceived on Wed Mar 13 2002 - 22:39:23 CET