My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle OLAP - Version and later
Information in this document applies to any platform.


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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.