My Oracle Support Banner

Invalid ODM Objects After Upgrade To Oracle 11g Release (Doc ID 784828.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Data Mining - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

After upgrade of Oracle 10.1 or 10.2 to version 11g, invalid objects occur in the database. E.g.:

 

select owner,object_name,object_type from dba_objects where status='INVALID' and owner='SYS';

OWNER        OBJECT_NAME                         OBJECT_TYPE
------------ ----------------------------------- -------------------
SYS          ATTRIBUTE_HISTOGRAM_TAB_TYPE        TYPE
SYS          ATTRIBUTE_HISTOGRAM_TYPE            TYPE
SYS          CATEGORY_TAB_TYPE                   TYPE
SYS          CENTROID_TAB_TYPE                   TYPE
SYS          CHILD_TAB_TYPE                      TYPE
SYS          CLUSTER_RULE_ELEMENT_TAB_TYPE       TYPE
SYS          CLUSTER_RULE_ELEMENT_TYPE           TYPE
SYS          CLUSTER_RULE_TAB_TYPE               TYPE
SYS          CLUSTER_RULE_TYPE                   TYPE
SYS          CLUSTER_TAB_TYPE                    TYPE
SYS          CLUSTER_TYPE                        TYPE

OWNER        OBJECT_NAME                         OBJECT_TYPE
------------ ----------------------------------- -------------------
SYS          CL_PREDICATE_TAB_TYPE               TYPE
SYS          CL_PREDICATE_TYPE                   TYPE
SYS          DMP_SEC                             PACKAGE BODY
SYS          HISTOGRAM_ENTRY_TAB_TYPE            TYPE
SYS          ODM_NAIVE_BAYES_MODEL               PACKAGE BODY
SYS          PREDICATE_TAB_TYPE                  TYPE
SYS          PREDICATE_TYPE                      TYPE

Of the list above, only  DMP_SEC  is in 11G. The rest are deprecated 10G objects.

 

 


 
1. Invalid DMP_SEC package

 

Changes

The Oracle database has been upgraded from 10.1 or 10.2 to version 11g

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.