Problems indexing textdata in BLOBS

From: Andreas Bergmann <ab_at_bytegate.de>
Date: 25 Sep 2001 07:35:40 GMT
Message-ID: <Xns9127627541220abbytegatede@130.133.1.4>

• THE PROBLEM - I'm running Intermedia(8.1.7) on Sun Solaris.

I have a table with a BLOB column which contains text-data in about 50% of all rows.

When I try to create an index on this column everything seems to work fine, but the index remains empty.

The Table 'DR$SEARCH_CONTENT$I' (search_content is the name of the index) is empty.

I do not get any error messages during the indexing-process or by checking the view ctx_user_index_errors.

• WHAT I TRIED - I tried the create syntax with and without the parameter filter 'CTXSYS.INSO_FILTER'

LD_LIBRARY_PATH is set to ctx/lib
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 create index TTHP.search_content on TTHP.content(contentblob) indextype is ctxsys.context parameters ('filter CTXSYS.INSO_FILTER');

Any ideas?

Andreas Bergmann
Hamburg, Germany Received on Tue Sep 25 2001 - 02:35:40 CDT