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