SQL>
SQL> create table my_html_docs
2 ( id number primary key,
3 html_text varchar2(4000))
4 /
Table created.
SQL>
SQL> insert into my_html_docs( id, html_text )
2 values( 1,
3 '
4 Oracle
5 This
6 ' )
7 /
1 row created.
SQL>
SQL> select id from my_html_docs where contains( html_text, 'Oracle' ) > 0
2 /
select id from my_html_docs where contains( html_text, 'Oracle' ) > 0
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
SQL>
SQL> drop table my_html_docs;
Table dropped.
SQL>