not exactly what I was expected
Ionut Preda, August 16, 2017 - 4:31 am UTC
Hello Chris,
I observed into Tim's article that it is used CLOB as data type to hold the documents into the table.
My question was regarding BLOB or BFILE data type.
Is it possible to classify this kind of data type?
Thank you,
Ionut Preda.
August 16, 2017 - 1:42 pm UTC
Are we reading the same article?
Certainly looks like it uses blobs to me:
In this example we will store the data in a BLOB column, which allows us to store binary documents like Word and PDF as well as plain text
Ionut Preda, August 16, 2017 - 3:07 pm UTC
Hello Chris,
The phase you provided refers to CONTEXT index which is used for document collection application.
For classifying application, as it is described in same document, it should be used CTXRULE index which is used with MATCHES function, to build document classification application.
... and in the table definition used for example:
CREATE TABLE my_docs (
id NUMBER(10) NOT NULL,
name VARCHAR2(200) NOT NULL,
doc CLOB NOT NULL
);
doc column is CLOB and not BLOB or BFILE.
That's why I am saying the article is not relevant.
Am I wrong somehow?
August 16, 2017 - 3:48 pm UTC
Gotcha, I missed the part about classifying.
When you say:
but I couldn't do it for BLOBs or BFILEs.
What exactly have you tried, and why didn't it work?
I think they are talking about the limitation of MATCHES
paul, August 16, 2017 - 5:49 pm UTC
August 17, 2017 - 1:19 am UTC