潛水珽的異想世界

1、oracle 10g全文检索组件是oracle text，安装/卸载方法如下：

The steps of context install on Oracle 10g.

1), create tablespace drsys
2), run @?/ctx/admin/catctx.sql ctxsys drsys temp01 nolock
3), run @?/ctx/admin/defaults/drdefus.sql
4), grant execute on ctxsys.ctx_ddl to public

The steps of context uninstall (remove) on Oracle 10g.

-- run as sys  
?/ctx/admin/catnoctx.sql

2、 检查是否安装了oracle text组件。

SQL> select comp_name,status from dba_registry;
 
COMP_NAME                                                                        STATUS
-------------------------------------------------------------------- ---------------------------------
Oracle Database Catalog Views                                        VALID
Oracle Database Packages and Types                            VALID
Oracle Text                                                                              VALID