Re: Index Across Tables

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz>
Date: Mon, 08 Jul 2002 10:22:09 +1200
Message-ID: <3D28BF11.B672DBEB@team.xtra.co.nz>

Hi Donna,

you can use a DETAIL datastore (if it is a master-detail table) or you can write a procedure and use a USER_DATASTORE.

Have a look at the documentation on
technet.oracle.com -> products -> oracle text -> 8.1.5/8.1.6 here are the basics about these datastores explained.

Cheers
Thomas

Donna Yorukoglu wrote:
>
> I have one multi-column index (using a concatenated datastore). Works
> great. However, I would like to either create a new index on another
> table and then join the indices or create one index across both
> tables. Are either of these options possible with Oracle 8.1.7? Any
> advice would be greatly appreciated.
>
> Thanks in advance,
> D.
Received on Sun Jul 07 2002 - 17:22:09 CDT