Home » Server Options » Text & interMedia » Problems with file_datastore index.
Problems with file_datastore index. [message #366448] Wed, 23 August 2000 21:03
Jeremy Goldberg
Messages: 1
Registered: August 2000
Junior Member
Hi - can anyone tell me what I'm doing wrong? I'm trying to create a (fairly basic) site-wide file index of a web-site, but once I've created my index nothing matches the CONTAINS() operator:

CREATE TABLE file_search ( docs VARCHAR2(2000) PRIMARY KEY NOT NULL );

CREATE INDEX file_search_index ON file_search( docs ) INDEXTYPE IS ctxsys.context PARAMETERS ( 'datastore ctxsys.file_datastore filter ctxsys.inso_filter lexer ctxsys.basic_lexer' );

[[Some code to populate the table with a list of all files to index, including absolute paths]]

ALTER INDEX file_search_index REBUILD;

... a little later...

And then commit.

So far, so good. Unfortunately, when I try to _use_ the index -

select score(1),docs from file_search where contains( docs, 'query', 1 ) > 0;

I get no rows back, whatever my query is. Does anyone know where I'm getting it wrong?

- Jeremy Goldberg
Previous Topic: Creating an Intermedia Index
Next Topic: Problem configuring Net8 listener
Goto Forum:

Current Time: Wed May 18 02:34:08 CDT 2022