Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Intermedia index
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