invalid objects after clean ctxsys installation (oracle text)

  • Published on Nov 9 2007
  • # 2,414
  • oracle

The 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 …

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>