Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What are the tables starting with EVT_ , SM, SMP_ . How can I get rid of them?

Re: What are the tables starting with EVT_ , SM, SMP_ . How can I get rid of them?

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 18 May 2001 22:04:24 -0500
Message-ID: <ulmnuavoq.fsf@primix.com>

First thing, why did you decide that you would post to three Oracle groups for this?

On Fri, 18 May 2001, empty_at_noone.com wrote:

> These tables have names that start with the following: EVT_ ,
> SM , SMP_
>
> What are these? I think some are related to Enterprise
> Manager.

Yes, I believe these are created by Enterprise Manager whenever it is used to access an instance. If they already exist, the OEM will use the existing tables.

> What can I do to get rid of them?

Drop them.

> What do I need to shut off to ensure that they do not come
> back.

I don't know. I guess disallow use of OEM on this instance. Hm..., not sure you want to do this.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Fri May 18 2001 - 22:04:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US