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 18.104.22.168 to 10.2.0.4 [Release 9.2 to 10.2]
Information in this document applies to any platform.
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:
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