For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
begin ctx_ddl.create_preference('mystore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE', 'tablespace ...'); ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE','tablespace ...'); ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE','tablespace ...'); ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE','tablespace ...'); ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE','tablespace ...'); end; / alter index ... rebuild parameters ('storage mystore');
create index ... ... parameters ('lexer my_lexer sync (on commit)');
create index ... ... parameters ('lexer my_lexer sync (every ...)');