I’ve had an interesting discussion today. Somebody removed OLAP with chopt – and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you’ll have to make sure to remove the dictionary components as well.
A while back a blogged about chopt already:
And there are some helpful Support Notes out there:
- MOS Note: 948061.1
How to Check and Enable/Disable Oracle Binary Options
This note WILL NOT address product specific scripts that are required at the database
level for specific components to further complete the install/deinstall process. Please refer to the appropriate Oracle Component Guide or as a starting point
- Note 472937.1 Information On Installed Database Components and Schemas
This applies especially to OLAP. When you remove it with chopt make sure you have removed all OLAP components from the database beforehand (AMD, APS, XOQ). Check COMP_ID in DBA_REGISTRY. And extra attention is required for CDBs as removing components afterwards from the dictionary may be not straight forward.
chopt can now remove the following options from the database kernel: olap oaa (Advanced Analytics - this is a new chopt option in 12.2) partitioning rat
Further Links and Information
- Oracle Database 19c – chopt command
- MOS Note: 948061.1 – How to Check and Enable/Disable Oracle Binary Options (does not cover 19c as of June 2020)