This content has been marked as final. Show 1 reply
did the row existed before creating the index or did you add the row after creating? You have created the index without a sync option, so a new row will not be reflected in index, only after a sync.
A quick sync goes with
Furthermore you could add a sync to the index creation, after that every commit will also sync the index:
begin ctx_ddl.sync_index('ITXT_TITULAR' ); end;
Herald ten Dam
create index ITXT_TITULAR on CPR_PRACTICAL_CASE(sztitular) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC ( ON COMMIT)') ;