You create a normal B-tree index and in the query you want to use a context
index which is something totally different.
So you get the error that a context index (now called InterMedia Text) does
not exists.
A context index is created with create index .... index type ctxsys.context
parameters (...);
Decide what index type you need.
Sergio <smeligr_at_libero.it> schreef in berichtnieuws
bbkq86$apgup$1_at_ID-186754.news.dfncis.de...
| where it is the error?
| I execute.
|
| CREATE INDEX my_table_idx ON my_table (Nom) ;
|
| OK
|
| When I execute the query
|
| SELECT * FROM my_table WHERE CONTAINS(my_table.pippo , 'pluto') >0;
|
| it comes given back the error to me
|
| ERRORE alla riga 1:
| ORA-20000: interMedia Text error:
| DRG-10599: la colonna non è indicizzata
|
| Thanks
| Sergio
|
|
Received on Wed Jun 04 2003 - 08:15:55 CDT
