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

Last updated on FEBRUARY 02, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms