Drop a long string index

Remove the long string index. An index must be dropped before it can be re-created. Scripts are provided for both Windows and Linux®.

Procedure

  1. Log on to a system as a user with Administrator privileges. You can use any system with access to SQL*Plus that can connect to the IBM OpenPages® database server.
  2. Open a command or shell window, then navigate to the full-text-index directory as follows.
    The following table identifies the installation location of the application on the Microsoft Windows and Linux operating systems.
    Table 1. Installation location of the full-text-index directory
    Operating system Installation location
    Windows <OP_HOME>\aurora\bin\full-text-index
    Linux <OP_HOME>/aurora/bin/full-text-index
    Note: If the database server is not on the same machine as the OpenPages server, you must copy the script, and the SQL files it invokes, to the database server.
  3. Run the following command:
    Windows 
    DropOpenPagesTextIndex.bat <SID> <OPX_USER_NAME> "<OPX_USER_PASSWORD>"
    Linux 
    DropOpenPagesTextIndex.sh <SID> <OPX_USER_NAME> '<OPX_USER_PASSWORD>'
    Table 2. Parameters
    Parameter name Description
    <SID> The system ID or TNS alias for the OpenPages database instance.
    <OPX_USER_NAME> OpenPages database schema owner name.
    <OPX_USER_PASSWORD> OpenPages database schema owner password.

What to do next

You must re-create the index before filtering on the content of long string fields again. For details on creating a long string index, see Create a long string index for an Oracle database.