My Oracle Support Banner

Invalid DMSYS Objects After Upgrading The Database (Doc ID 2587471.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Data Mining - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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

After upgrading the database, there are three invalid DMSYS objects and ODM component is invalid in dba_registry.


LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit PUBLIC.DBMS_SQL (referenced
        by DMSYS.DM_QGEN)

0/0      PLS-00907: cannot load library unit PUBLIC.DBMS_SQL (referenced
        by DMSYS.DM_QGEN)

23/3     PL/SQL: Item ignored
85/5     PL/SQL: Statement ignored
290/3    PL/SQL: Item ignored
290/3    PLS-00311: the declaration of "TREF_DESC" is incomplete or
        malformed

349/3    PL/SQL: Item ignored
349/3    PLS-00311: the declaration of "GET_COLUMNS" is incomplete or
        malformed

424/36   PL/SQL: Item ignored
424/36   PLS-00311: the declaration of "V_DESC_ITAB" is incomplete or
        malformed

427/5    PL/SQL: Statement ignored
429/41   PLS-00320: the declaration of the type of this expression is
        incomplete or malformed

432/5    PL/SQL: Statement ignored
434/41   PLS-00320: the declaration of the type of this expression is
        incomplete or malformed

Changes

 Upgrade. All objects were valid before upgrade

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.