Index: openacs-4/packages/search/sql/oracle/search-index-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/Attic/search-index-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/search/sql/oracle/search-index-create.sql	21 May 2005 11:34:10 -0000	1.1
+++ openacs-4/packages/search/sql/oracle/search-index-create.sql	8 Nov 2005 18:24:06 -0000	1.2
@@ -28,16 +28,25 @@
   ctx_ddl.create_section_group('swsgroup', 'basic_section_group');
   ctx_ddl.add_field_section('swsgroup', 'oneline', 'oneline', TRUE);
 end;
-/  
+/  create index swi_index on site_wide_index (indexed_content)
+indextype is ctxsys.context parameters ('datastore ctxsys.default_datastore memory 250M');
 
+
 -- create intermedia index for site wide index
 begin
   ctx_ddl.create_preference('sws_user_datastore', 'user_datastore');
   ctx_ddl.set_attribute('sws_user_datastore', 'procedure', 'sws_user_proc_&1');
 end;
 /
 
-create index sws_ctx_index on site_wide_index (datastore)
-indextype is ctxsys.context parameters ('datastore sws_user_datastore memory 250M section group swsgroup');
+--create index swi_ctx_index on site_wide_index (datastore)
+--indextype is ctxsys.context parameters ('datastore sws_user_datastore memory 250M section group swsgroup');
 
+
+--create index swi_ctx_index on site_wide_index (datastore)
+--indextype is ctxsys.context parameters ('datastore ctxsys.default_datastore memory 250M');
+
+create index swi_index on site_wide_index (indexed_content)
+indextype is ctxsys.context parameters ('datastore ctxsys.default_datastore memory 250M');
+
 exit;
\ No newline at end of file