Forum Stats

  • 3,875,969 Users
  • 2,267,003 Discussions
  • 7,912,382 Comments

Discussions

Recursively Index Subdirectories?

666017
666017 Member Posts: 1
edited Oct 20, 2008 3:20AM in Text
I'm using "Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production" version of Oracle Text.

I have a directory, documents/, that has subdirectories (pdf/, ppt/, txt/, html/ ... etc.) each containing multiple files of the type specified by the folder. I am trying to index the documents/ directory such that the files located in documents/'s subdirectories are also indexed. First, I create the table:
create table MultiFormat(a int, b varchar2(255));
Second, I create preferences to store the PATH information
begin
          ctx_ddl.create_preference('MyPrefs', 'FILE_DATASTORE');
          ctx_ddl.set_attribute('MyPrefs', 'PATH', '/home/oracle/documents');
end;
/
Third, I insert the paths to the files into the MultiFormat table. Here's what a portion of it looks like in sqldeveloper: http://dl-client.getdropbox.com/u/10591/oracle.png

When I run the following CREATE INDEX:
create index MultiFormatIndex on MultiFormat(b) indextype is ctxsys.context parameters (' datastore MyPrefs filter ctxsys.auto_filter 
stoplist ctxsys.default_stoplist lexer nostems wordlist nowords memory 512M ')
The index tables are created, but they are empty. I also tried inserting the full path to each document (rather than the relative path compared to PATH) in the table, but that didn't work either.

What do I need to change to get recursive indexing for Oracle Text?

Answers

This discussion has been closed.