Friday, November 20, 2009

ORA-20000: Oracle Text error: DRG-10599: column is not indexed

Description:
Below error occured while selecting the values from table (Oracle Text)
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

Solution I tried:
I created the index using the below command
SQL>create index index_name on table_name (column_name) indextype is ctxsys.context;

No comments: