Text Index Creation

Text Index Creation or interMedia Index creation or textindex

spool logs/imindex_attachment.log
drop index HIBM_COMMENTARY.MKTATTACHMENTS_ATTACHMENT;
execute ctx_adm.set_parameter('log_directory', '/opt/oracle/sami/imindex/logs');
execute CTX_OUTPUT.END_LOG;
execute ctx_output.start_log('mkt_attachments.log');
execute ctx_adm.set_parameter('max_index_memory', '600M');
execute ctx_ddl.drop_preference('mystore1');
execute ctx_ddl.create_preference('mystore1', 'BASIC_STORAGE');
execute ctx_ddl.set_attribute('mystore1', 'I_TABLE_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
execute ctx_ddl.set_attribute('mystore1', 'K_TABLE_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
execute ctx_ddl.set_attribute('mystore1', 'R_TABLE_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
execute ctx_ddl.set_attribute('mystore1', 'N_TABLE_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
execute ctx_ddl.set_attribute('mystore1', 'I_INDEX_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
execute ctx_ddl.set_attribute('mystore1', 'P_TABLE_CLAUSE','tablespace INDEX_TS storage (initial 5M)');
CREATE INDEX HIBM_COMMENTARY.mktattachments_attachment ON HIBM_COMMENTARY.MKT_ATTACHMENTS (attachment)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('datastore DIRECT_DATASTORE storage mystore1 filter ctxsys.inso_filter')
PARALLEL 4;
alter index HIBM_COMMENTARY.dr$MKTATTACHMENTS_ATTACHMENT$x rebuild nocompress;
execute CTX_OUTPUT.END_LOG;
spool off;