CREATE TABLE text_tab
 ( 
  "ID"  NUMBER NOT NULL ENABLE, 
  "TYPE"  VARCHAR2(200 CHAR) NOT NULL ENABLE, 
  "TEXT_COL" VARCHAR2(4000 CHAR), 
  "CATEGORY" VARCHAR2(30) NOT NULL ENABLE, 
  CONSTRAINT "TEXT_TAB_PK" PRIMARY KEY ("ID")
 );
 
Table created.

BEGIN
 ctx_ddl.create_preference ('TEXT_TAB_PREF','world_lexer');
END;
/

PL/SQL procedure successfully completed.

BEGIN
 EXECUTE IMMEDIATE 'CREATE INDEX text_ind ON text_tab(text_col) INDEXTYPE IS CTXSYS.CONTEXT ONLINE FILTER BY CATEGORY PARAMETERS('' SYNC (ON COMMIT) LEXER TEXT_TAB_PREF'')';
END;
/

Index created.

SELECT object_name, status FROM user_objects WHERE object_name LIKE 'DR$%' AND object_name LIKE '%TEXT_IND%';

OBJECT_NAME        STATUS
------------------ -------
DR$TEXT_IND$X      VALID  
DR$TEXT_IND$S      VALID  
DR$TEXT_IND$R      VALID  
DR$TEXT_IND$N      VALID  
DR$TEXT_IND$K      VALID  
DR$TEXT_IND$I      VALID  

SELECT index_name,table_name,status, parameters, domidx_status,domidx_opstatus FROM user_indexes WHERE index_type='DOMAIN' AND index_name='TEXT_IND';

INDEX_NAME     TABLE_NAME      STATUS   PARAMETERS                              DOMIDX_STATU DOMIDX
-------------- --------------- -------- --------------------------------------- ------------ ------
TEXT_IND       TEXT_TAB        VALID     SYNC (ON COMMIT) LEXER TEXT_TAB_PREF   VALID        VALID 

BEGIN
  ctx_ddl.optimize_index('TEXT_IND','REBUILD');
END;
/

Error report -
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drftoptrebxch
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1161
ORA-06512: at line 2
20000. 00000 -  "%s"
*Cause:    The stored procedure 'raise_application_error'
           was called which causes this error to be generated.
*Action:   Correct the problem as described in the error message or contact
           the application administrator or DBA for more information.

-- Run from SYS schema
SELECT * FROM dba_objects WHERE status!='VALID';

no rows