Multi-Column Datastore HELP!

From: acelestial <acelestial_at_twp.cwellington.on.ca>
Date: Tue, 21 Jan 2003 09:36:38 -0500
Message-ID: <S4dX9.148$J77.14645358@mantis.golden.net>

Hi,

I've found something about "MULTI-COLUMN DATASTORE" where you can index multiple columns. I just can't figure it out on the index part sql on what should I substitute for the "columnx" variable. I did try different things but can't get it working. It keeps on giving me an "Invalid Column" error. Here's the link from Oracle Metalink under Datastore Improvements, http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=120611.1.

ctx_ddl.create_preference('mymulti','MULTI_COLUMN_DATASTORE');

ctx_ddl.set_attribute('mymulti', 'COLUMNS', 'column1, column2, column3');

create index myindex on mytable(columnx) indextype is ctxsys.context parameters('datastore mymulti');

I'm trying to index two columns from a table, a BLOB field and a VARCHAR2 field. After the index has been created, I'll be using interMedia Text Query to query the documents in BLOB field and the VARCHAR2 field in a web-based search application.

Thank you very much for any help.

Regards,
Arman Received on Tue Jan 21 2003 - 08:36:38 CST