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!

Oracle Text, ctxsys.context problem with number column

882532Nov 21 2012 — edited Nov 26 2012

Hi,

DB 11.2.0.3

Is there any solution to create ctxsys.context index on number column ? Or I have to create other index type ?

When I try do that (create ctxsys.context index), I get

09:01:18  ORA-29855: wystąpił błąd przy wykonywaniu podprogramu ODCIINDEXCREATE  (An error has occurred in the performance of the subprogram)
09:01:18  ORA-20000: Oracle Text - błąd: (- error:)
09:01:18  DRG-10509: niepoprawna kolumna tekstowa: ITEM_TYPE (invalid text column:)
09:01:18  ORA-06512: przy "CTXSYS.DRUE", linia 160
09:01:18  ORA-06512: przy "CTXSYS.TEXTINDEXMETHODS", linia 366

Btw, is there possible to search like "*LIKE %123%*" clause any of index (in contains) ?

Edited by: Ndejo on 2012-11-21 00:53

This post has been answered by Roger Ford-Oracle on Nov 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2012

Added on Nov 21 2012

#database-key-features, #text

5 comments

949 views