SQL & PL/SQL

SQL> CREATE INDEX idx_detailResume ON detailResume(detailResume)
     INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS
     ('FILTER CTXSYS.NULL_FILTER SECTION GROUP CTXSYS.HTML_SECTION_GROUP');
  2    3  CREATE INDEX idx_detailResume ON detailResume(detailResume)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> CREATE INDEX idx_detailResume ON detailResume(detailResume)
INDEXTYPE IS CTXSYS.CONTEXT;
  2  CREATE INDEX idx_detailResume ON detailResume(detailResume)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume, 'cardiology', 1) > 0 and cat_id=5 order by SCORE(1) desc;
SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume, 'cardiology', 1) > 0 and cat_id=5 order by SCORE(1) desc
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed