I would like to know what does it means when the creation of the index and the status keeps to be "INPRGORS".
CREATE INDEX CTXT_IDX_DVC_1
ON DVC_DOCUMENT_VAULT (DVC_CONTENT)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('Sync (ON COMMIT)')
SQL> select status from dba_indexes where index_name='CTXT_IDX_DVC_1';