A CTXCAT index is transactional. When you perform DML (inserts, updates, and deletes) on the base table, Oracle Text automatically synchronizes the index. Unlike a CONTEXT index, no CTX_DDL.SYNC_INDEX is necessary.
Note:
Applications that insert without invoking triggers such as SQL*Loader will not result in automatic index synchronization as described in this section.