invalid objects after clean ctxsys installation (oracle text)
November 9th, 2007The following objects are invalid after a clean ctxsys install.
Invalid objects
[REMI@DB01.REMIDIAN.COM]
SQL> @oj-in
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS
---------------------- -------------------------------- --------------- ---------- ------------- ------------------- -------
CTXSYS DBMS_DATA_MINING_DUMMY PACKAGE 08-11-2007 08-11-2007 2007-11-08:16:26:32 INVALID
DBMS_DATA_MINING_DUMMY PACKAGE BODY 08-11-2007 08-11-2007 2007-11-08:16:26:32 INVALID
DM_CLUSTER TYPE 08-11-2007 09-11-2007 2007-11-08:16:26:32 INVALID
DM_CLUSTERS 08-11-2007 08-11-2007 2007-11-08:16:26:32 INVALID
DRVODM PACKAGE BODY 08-11-2007 09-11-2007 2007-11-08:16:26:32 INVALID
[REMI@DB01.REMIDIAN.COM]
SQL>
Solution
Information below is from Oracle Metalink Support note ‘Doc ID: Note:421179.1′, https://metalink.oracle.com/metalink/plsql/f?p=130:14:9075528638450107162::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,421179.1,1,1,1,helvetica
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.
Metalink uri’s
Oh and by the way, don’t you just love the company that wants to be number one in the E-Business realm serves their documents? These unbelievable url’s even store information about font faces and sizes in it, it think it’s unbelievable. Did this brilliant application design derive from the same guy that built the Oracle.com portal? Ever tried to visit Oracle.com with a w3c compliant browser like Opera …