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