My Oracle Support Banner

How To Change Olap Option Status from Loaded/Upgraded to Valid Before Upgrading Database (Doc ID 729494.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle OLAP - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Goal

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 status of the OLAP components in the dba_registry is LOADED OR UPGRADED. You want to set it to VALID before upgrading your database.

 

 

NOTE: THIS IS FOR UPGRADE PURPOSES ONLY.

For 9i OLAP is still functional in UPGRADED or LOADED Status.

For 10G/11g, OLAP is only functional with a VALID status.

 

 

To check the status of the components, use the following Sql command:

 

 

 

Solution

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
Goal
Solution

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