Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Intermedia index

Intermedia index

From: Olivier VEIT <oveit_at_infeurope.lu>
Date: Thu, 28 Feb 2002 16:49:09 +0100
Message-ID: <a5ljac$l55$1@wanadoo.fr>


Hello,

I've a column PDF_NOTICE_LB BLOB in my table ATTACH containing PDF files which contains text in FR, DE, IT and EN. To index this column, i simply execute : create index CTX_ATTACH_PDF_NOTICE_LB on ATTACH(PDF_NOTICE_LB) indextype is ctxsys.context;

This command is running but is very slow (45 min for indexing to PDF having each 170 Kb). But after indexing, i can't find anything then i use : select attach_id from attach where contains(PDF_NOTICE_LB,'test') >0;

If I try to index a lot of pdf file, oracle uses 99% processor but seems to do nothing.
It seems that the inso filter are OK (I used the ctxhx utility on one of my pdf document to test)

Has someone an idea wich could help me...or better : a solution ;-)

FYI : I'am using Oracle 8i (8.1.7) with Linux

Thank you very much Received on Thu Feb 28 2002 - 09:49:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US