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

I may not want to shut of Enterprise Manager completly but I think it should create its tables under a different user. Do you know how to change this?
My test instance here does not have the tables under any user so I assume I do not need the to use EM tools such as schema manager.

Don

ahoo.com> wrote:

>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.
Received on Sat May 19 2001 - 08:01:39 CDT