Oracle Text Index..

We created Oracle Text Index with the following Scripts. This is working fine.

begin

  ctx_ddl.create_preference('"IDX_XY_DST"','MULTI_COLUMN_DATASTORE');

  ctx_ddl.set_attribute('"IDX_XY_DST"','COLUMNS','COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COLUMN6, COLUMN7, COLUMN8, COLUMN9, COLUMN10, COLUMN11');

end;

/

begin

  ctx_ddl.create_preference('"IDX_XY_FIL"','NULL_FILTER');

end;

/

begin

  ctx_ddl.create_section_group('"IDX_XY_SGP"','AUTO_SECTION_GROUP');

end;

/

begin

  ctx_ddl.create_preference('"IDX_XY_LEX"','BASIC_LEXER');

end;

/

begin

  ctx_ddl.create_preference('"IDX_XY_WDL"','BASIC_WORDLIST');