Skip to Main Content
Forums

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

Comments

unknown-7404

Not my area of expertise.

But I did notice that the two references use a DIFFERENT case:

This is the message you said you get:

error creating bean with name 'entitymanagerfactory'

That name is ALL lowercase.

This is what you say is in the XML file:

<bean id="entityManagerFactory"

That uses MIXED case for the value.

Perhaps that is the reason the two don't match?

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 27 2017
Added on Mar 21 2017
#blob, #database-key-features, #text
12 comments
4,154 views