Index: openacs-4/packages/intermedia-driver/sql/oracle/load-site-wide-search =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/load-site-wide-search,v diff -u -N --- openacs-4/packages/intermedia-driver/sql/oracle/load-site-wide-search 11 Mar 2006 14:26:29 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,48 +0,0 @@ -# -# 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. -# - -# -# This is the script to create the site-wide-search package for .LRN -# -# @author openacs@dirkgomez.de -# @version $Id: load-site-wide-search,v 1.2 2006/03/11 14:26:29 daveb Exp $ -# @creation-date 13-May-2005 -# -# Ported from ACES. -# -# prerequisites: - -# Oracle 8.1.7.4 (I have not tried .LRN search with Oracle 9i, but -# it'll probably work, it won't work with Oracle 10g.) -# Also consider this Oracle bug.: -# http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=261880.1 - -# Call with load-site-wide-search dbuser passwd ctxsyspasswd. - -USERNAME=$1 -PASSWORD=$2 -CTXSYS_PASSWORD=$3 - -# For programming convenience just drop everything -sqlplus ${USERNAME}/${PASSWORD} @search-tables-drop.sql -sqlplus ${USERNAME}/${PASSWORD} @search-packages-drop.sql -sqlplus ${USERNAME}/${PASSWORD} @search-index-drop.sql ${USERNAME} ${PASSWORD} - -sqlplus ${USERNAME}/${PASSWORD} @search-tables-create.sql -sqlplus ${USERNAME}/${PASSWORD} @search-packages-create.sql -sqlplus ctxsys/${CTXSYS_PASSWORD} @search-ctxsys.sql ${USERNAME} ${PASSWORD} -sqlplus ${USERNAME}/${PASSWORD} @search-index-create.sql ${USERNAME} ${PASSWORD} -sqlplus ${USERNAME}/${PASSWORD} @search-from-scratch.sql