Oracle Text

Introduction to Oracle Text can be found at Oracle documentation website named 'Text Reference' for different versions.

Oracle Text installation should be completed during the Oracle Installtion using OUI.

Using the following procedure to confirm Oracle Text installation:

Login to an account with DBA privileges and confirm that the CTXSYS user exists.

SELECT username FROM dba_users WHERE username='CTXSYS';

If there is no CTXSYS user, then it is not installed. It is best to use OUI to install it.

Doc 275689.1 in metalink is also a good reference for manual installation of Oracle Text 9.2.

Installing Oracle Text for 10gR2:
@$ORACLE_HOME/ctx/admin/catctx.sql ctxsys DRSYS TEMP NOLOCK
where ctxsys is the install schema, DRSYS is the default tablespace, Temp is well - temp tablespace for that user, and NOLOCK instructs the script to not lock the account when the install is complete (which by the way, you should lock).

If DRG-10700 comes up, check doc 107626.1 in metalink.

A good post for Oracle Text Indexing is here:
http://www.oracle-base.com/articles/9i/FullTextIndexingUsingOracleText9i.php