Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to fix invalid objects

ebsappsgirlJul 7 2015 — edited Jul 7 2015

I'm a bit new to the core dba side of things....I'm trying to fix some invalid objects I received doing some pre-upgrade tasks. I ran the catnoamd.sql script and it produce invalids. Here are all of my invalid objects:

OWNER     OBJECT_TYPE OBJECT_NAME STATUS

-------------------- ------------------- ------------------------------ -------

OLAPSYS      PACKAGE BODY CWM$EXPORT INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_DELETE INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_EXPORT INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_METADATA_REFRESH INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_MR_SECURITY_INIT INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_OLAPAPI_ENABLE INVALID

OLAPSYS      PACKAGE BODY CWM2_OLAP_VERIFY_ACCESS INVALID

OLAPSYS      PACKAGE BODY DBMS_AWM INVALID

OLAPSYS      PACKAGE BODY DBMS_ODM INVALID

OLAPSYS      PACKAGE BODY OLAPDIMVIEW INVALID

OLAPSYS      PACKAGE BODY OLAPFACTVIEW INVALID

OWNER     OBJECT_TYPE OBJECT_NAME STATUS

-------------------- ------------------- ------------------------------ -------

OLAPSYS      VIEW ALL$OLAP2UFACT_LEVEL_USES INVALID

OLAPSYS      VIEW ALL$OLAP2_FACTTBLFCTMAPS INVALID

OLAPSYS      VIEW ALL$OLAPMR_FACTTBLFCTMAPS INVALID

OLAPSYS      VIEW DBA$OLAP2UFACT_LEVEL_USES INVALID

OLAPSYS      VIEW DBA$OLAP2_FACTTBLFCTMAPS INVALID

OLAPSYS      VIEW DBA$OLAPMR_FACTTBLFCTMAPS INVALID

OLAPSYS      VIEW ODM$OLAP2UFACT_LEVEL_USES INVALID


I have tried

alter package OLAPFACTVIEW

  2  compile body;


and several version of this command to get rid of the invalids. Can someone explain to me what I'm doing wrong, show me how to do this correctly and provide any documentation that will explain throughly what I need to know about invalid objects.


Thanks!!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2015
Added on Jul 7 2015
4 comments
1,434 views