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