Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EVT_, SM and SMP_ tables in a user schema

504209Sep 13 2006 — edited Sep 13 2006
I found some tables and indexes in a user schema that this user hasn't created. 15 tables have a prefix EVT_, about 35 start with SM and about 30 have the prefix SMP_ . It seems they are some type of tables created by Oracle. What are they for and can they be deleted?

Thanks in advance!
Best regards,
Tzonka

Please see the list of some of them:

TABLE TABLESPACE
----------------------------------------------------------------------------------------
EVT_CARRIER_CONFIGURATION USERS
EVT_DEST_PROFILE USERS
EVT_HISTORY USERS
EVT_INSTANCE USERS
EVT_MAIL_CONFIGURATION USERS
EVT_MONITOR_NODE USERS
EVT_NOTIFY_STATUS USERS
EVT_OPERATORS USERS
EVT_OPERATORS_ADDITIONAL USERS
EVT_OPERATORS_SYSTEMS USERS
EVT_OUTSTANDING USERS
EVT_PROFILE USERS
EVT_PROFILE_EVENTS USERS
EVT_REGISTRY USERS
EVT_REGISTRY_BACKLOG USERS
PLAN_TABLE USERS
SMACTUALPARAMETER_S USERS
SMAGENTJOB_S USERS
SMARCHIVE_S USERS
SMBREAKABLELINKS USERS
SMCLIQUE USERS
SMCONFIGURATION USERS
SMCONSOLESOSETTING_S USERS
SMDATABASE_S USERS
...

SMP_AD_ADDRESSES_ USERS
SMP_AD_DISCOVERED_NODES_ USERS
SMP_AD_NODES_ USERS
SMP_AD_PARMS_ USERS
SMP_AUTO_DISCOVERY_ITEM_ USERS
SMP_AUTO_DISCOVERY_PARMS_ USERS
SMP_BLOB_ USERS
SMP_BRM_ACTIVE_JOB_ USERS
SMP_BRM_CHANNEL_DEVICE_ USERS
SMP_BRM_DEFAULT_CHANNEL_ USERS
SMP_BRM_RC_CONNECT_STRING_ USERS
SMP_BRM_SAVED_JOB_ USERS
SMP_BRM_TEMP_SCRIPTS_ USERS
....

And some indexes:
TABLE INDEX TABLESPACE
-----------------------------------------------------------------------------------------------------------------------------------
EVT_CARRIER_CONFIGURATION SYS_C006660 USERS
EVT_MONITOR_NODE SYS_C006662 USERS
EVT_OPERATORS SYS_C006664 USERS
EVT_PROFILE SYS_C006668 USERS

... etc.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2006
Added on Sep 13 2006
2 comments
1,930 views