Oracle Text for searchengine across multiple columns/tables with different datastore

Hi,

I have the following problem:

We have an Oracle 9.2 with one table "document" which contains a path to the filesystem. If I want to index these files (HTML, PDF, World, Excel, etc.), I have to use the datastore type "FILE_DATASTORE".

Another table "lng_text" stores the titles and descriptions for multiple languages for each row in table "document".

My goal is to build an index, which I can query with AND or OR Operator across all three columns in both tables.

I read a lot about USER_DATASTORE and the posibillity to merge different columns with a stored procedure in one index. But how is this possible in this case, since one column contains a path to filesystem and two other columns are VARCHAR(500)?

Thanks in advance!

Greetz,
Nikola Pecigos

PS: As far as I realize it, building two or three indexes does not solve the problem. If I had more than one searchword like "this & that" and query multiple indexes,

WHERE CONTAINS(t1.column, 'this & that', 10) > 1 OR

      CONTAINS(t2.column, 'this & that', 20) > 1

I would request boths searchwords to appear together in ONE index or the other. But it has to be possible, that "this" is found in t1 and "that" in t2. Received on Fri Mar 04 2005 - 03:20:32 CST