Re: Want to remove strange tables EVT_, SMP_

Any PC with Enterprise Manager has a utility for uninstalling the repository tables. This utility will let you drop various types of repositories created by Oracle products.

To drop all the repository tables, you can use

$ORACLE_HOME\bin\vobsh -l -o drop -p all

The utility also comes with a help screen:

$ORACLE_HOME\bin\vobsh -h

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

On Fri, 25 Dec 1998, Jurij Modic wrote:
>
> On Mon, 21 Dec 1998 15:43:34 GMT, toneczar_at_erols.com wrote:
>
> >Here's a SQL*Plus script I wrote to do it ...
> >
> >-- drop_oem.sql
> >-- Drop Oracle Enterprise Manager s%@*
> >
> >...[SNIP]...
>
> The only thing I woul add to your script are some huge prompts at the
> begining of the spooled file with the warning to the user to check
> each and every name of the tables listed in the drop-it file and with
> the instructions how to terminate its execution (Ctrl-C or similar)
> before it actualy drop any very important table that happen to have
> its name start with "EVT" or "SM" but does not actualy belong to OEM
> repository! IMHO the chances this to happen ar realy not so
> neglectable.
Received on Mon Dec 28 1998 - 02:00:05 CST