Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Jack C. Mahaffey
Super Advisor

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

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...
2 REPLIES
Steven Gillard_2
Honored Contributor
Solution

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

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
Honored Contributor

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

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!