Getting ORA-14097 error after calling ctx_ddl.optimize_index
491403Feb 15 2012 — edited Feb 15 2012I got the following error when calling ctx_ddl.optimize_index(idx_name=>'PJR_OTXT_SEARCH_N3',optlevel=>'REBUILD');
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 946
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.
My questions:
1. What is "drftoptrebxch"?
2. What did "ctx_ddl.optiimize_index" try to do that would involve altering table partition?
Thanks.