Home -> Usenet -> comp.databases.oracle -> cluster & LOBs: not compatible?

cluster & LOBs: not compatible?

From: S P Arif Sahari Wibowo <arifsaha_at_yahoo.com>
Date: Thu, 22 Feb 2001 21:09:45 GMT
Message-ID: <Pine.LNX.4.21.0102220959420.24216-100000_at_gede.parokinet.org> 






Hi!



Do you know whether I can use cluster for table with LOB fields?



I have these definitions:




CREATE CLUSTER document_id_cl ( id char(16) );



CREATE INDEX document_id_ndx ON CLUSTER document_id_cl;



CREATE TABLE documents (

       id char(16) CONSTRAINT id_pk PRIMARY KEY,
       descriptions clob,
       doc blob




)


cluster document_id_cl (id);



CREATE TABLE document_authors (

       document_id char(16),
       authors char(16)




)


cluster document_id_cl (document_id);





running the script give me this error:





cluster document_id_cl (id)


        *


ERROR at line 6:


ORA-03001: unimplemented feature





But the second table created successfully.



Changing the type ?lob to varchar did make it works. But I need the ?lob
type.



Any explanation?



BTW: which one is the right newsgroups? The comp.databases.* tree or the
comp.database.* tree?



Thanks.


-- 
                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____ 
 /____  /____/ /____/ /____          arifsaha_at_yahoo.com
_____/ /      /    / _____/       http://www.arifsaha.com/


Received on Thu Feb 22 2001 - 22:09:45 CET












Original text of this message