Enable the Oracle Text feature to filter based on the contents of fields with long string
data types. Scripts are provided for Windows and Linux®.
Procedure
- Log on to the Oracle database server as a user with database
administrator privileges.
Note: You can enable Oracle Text only from the database server.
- Open a command or shell window, 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 computer as the IBM
OpenPages® with Watson™ server,
copy the script and the SQL files to the database server.
- Run the following batch command:
- Windows
-
EnableOpenPagesTextIndexing.bat <SID> <SYSDBA_USER_NAME> "<SYSDBA_PASSWORD>" <OPX_USER_NAME>
- Linux
-
EnableOpenPagesTextIndexing.sh <SID> <SYSDBA_USER_NAME> '<SYSDBA_PASSWORD>' <OPX_USER_NAME>
Note: All parameters are required.
Table 2. Parameters
in the batch command
| Parameter name |
Description |
<SID> |
The system ID or TNS alias for the OpenPages with Watson database instance. |
<SYSDBA_USER_NAME> |
Database SYSDBA account. Usually the SYS user. |
<SYSDBA_PASSWORD> |
Password for the SYSDBA user account. |
<OPX_USER_NAME> |
OpenPages with Watson application
schema owner name. |