Oracle Text (MOSC)

MOSC Banner

Rebuild Oracle text and retain existing parameter

edited Oct 16, 2015 9:56AM in Oracle Text (MOSC) 1 commentAnswered ✓

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center