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