SQL & PL/SQL

CREATE TABLE accumtbl 
   (id NUMBER, text VARCHAR2(4000) );

INSERT INTO accumtbl VALUES 
   ( 1, 'the lite dog he big dog 
      while the other dog ate the dog food');
INSERT INTO accumtbl values 
   (2, 'the cat th the dog');


CREATE TABLE ns_accumtbl 
   (id NUMBER, text VARCHAR2(4000) );
 
INSERT INTO ns_accumtbl VALUES 
   ( 1, 'the lite dog he big dog 
      while the other dog ate the dog food');
INSERT INTO ns_accumtbl values 
   (2, 'the cat th the dog');

commit;
 
CREATE INDEX 
  ns_accumtbl_idx ON ns_accumtbl (text) 
   indextype is ctxsys.context;
  
PROMPT dog ACCUM cat

SELECT 
 *
FROM 
   ns_accumtbl, accumtbl 
WHERE 
accumtbl.id=ns_accumtbl.id
   AND CONTAINS (ns_accumtbl.text, accumtbl.text, 10) > 0;

getting error error-ORA-20000: Oracle Text error:
DRG-10599: column is not indexed


but still I have index created....