Rebuild Oracle text and retain existing parameter
Hi all,
Is there a way rebuild oracle context index and retain its existing parameter?
create table tmp (col1 varchar2(20)); create index idx on tmp (col1) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('SYNC (on commit)'); SELECT dbms_metadata.get_ddl('INDEX', 'IDX') FROM DUAL; " CREATE INDEX "IDX" ON "TMP" ("COL1") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('SYNC (on commit)')" alter index idx rebuild ; SELECT dbms_metadata.get_ddl('INDEX', 'IDX') FROM DUAL; CREATE INDEX "IAMAIN"."IDX" ON "IAMAIN"."TMP" ("COL1") INDEXTYPE IS "CTXSYS"."CONTEXT"
After rebuild, parameter is NULLed out.
0