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.

Error creating index on CLOB

308023Mar 11 2004 — edited Mar 17 2004
I have a table TABLENAME with "Value" as the column. Pls not that the column name is explicitly specified as "Value" using double quotes. The table is created fine, unitl I decided to create a index on this column on this table to enable Context searches on this column.

I do :
Create Index idx on TABLENAME("Value") indextype is ctxsys.context;

I get the following error.....if my colun name is a simple name (without the doubleqoutes), everything is ok, but that is not what the application scenario needs.

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10582: column VALUE does not exist in table TABLENAME
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186


Any pointers to resolve this would be helpful.

TIA
Ravneet

Comments

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

Post Details

Locked on Apr 14 2004
Added on Mar 11 2004
#database-key-features, #text
5 comments
375 views