How do I remove the Spotlight on Oracle Database user?
As long as you have not reconfigured an existing database user, you can drop cascade the user from within the Oracle database you have used Spotlight on Oracle against.
For those that have reconfigured an existing user, a drop script is attached called SoOdrop.sql. The drop script includes additional database objects if you have installed the Predictive Diagnostics which works with Spotlight on Oracle on Sun Solaris machines.
Please note that the attached script has not been QA'ed at all, so use it at your own risk.
