| 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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
