Re: Want to remove strange tables EVT_, SMP_

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 25 Dec 1998 16:48:26 GMT
Message-ID: <3683c1ac.24387577@news.arnes.si>

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]...
Hi Chris,

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.

>Chris
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Chris Hamilton -- toneczar_at_erols.com
>http://www.serve.com/cowpb/chamilton.html
>City of Washington Pipe Band

Regards,

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Dec 25 1998 - 10:48:26 CST