My Oracle Support Banner

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

Last updated on AUGUST 01, 2018

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

SQL> alter package sys.DMP_SEC compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY SYS.DMP_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2494/7 PL/SQL: Statement ignored
2494/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2501/7 PL/SQL: Statement ignored
2501/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2519/7 PL/SQL: Statement ignored
2519/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2538/7 PL/SQL: Statement ignored
2538/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2557/7 PL/SQL: Statement ignored
2557/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2575/7 PL/SQL: Statement ignored
2575/25 PLS-00487: Invalid reference to variable 'VARCHAR2'
2594/7 PL/SQL: Statement ignored
2594/25 PLS-00487: Invalid reference to variable 'VARCHAR2'



2. Invalid ODM_NAIVE_BAYES_MODEL package


SQL> alter package sys.ODM_NAIVE_BAYES_MODEL compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY SYS.ODM_NAIVE_BAYES_MODEL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
line/col PL/SQL: Statement ignored
line/col PLS-00302: component 'INDEX_NAME_TYPE' must be declared

 

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.