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.
