OraFAQ Forum: Text & interMedia » Problems with file

Home » Server Options » Text & interMedia » Problems with file_datastore index.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Creating an Intermedia Index
Next Topic:	Problem configuring Net8 listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 22:41:59 CST 2025