Index: openacs-4/packages/intermedia-driver/sql/oracle/search-ctxsys.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/search-ctxsys.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/intermedia-driver/sql/oracle/search-ctxsys.sql	27 Jan 2006 16:33:02 -0000	1.1
@@ -0,0 +1,41 @@
+--
+--  Copyright (C) 2005 MIT
+--
+--  This file is part of dotLRN.
+--
+--  dotLRN is free software; you can redistribute it and/or modify it under the
+--  terms of the GNU General Public License as published by the Free Software
+--  Foundation; either version 2 of the License, or (at your option) any later
+--  version.
+--
+--  dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY
+--  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+--  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
+--  details.
+--
+
+--
+-- Create ctxsys schema objects for .LRN site-wide search
+--
+-- @author <a href="mailto:openacs@dirkgomez.de">openacs@dirkgomez.de</a>
+-- @version $Id: search-ctxsys.sql,v 1.1 2006/01/27 16:33:02 hughb Exp $
+-- @creation-date 13-May-2005
+--
+-- Partly ported from ACES.
+
+CREATE OR replace procedure sws_user_proc_&1 ( rid IN ROWID, tlob IN OUT nocopy clob )
+AS
+BEGIN
+   &1..sws_user_datastore_proc(rid, tlob);
+END;
+/
+show errors;
+
+grant execute on sws_user_proc_&1 to &1;
+
+grant ctxapp to &1;
+
+-- stuff to make interMedia faster
+exec ctx_adm.set_parameter('max_index_memory', '1G');
+
+exit;