Re: Want to remove strange tables EVT_, SMP_

From: <toneczar_at_erols.com>
Date: Mon, 21 Dec 1998 15:43:34 GMT
Message-ID: <75lqb5$8jt$1@nnrp1.dejanews.com>

Here's a SQL*Plus script I wrote to do it ...

• drop_oem.sql
• Drop Oracle Enterprise Manager s%@*

column object_name format a30;

set pause on;

select object_type "OEM Objects",

         count(*) "Count"
from     user_objects
where    object_name like 'EVT%'
or       object_name like 'SM%'

group by object_type
order by 1;

set pause off;

set pagesize 0;
set trimspool on;
set feedback off;

spool drop_oem.tmp;

select 'drop table ' || table_name || ';' from user_tables
where table_name like 'EVT%'
or table_name like 'SM%'
union
select 'drop view ' || view_name || ';'

from     user_views
where    view_name like 'EVT%'
or       view_name like 'SM%'

union
select 'drop sequence ' || sequence_name || ';' from user_sequences
where sequence_name like 'EVT%'
or sequence_name like 'SM%'
union
select 'drop synonym ' || synonym_name || ';' from user_synonyms
where synonym_name like 'EVT%'
or synonym_name like 'SM%'
order by 1;

spool off;

set feedback on;
set pagesize 14;

start drop_oem.tmp;

drop table smp_job_;

set pause on;

select object_type "OEM Objects",

         count(*) "Count"
from     user_objects
where    object_name like 'EVT%'
or       object_name like 'SM%'

group by object_type
order by 1;

Chris

---

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

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 21 1998 - 09:43:34 CST