Re: cluster & LOBs: not compatible?

S P Arif Sahari Wibowo wrote:

> 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?
>

You are right, LOBs cannot be kept in cluster.

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

comp.databases.* tree.

>
>
> Thanks.
>
> --
> S P Arif Sahari Wibowo
> _____ _____ _____ _____
> /____ /____/ /____/ /____ arifsaha_at_yahoo.com
> _____/ / / / _____/ http://www.arifsaha.com/
Received on Fri Feb 23 2001 - 22:48:29 CST