Invalid Objects In OLAPSYS Schema and Unable To Recompile
(Doc ID 820783.1)
Last updated on NOVEMBER 03, 2019
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
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.
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
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 |
| References |