Home » Server Options » Text & interMedia » Oracle 10.2.0.1.0 AUTO_FILTER not works (Oracle 10.2.0.1.0)
Oracle 10.2.0.1.0 AUTO_FILTER not works [message #386589] Mon, 16 February 2009 03:35
eherva
Messages: 1
Registered: February 2009
Junior Member
Hi,

I am using Oracle 10.2.0.1.0.
I have a problem with filtering binary documents (.doc, .pdf, text...)
I created a table with a column of type BLOB and I have several types of documents inserted.

CREATE TABLE PRUEBAS_DOCS
(
ID NUMBER(10) NOT NULL,
NAME VARCHAR2(200 BYTE) NOT NULL,
BLOB_DOC BLOB NOT NULL
)

And then I have created context index:

CREATE INDEX PRUEBAS_DOCS_IE1 ON PRUEBAS_DOCS(BLOB_DOC)
INDEXTYPE IS ctxsys.context
PARAMETERS('filter CTXSYS.AUTO_FILTER')

When I execute the query using CONTAINS operator, not works because doesn´t return any row

SELECT id, name
FROM pruebas_docs
WHERE CONTAINS(blob_doc, 'application', 1) > 0
-------------------------------------------------
No rows returned.


If I change the filter to NULL_FILTER instead of AUTO_FILTER, works fine.

However, reading the Oracle documentation I understood that if the documents are of mixed formats should be used AUTO_FILTER.
Is this correct? ¿Can someone tell me the correct parameters for indexing binary files contained in the database in a BLOB field?

Thank you very much!
Previous Topic: Index Type CTXSYS.CONTEXT not being used, any help?
Next Topic: What is Score(1) in Oracle Text?
Goto Forum:
  


Current Time: Thu Mar 28 08:19:33 CDT 2024