Les
Дата: 24.11.2009 11:30:01
Создаю индекс, поле варчар2
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> CREATE INDEX "ICATU_VCANNOTATION" ON "CATALOG_U" ("VCANNOTATION")
2 INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('sync (on commit)')
3 /
Index created.
SQL> select * from catalog_u where CONTAINS('VCANNOTATION','ÐÀÄÀ%')>0;
select * from catalog_u where CONTAINS('VCANNOTATION','ÐÀÄÀ%')>0
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
Есть идеи, что не так? Заранее спасибо