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