How To Change Olap Option Status from Loaded/Upgraded to Valid Before Upgrading Database
(Doc ID 729494.1)
Last updated on JUNE 14, 2024
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 |