What creates SMP_ prefixed tables... Seems like tables are created by OEM or some other Oracle tool

[Jack C. Mahaffey]

Any Oracle gurus out there???
I have some tables that showed up in one of my schema's that I cannot account for, they include:
SMP_UPDATESERVICES_CALLED_
SMP_SERVICE_ITEM_
SMP_SERVICE_GROUP_DEFN_
SMP_SERVICE_GROUP_ITEM_
SMP_AD_NODES_
SMP_AD_DISCOVERED_NODES_
SMP_AD_ADDRESSES_
SMP_AD_PARMS_
SMP_AUTO_DISCOVERY_ITEM_
SMP_AUTO_DISCOVERY_PARMS_
SMP_SERVICE_DATA_
EVT_PROFILE


Any ideas where these tables came from or if they can be deleted?

Thanks...

[Steven Gillard_2 · Accepted solution]

You're correct, these tables are part of the OEM repository. This post from the Oracle forums describes:

From: Oracle, Frank Montgomery 08-May-01 19:52
Subject: Re : Application schema owns SMP and EVT tables and indexes


In 1.x versions of OEM, when someone logged into the oem
console for the first time, it displays a message that
repository tables will be created in the user's schema.

If someone logged into the oem console as the production
schema username and answered in the affirmative that these
tables could be created, then the tables you mentioned
would automatically be created. This can be especially
troublesome if someone logged in as sys or system. For
this reason, in the later 2.x versions, this is not the
way a repository is created.

If the production schema user is NOT the username, used to
log into the 1.x ( probably 1.6 ) OEM console, then these
tables can be dropped, as they are not being utilzed by OEM.


Regards,
Steve

[Andreas D. Skjervold]

Hi

You're right, these are part of OEM repository.

Just delete!

(unless you are using OEM... but then you should have created an independent user to own these tables.).

These tables are a reoccuring problem as the 1.6 version of OEM creates these automatically if you start OEM without an repository being present (you just get one prompt to accept the creation...)

From OEM version 2, the repository have to be created with an repository tool.

Andreas