This is the basic process that you should follow when using the manual drop scripts.
Optionally (only if Predictive Diagnostics objects are present), run drop_ppcm_objects.sql to drop the Predictive Diagnostics objects.
Run the scripts from a SQL*Plus session. (In the scripts, you will be prompted to provide the Spotlight on Oracle owner from which to remove objects.)
sqlplus <respository_owner>/<repository_password>@<connect_string> @<Spotlight_Home>\Plug-ins\Ppcm\OracleScripts\drop_ppcm_objects.sql
sqlplus <respository_owner>/<repository_password>@<connect_string> @<Spotlight_Home>\Plug-ins\SoO\OracleScripts\drop_soo_objects.sql
- repository_owner - A Spotlight user with installed Predictive Diagnostics objects and tables.
- repository_password - The password for the Spotlight user.
- connect_string - Target database entry in the local computer's tnsname.ora file.
- Spotlight_Home - The base directory for the Spotlight installation.
Oracle 10g and later: Deleted objects may be sent to the recyclebin if this has been enabled by the database; you may need to purge the recyclebin afterwards.