SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/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
SQL> connect CTXSYS/password@tns_alias
SQL> @?/ctx/admin/defaults/drdefus.sql
SQL> spool off
connect SYS/password as SYSDBA
------------------- cut here ------------------------------
set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log
-- check on setup
select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';
select * from ctxsys.ctx_version;
select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
select count(*) from dba_objects where owner='CTXSYS';
-- Get a summary count
select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;
-- Any invalid objects
select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;
spool off
------------------- cut here ------------------------------
You should get: "no rows selected".
text_install_verification.log的内容：
SQL> select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';
COMP_NAME STATUS VERSION
------------------------------ ---------------------- --------------------
Oracle Text VALID 10.2.0.3.0
SQL> select * from ctxsys.ctx_version;
VER_DICT VER_CODE
---------- --------------------
10.2.0.3.0 10.2.0.3.0
SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
VER_CODE
--------------------
10.2.0.3.0
SQL>
SQL> select count(*) from dba_objects where owner='CTXSYS';
COUNT(*)
----------
339
SQL>
SQL> -- Get a summary count
SQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;
OBJECT_TYPE COUNT(*)
-------------------- ----------
INDEX 46
TYPE BODY 7
INDEXTYPE 4
PROCEDURE 2
TABLE 37
TYPE 44
VIEW 54
FUNCTION 5
LIBRARY 1
PACKAGE BODY 58
OPERATOR 6
SEQUENCE 3
LOB 1
SEQUENCE 3
LOB 1
PACKAGE 71
14 rows selected.
SQL>
SQL> -- Any invalid objects
SQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;
no rows selected 结果正确。
metalink中有提示：
You must install Oracle Data Mining (ODM), feature available in Oracle Database Enterprise Edition (EE), before you install Oracle Text in order to use the SVM classifier and the KMEANS clustering. All other functions should work without ODM installed, including RULE classifier and TEXTK clustering.
有些oracle text功能必须安装ODM才能使用，有些功能不需要安装ODM即可使用。[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16298743/viewspace-1056856/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
