My Oracle Support Banner

Invalid SYS.DBMS_ODM After Upgrade To 10G (Doc ID 1080462.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Oracle OLAP - Version 10.2.0.1 to 10.2.0.5 [Release 10.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 upgrading database from 9i  to 10g , the following objects are left invalid.

sys.DBMS_ODM package body.


alter package sys.DBMS_ODM compile body;

Warning: Package Body altered with compilation errors.

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

0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00304: cannot compile body of 'DBMS_ODM' without its
specification

Package has no body in SYS

BUT :
select owner, object_name, object_type, status
from dba_objects
where object_name = 'DBMS_ODM';

returns the following:

SYS DBMS_ODM PACKAGE BODY INVALID
PUBLIC DBMS_ODM SYNONYM VALID
OLAPSYS DBMS_ODM PACKAGE VALID
OLAPSYS DBMS_ODM PACKAGE BODY VALID

Changes

The database was upgraded. This could also occur with new installation.

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.