Invalid Objects In OLAPSYS Schema and Unable To Recompile (Doc ID 820783.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle OLAP - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

The following objects are listed as INVALID, even after recompiling them:

OLAPSYS.CWM2_OLAP_AW_AWUTIL
OLAPSYS.CWM2_OLAP_EXPORT
OLAPSYS.CWM2_OLAP_MANAGER
OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE
OLAPSYS.CWM2_OLAP_PC_TRANSFORM
OLAPSYS.CWM2_OLAP_UTILITY
OLAPSYS.DBMS_ODM
OLAPSYS.OLAPDIMVIEW
OLAPSYS.OLAPFACTVIEW
SYS.DBMS_AW_EXP

Changes

The EXECUTE privilege of the UTL_FILE package was revoked from PUBLIC or any other user.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms