Kernel Options

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

… Continue reading...