Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

[RESOLVED] Indexing a BLOB with Oracle Text

seb93Mar 21 2017 — edited Mar 30 2017

Hello,

I am a beginner in Oracle Text.

I created a table (docs) with two colums (numero NUMBER, doc BLOB) to store documents PDF and Microsoft Word.

I would create an index with the column doc but it doesn't work.

CODE:

create index myindex on docs(doc)

indextype is ctxsys.context

PARAMETERS (FILTER CTXSYS.AUTO_FILTER);

Index is really created but no words are stored in the tables (DR$MYINDEX$I, DR$MYINDEX$K, DR$MYINDEX$N, DR$MYINDEX$R) wich are created by Oracle Text.

Can you help me please ?

This post has been answered by Roger Ford-Oracle on Mar 30 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2017

Added on Mar 21 2017

#blob, #database-key-features, #text

12 comments

3,849 views