CREATE INDEX xxcss_qot_line_ctx_indx
ON apps.xxcss_qot_lines_search_bk (dummy)
INDEXTYPE IS ctxsys.CONTEXT
PARAMETERS ('
 datastore xxcss_qot_lines_search_ds 
 section group xxcss_qot_lines_search_sg 
 storage xxcss_qot_lines_search_sf 
 filter ctxsys.null_filter 
 lexer xxcss_qot_lines_search_lx 
 stoplist ctxsys.empty_stoplist 
 memory 50m transactional'
 );


/* Formatted on 2010/03/09 11:16 (Formatter Plus v4.8.8) */
BEGIN
   ctx_ddl.create_preference ('xxcss_qot_lines_search_ds', 'user_datastore');
   ctx_ddl.set_attribute
                      ('xxcss_qot_lines_search_ds',
                       'procedure',
                       'apps.xxcss_qot_search_mdata_b.lines_search_indx_proc'
                      );
END;

BEGIN
   ctx_ddl.create_section_group ('xxcss_qot_lines_search_sg',
                                 'html_section_group'
                                );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'quotelineid',
                              'quotelineid'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'quoteheaderid',
                              'quoteheaderid'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'productname',
                              'productname'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'installsite',
                              'installsite'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'servicelevel',
                              'servicelevel'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'serialnumber',
                              'serialnumber'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'scontractnum',
                              'scontractnum'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'tcontractnum',
                              'tcontractnum'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'projectnumber',
                              'projectnumber'
                             );
   ctx_ddl.add_mdata_section ('xxcss_qot_lines_search_sg',
                              'asptqotnumber',
                              'asptqotnumber'
                             );
END;

BEGIN
   ctx_ddl.create_preference ('xxcss_qot_lines_search_lx', 'BASIC_LEXER');
   ctx_ddl.set_attribute ('xxcss_qot_lines_search_lx', 'INDEX_THEMES', 'NO');
END;

BEGIN
   ctx_ddl.create_preference ('xxcss_qot_lines_search_wdl', 'BASIC_WORDLIST');
   ctx_ddl.set_attribute ('xxcss_qot_lines_search_wdl', 'STEMMER', 'ENGLISH');
   ctx_ddl.set_attribute ('xxcss_qot_lines_search_wdl',
                          'FUZZY_MATCH',
                          'GENERIC'
                         );
END;

BEGIN
   ctx_ddl.create_preference ('xxcss_qot_lines_search_sf', 'basic_storage');
END;

BEGIN
   ctx_ddl.set_attribute
             ('xxcss_qot_lines_search_sf',
              'i_table_clause',
              'tablespace xxcssd1 storage (initial 1024M next 20M) nologging'
             );
END;

BEGIN
   ctx_ddl.set_attribute ('xxcss_qot_lines_search_sf',
                          'k_table_clause',
                          'tablespace xxcssd1 nologging'
                         );
END;

BEGIN
   ctx_ddl.set_attribute
      ('xxcss_qot_lines_search_sf',
       'r_table_clause',
       'tablespace xxcssd1 lob(data)store as (disable storage in row nocache nologging) nologging'
      );
END;

BEGIN
   ctx_ddl.set_attribute ('xxcss_qot_lines_search_sf',
                          'n_table_clause',
                          'tablespace xxcssd1 nologging'
                         );
END;

BEGIN
   ctx_ddl.set_attribute
      ('xxcss_qot_lines_search_sf',
       'i_index_clause',
       'tablespace xxcssd1 storage (initial 256M next 20M)compress 2 nologging'
      );
END;