Re: Oracle Text and indexes

RicercatoreSbadato wrote:
> How can I know if my text in the db has been indexed ?
>
> If I use
>
> select * from dr$idx_docs$i;
>
> (idx_docs is the context index)
>
> I have all the things that my index ha indexed... but it's not human
> readable. Are there other ways?

I wouldn't go to the DR$ tables. Just issue a contains query...

SQL> create table t0622(c varchar2(100));

Table created.

SQL> insert into t0622 values('qwerty');

1 row created.

SQL> select * from t0622 where contains(c,'qwerty') > 0; select * from t0622 where contains(c,'qwerty') > 0 *
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

SQL> create index t0622_i on t0622(c) indextype is ctxsys.context;

Index created.

SQL> select * from t0622 where contains(c,'qwerty') > 0;

C

qwerty

SQL> Regards,

Steve Received on Thu Jun 22 2006 - 17:42:51 CDT