这两天周末没事，对Oracle text发生了兴趣（之前一直没实际用过，也没太花时间关注过）.找到了《Oracle 10gR2 text Reference》后，想测试玩玩，结果发现我的系统中没有装这部分东西（因为我是手工建的库，如果通过Database Configuration Assistant (DBCA建库的话，text就默认被安装了）

Oracle Text is available for no extra Licensing in all four database editions:
Oracle Database Standard Edition One,
Oracle Database Standard Edition (SE),
Oracle Database Enterprise Edition (EE)
Oracle Database Personal Edition.

安装的过程比较简单

Note: In SQL*Plus we use '?' instead of $ORACLE_HOME

1. Text dictionary, schema name CTXSYS, is created by calling following script from SQL*Plus connected as SYSDBA:

SQL> conn /as sysdba;
SQL> spool setup_info.txt
SQL> start ?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK;

Where:
CTXSYS - is the ctxsys user password
SYSAUX - is the default tablespace for ctxsys
TEMP - is the temporary tablespace for ctxsys
LOCK|NOLOCK - ctxsys user account will be locked or not

2. The next step is to install appropriate language-specific default preferences. There is script
which creates language-specific default preferences for every language Oracle text supports in
/ctx/admin/defaults directory, such as English(US), Danish(DK), Dutch(NL), Finnish(SF), French(F),
German(D), Italian(IT), Portuguese(PT), Spanish(E), and Swedish(S). They are named in the form
drdefXX.sql, where XX is the international license plate code.

To manually install US default preferences, for example, log into sqlplus as CTXSYS, and
run 'drdefus.sql' as described below:

SQL> conn CTXSYS/CTXSYS;
SQL> start ?/ctx/admin/defaults/drdefus.sql
SQL> spool off

安装完了以后在做个简单的检查
SQL> -- check on setup
SQL> select comp_name, status, substr(version,1,10) as version
2 from dba_registry
3 where comp_id = 'CONTEXT';

COMP_NAME STATUS VERSION
---------------- ---------------------- -----------
Oracle Text VALID 10.2.0.2.0

SQL> select * from ctxsys.ctx_version;

VER_DICT VER_CODE
---------- ---------------
10.2.0.2.0 10.2.0.2.0

SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;

VER_CODE
-------------
10.2.0.2.0

SQL> select count(*) from dba_objects where owner='CTXSYS';

COUNT(*)
----------
339

SQL> -- Get a summary count
SQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;

OBJECT_TYPE COUNT(*)
------------------- ----------
SEQUENCE 3
PROCEDURE 2
OPERATOR 6
LIBRARY 1
PACKAGE 71
PACKAGE BODY 58
LOB 1
TYPE BODY 7
FUNCTION 5
VIEW 54
TABLE 37
INDEX 46
INDEXTYPE 4
TYPE 44

14 rows selected

SQL> -- Any invalid objects
SQL> select object_name, object_type, status
2 from dba_objects
3 where owner='CTXSYS' and status != 'VALID' order by object_name;

OBJECT_NAME OBJECT_TYPE STATUS
---------------- ------------------- -------

SQL>

如果要卸载Oracle text的话，调用另外的脚本即可完成：
SQL> start ?/ctx/admin/catnoctx.sql;

动作比较简单，但我之前没有接触过，所以还是不知道，通过今天的研究，才算对这部分东西入了门。

关于Oracle text的详细资料，可以参考Part Number B14218-01.