Remove Invalid OLAP Objects From SYS And OLAPSYS Schemas (Doc ID 565773.1)

Last updated on MAY 31, 2017

Applies to:

Oracle OLAP - Version 10.2.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 14-Sep-2011.


Symptoms

The following scenarios may result in invalid objects in OLAPSYS and SYS / PUBLIC:

Changes


If you are actively using the OLAP option you cannot simply reinstall the OLAP option on the 64 bit system since this would make the data managed by the OLAP option unuseable. Instead, the data needs to be migrated properly according to the information contained in

<Note 386990.1> DB CONVERSION: 32 bit -->64 Bit Broke OLAP OPTION

If you are not using the OLAP option, it is possible to remove the OLAP option manually and (if required) re-install it at a later time.

Refer to <Note 739032.1> How To Find Out If OLAP is Being Used And How To Remove OLAP
for details about the general process

This note explains how to remove the OLAP option and which invalid objects can be discarded.

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