Tuesday, April 10, 2012

OEM12c Patchset install: Updated cleanup script

I have updated my script to force a clean-up of de repository of OEM12c with the latest patch set. There were some new roles and synonyms introduced. The old script of OEM12c is here, new one is here, logon as sys user with sysdba priveliges:

delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;

drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user BIP cascade;
drop user SYSMAN_APM cascade;
drop role MGMT_USER;
drop role MGMT_ECM_VIEW;

drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;
drop public synonym SMP_EMD_TARGET_OBJ;
drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;
drop public synonym SMP_EMD_STRING_ARRAY;
drop public synonym SMP_EMD_NVPAIR_ARRAY;
drop public synonym SMP_EMD_NVPAIR;
drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;
drop public synonym SMP_EMD_INTEGER_ARRAY;
drop public synonym SMP_EMD_DELETE_REC_ARRAY;
drop public synonym SMP_EMD_AVAIL_OBJ;
drop public synonym SETEMVIEWUSERCONTEXT;
drop public synonym MGMT_VIEW_UTIL;
drop public synonym MGMT_USER;
drop public synonym MGMT_TYPE_PROPERTIES;
drop public synonym MGMT_TARGET_PROPERTIES;
drop public synonym MGMT_TARGET_MEMBERSHIPS;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym MGMT_TARGETS;
drop public synonym MGMT_TARGET;
drop public synonym MGMT_STRING_METRIC_HISTORY;
drop public synonym MGMT_SEVERITY_OBJ;
drop public synonym MGMT_SEVERITY_ARRAY;
drop public synonym MGMT_SEVERITY;
drop public synonym MGMT_PREFERENCES;
drop public synonym MGMT_PAF_PROCS_LATEST;
drop public synonym MGMT_PAF_JOBS;
drop public synonym MGMT_PAF$STATES;
drop public synonym MGMT_PAF$PROCEDURES;
drop public synonym MGMT_PAF$INSTANCES;
drop public synonym MGMT_PAF$APPLICATIONS;
drop public synonym MGMT_NAME_VALUES;
drop public synonym MGMT_NAME_VALUE;
drop public synonym MGMT_METRIC_THRESHOLDS;
drop public synonym MGMT_METRIC_ERRORS;
drop public synonym MGMT_METRIC_COLLECTIONS;
drop public synonym MGMT_METRICS_RAW;
drop public synonym MGMT_METRICS_COMPOSITE_KEYS;
drop public synonym MGMT_METRICS_1HOUR;
drop public synonym MGMT_METRICS_1DAY;
drop public synonym MGMT_METRICS;
drop public synonym MGMT_MESSAGES;
drop public synonym MGMT_LONG_TEXT;
drop public synonym MGMT_LOG;
drop public synonym MGMT_JOB_TARGET;
drop public synonym MGMT_JOB_SCHEDULE;
drop public synonym MGMT_JOB_PARAMETER;
drop public synonym MGMT_JOB_OUTPUT;
drop public synonym MGMT_JOB_EXEC_SUMMARY;
drop public synonym MGMT_JOB_EXECUTION;
drop public synonym MGMT_JOB_EXECPLAN;
drop public synonym MGMT_JOBS;
drop public synonym MGMT_JOB;
drop public synonym MGMT_IP_TGT_GUID_ARRAY;
drop public synonym MGMT_GUID_OBJ;
drop public synonym MGMT_GUID_ARRAY;
drop public synonym MGMT_GLOBAL;
drop public synonym MGMT_DELTA_VALUES;
drop public synonym MGMT_DELTA_VALUE;
drop public synonym MGMT_DELTA_ID_VALUES;
drop public synonym MGMT_DELTA_IDS;
drop public synonym MGMT_DELTA_ENTRY_VALUES;
drop public synonym MGMT_DELTA_ENTRY;
drop public synonym MGMT_DELTA;
drop public synonym MGMT_CURRENT_SEVERITY;
drop public synonym MGMT_CURRENT_METRIC_ERRORS;
drop public synonym MGMT_CURRENT_METRICS;
drop public synonym MGMT_CURRENT_AVAILABILITY;
drop public synonym MGMT_CREDENTIAL;
drop public synonym MGMT_COLLECTION_PROPERTIES;
drop public synonym MGMT_AVAILABILITY;
drop public synonym MGMT_AS_ECM_UTIL;
drop public synonym MGMT_ADMIN;
drop public synonym MGMT$WEBSPHERE_MODULES;
drop public synonym MGMT$WEBSPHERE_JDBCDATASOURCE;
drop public synonym MGMT$WEBSPHERE_APPLICATION;
drop public synonym MGMT$WEBLOGIC_SERVER;
drop public synonym MGMT$WEBLOGIC_MODULES;
drop public synonym MGMT$WEBLOGIC_JDBCDATASOURCE;
drop public synonym MGMT$WEBLOGIC_APPLICATION;
drop public synonym MGMT$WEBCACHE_TO_OHS_ROUTING;
drop public synonym MGMT$WEBCACHE_SITEMAPPINGS;
drop public synonym MGMT$WEBCACHE_SITEALIASES;
drop public synonym MGMT$WEBCACHE_PERFRELATED;
drop public synonym MGMT$WEBCACHE_ORIGIN_SERVERS;
drop public synonym MGMT$WEBCACHE_ORIGINSERVERS;
drop public synonym MGMT$WEBCACHE_OPERATIONPORTS;
drop public synonym MGMT$WEBCACHE_LISTENPORTS;
drop public synonym MGMT$WEBCACHE_CONFIGFILES;
drop public synonym MGMT$WEBCACHE_CLUSTERMEMBERS;
drop public synonym MGMT$WEBCACHE_CLUSTERINFO;
drop public synonym MGMT$TXN_PERF_RAW;
drop public synonym MGMT$TXN_PERF_HOUR;
drop public synonym MGMT$TXN_PERF_DAY;
drop public synonym MGMT$TEMPLATE_POLICY_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRIC_SETTINGS;
drop public synonym MGMT$TEMPLATE_METRICCOLLECTION;
drop public synonym MGMT$TEMPLATES;
drop public synonym MGMT$TARGET_TYPE_PROPERTIES;
drop public synonym MGMT$TARGET_TYPE_DEF;
drop public synonym MGMT$TARGET_TYPE;
drop public synonym MGMT$TARGET_PROPERTIES;
drop public synonym MGMT$TARGET_POLICY_SETTINGS;
drop public synonym MGMT$TARGET_POLICY_EVAL_SUMM;
drop public synonym MGMT$TARGET_POLICIES;
drop public synonym MGMT$TARGET_NOTIF_METR_NOTCOV;
drop public synonym MGMT$TARGET_NOTIFICATION_RULES;
drop public synonym MGMT$TARGET_METRIC_SETTINGS;
drop public synonym MGMT$TARGET_METRIC_COLLECTIONS;
drop public synonym MGMT$TARGET_MEMBERS;
drop public synonym MGMT$TARGET_FLAT_MEMBERS;
drop public synonym MGMT$TARGET_COMPOSITE;
drop public synonym MGMT$TARGET_COMPONENTS;
drop public synonym MGMT$TARGET_ASSOCIATIONS;
drop public synonym MGMT$TARGET;
drop public synonym MGMT$STORAGE_REPORT_VOLUME;
drop public synonym MGMT$STORAGE_REPORT_PATHS;
drop public synonym MGMT$STORAGE_REPORT_NFS;
drop public synonym MGMT$STORAGE_REPORT_LOCALFS;
drop public synonym MGMT$STORAGE_REPORT_KEYS;
drop public synonym MGMT$STORAGE_REPORT_ISSUES;
drop public synonym MGMT$STORAGE_REPORT_DISK;
drop public synonym MGMT$STORAGE_REPORT_DATA;
drop public synonym MGMT$STEP_METRICS_RAW;
drop public synonym MGMT$STEP_METRICS_HOURLY;
drop public synonym MGMT$STEP_METRICS_DAILY;
drop public synonym MGMT$STEP_GROUPS;
drop public synonym MGMT$STEPS;
drop public synonym MGMT$SOFTWARE_PATCHSETS;
drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;
drop public synonym MGMT$SOFTWARE_OTHERS;
drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES;
drop public synonym MGMT$SOFTWARE_HOME_PROPERTIES;
drop public synonym MGMT$SOFTWARE_HOMES;
drop public synonym MGMT$SOFTWARE_DEPENDENCIES;
drop public synonym MGMT$SOFTWARE_COMP_PATCHSET;
drop public synonym MGMT$SOFTWARE_COMPONENT_PSU;
drop public synonym MGMT$SOFTWARE_COMPONENT_PATCH;
drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;
drop public synonym MGMT$SOFTWARE_COMPONENTS;
drop public synonym MGMT$RAC_TOPOLOGY;
drop public synonym MGMT$RACDB_INTERCONNECTS;
drop public synonym MGMT$PR_HOME_INFO;
drop public synonym MGMT$PR_HOMES_AFFECTED_COUNT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH_TGT;
drop public synonym MGMT$PR_APPL_PATCHES_TO_OH;
drop public synonym MGMT$POLICY_VIOL_NOTIF_LOG;
drop public synonym MGMT$POLICY_VIOL_ANNOTATIONS;
drop public synonym MGMT$POLICY_VIOLATION_HISTORY;
drop public synonym MGMT$POLICY_VIOLATION_CURRENT;
drop public synonym MGMT$POLICY_VIOLATION_CTXT;
drop public synonym MGMT$POLICY_VIOLATION_CONTEXT;
drop public synonym MGMT$POLICY_PARAMETERS;
drop public synonym MGMT$POLICIES;
drop public synonym MGMT$PA_RECOM_METRIC_SOURCE;
drop public synonym MGMT$PA_AFFTED_TARGETS;
drop public synonym MGMT$PA_AFFTED_HOST_OH;
drop public synonym MGMT$PA_AFFTED_HOST_GUID_OH;
drop public synonym MGMT$PATCH_ADVISORIES;
drop public synonym MGMT$OVM_VS_VSP_ASSOC;
drop public synonym MGMT$OVM_VS_PERF_SUMMARY;
drop public synonym MGMT$OVM_OS_HW_SUMMARY;
drop public synonym MGMT$OVM_HW_NIC;
drop public synonym MGMT$OVM_GVM_SUMMARY;
drop public synonym MGMT$OS_SUMMARY;
drop public synonym MGMT$OS_PROPERTIES;
drop public synonym MGMT$OS_PATCHES;
drop public synonym MGMT$OS_KERNEL_PARAMS;
drop public synonym MGMT$OS_HW_SUMMARY;
drop public synonym MGMT$OS_FS_MOUNT;
drop public synonym MGMT$OS_COMPONENTS;
drop public synonym MGMT$ORACLE_SW_GRP_TARGETS;
drop public synonym MGMT$ORACLE_SW_GRP_INSTALL;
drop public synonym MGMT$ORACLE_SW_ENT_TARGETS;
drop public synonym MGMT$ORACLE_SW_ENT_INSTALL;
drop public synonym MGMT$OHS_VIRTUALHOSTS;
drop public synonym MGMT$OHS_PERFRELATED;
drop public synonym MGMT$OHS_LISTENADDRESSES;
drop public synonym MGMT$OHS_GENERAL;
drop public synonym MGMT$OHS_CONFIGFILES;
drop public synonym MGMT$OHS_CIPHERSUITES;
drop public synonym MGMT$OC4J_WEBMODULEURLS;
drop public synonym MGMT$OC4J_WEBMODULESETTINGS;
drop public synonym MGMT$OC4J_RESOURCECONFIG;
drop public synonym MGMT$OC4J_PORTRANGES;
drop public synonym MGMT$OC4J_NATIVEDATASOURCES;
drop public synonym MGMT$OC4J_MODULES;
drop public synonym MGMT$OC4J_MANAGEDDATASOURCES;
drop public synonym MGMT$OC4J_J2EE_MODULES;
drop public synonym MGMT$OC4J_GLOBALWEBSETTINGS;
drop public synonym MGMT$OC4J_DEPLOYED_APPS;
drop public synonym MGMT$OC4J_DEPLOYEDAPPS;
drop public synonym MGMT$OC4J_DATASOURCES;
drop public synonym MGMT$OC4J_CONNECTIONPOOLS;
drop public synonym MGMT$OC4J_CONFIGFILES;
drop public synonym MGMT$OC4J_APPLICATIONINFO;
drop public synonym MGMT$OC4J_ALL_DATA_SOURCES;
drop public synonym MGMT$MS_LATEST_APPLIED;
drop public synonym MGMT$MS_APPLY_HISTORY;
drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS;
drop public synonym MGMT$MISSING_TARGETS;
drop public synonym MGMT$METRIC_HOURLY;
drop public synonym MGMT$METRIC_ERROR_HISTORY;
drop public synonym MGMT$METRIC_ERROR_CURRENT;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_STR;
drop public synonym MGMT$METRIC_DETAILS_SINGLE_NUM;
drop public synonym MGMT$METRIC_DETAILS_MULTI_STR;
drop public synonym MGMT$METRIC_DETAILS_MULTI_NUM;
drop public synonym MGMT$METRIC_DETAILS;
drop public synonym MGMT$METRIC_DAILY;
drop public synonym MGMT$METRIC_CURRENT;
drop public synonym MGMT$METRIC_COLLECTION;
drop public synonym MGMT$METRIC_CATEGORIES;
drop public synonym MGMT$MESSAGES;
drop public synonym MGMT$JOB_TARGETS;
drop public synonym MGMT$JOB_STEP_HISTORY;
drop public synonym MGMT$JOB_NOTIFICATION_LOG;
drop public synonym MGMT$JOB_EXECUTION_HISTORY;
drop public synonym MGMT$JOB_ANNOTATIONS;
drop public synonym MGMT$JOBS;
drop public synonym MGMT$JBOSS_RESCONF;
drop public synonym MGMT$JBOSS_PROTOCONF;
drop public synonym MGMT$JBOSS_POOLSCONF;
drop public synonym MGMT$JBOSS_DSCONF;
drop public synonym MGMT$JBOSS_APPSCONF;
drop public synonym MGMT$INTERFACE_STATS;
drop public synonym MGMT$IAS_SIMPLE_PORTS;
drop public synonym MGMT$IAS_PORT_RANGES;
drop public synonym MGMT$IAS_PORTS;
drop public synonym MGMT$IAS_OPMNCONFIG;
drop public synonym MGMT$IAS_MEMBERTARGETS;
drop public synonym MGMT$IAS_INSTALL_SETTINGS;
drop public synonym MGMT$IAS_GENERAL;
drop public synonym MGMT$IAS_DEPLOYEDAPPS;
drop public synonym MGMT$IAS_DCMCONFIG;
drop public synonym MGMT$IAS_CONSOLECONFIG;
drop public synonym MGMT$IAS_CONFIG_PROPS;
drop public synonym MGMT$IAS_CONFIGFILES;
drop public synonym MGMT$HW_NIC;
drop public synonym MGMT$HOSTPATCH_HOST_COMPL;
drop public synonym MGMT$HOSTPATCH_HOSTS;
drop public synonym MGMT$HOSTPATCH_GRP_COMPL_HIST;
drop public synonym MGMT$HOSTPATCH_GROUPS;
drop public synonym MGMT$HOMES_AFFECTED;
drop public synonym MGMT$HA_RMAN_CONFIG_ALL;
drop public synonym MGMT$HA_RMAN_CONFIG;
drop public synonym MGMT$HA_MTTR;
drop public synonym MGMT$HA_INIT_PARAMS_ALL;
drop public synonym MGMT$HA_INIT_PARAMS;
drop public synonym MGMT$HA_INFO_ALL;
drop public synonym MGMT$HA_INFO;
drop public synonym MGMT$HA_FILES_ALL;
drop public synonym MGMT$HA_FILES;
drop public synonym MGMT$HA_BACKUP;
drop public synonym MGMT$GRP_METRICS_RAW;
drop public synonym MGMT$GRP_METRICS_HOURLY;
drop public synonym MGMT$GRP_METRICS_DAILY;
drop public synonym MGMT$GROUP_MEMBERS;
drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS;
drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;
drop public synonym MGMT$ESA_WITH_GRANT_REPORT;
drop public synonym MGMT$ESA_WITH_ADMIN_REPORT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REP_NT;
drop public synonym MGMT$ESA_TRC_AUD_PERM_REPORT;
drop public synonym MGMT$ESA_TABSP_OWNERS_REPORT;
drop public synonym MGMT$ESA_SYS_PUB_PKG_REPORT;
drop public synonym MGMT$ESA_PUB_PRIV_REPORT;
drop public synonym MGMT$ESA_POWER_PRIV_REPORT;
drop public synonym MGMT$ESA_OH_PERMISSION_REPORT;
drop public synonym MGMT$ESA_OH_OWNERSHIP_REPORT;
drop public synonym MGMT$ESA_KEY_OBJECTS_REPORT;
drop public synonym MGMT$ESA_EXMPT_ACCESS_REPORT;
drop public synonym MGMT$ESA_DIRECT_PRIV_REPORT;
drop public synonym MGMT$ESA_DBA_ROLE_REPORT;
drop public synonym MGMT$ESA_DBA_GROUP_REPORT;
drop public synonym MGMT$ESA_CREATE_PRIV_REPORT;
drop public synonym MGMT$ESA_CONN_PRIV_REPORT;
drop public synonym MGMT$ESA_CATALOG_REPORT;
drop public synonym MGMT$ESA_BECOME_USER_REPORT;
drop public synonym MGMT$ESA_AUDIT_SYSTEM_REPORT;
drop public synonym MGMT$ESA_ANY_PRIV_REPORT;
drop public synonym MGMT$ESA_ANY_DICT_REPORT;
drop public synonym MGMT$ESA_ALL_PRIVS_REPORT;
drop public synonym MGMT$EM_HOMES_PLATFORM;
drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;
drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY6;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY5;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY4;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY3;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY2;
drop public synonym MGMT$ECM_CONFIG_HISTORY_KEY1;
drop public synonym MGMT$ECM_CONFIG_HISTORY;
drop public synonym MGMT$E2E_RAW;
drop public synonym MGMT$E2E_HOURLY;
drop public synonym MGMT$E2E_1DAY;
drop public synonym MGMT$DELTA_VIEW_DETAILS;
drop public synonym MGMT$DELTA_VIEW;
drop public synonym MGMT$DELTA_VENDOR_SW;
drop public synonym MGMT$DELTA_PATCHSET_DETAILS;
drop public synonym MGMT$DELTA_PATCHSETS;
drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;
drop public synonym MGMT$DELTA_OS_COMP_DETAILS;
drop public synonym MGMT$DELTA_OS_COMPONENTS;
drop public synonym MGMT$DELTA_ORACLE_HOME;
drop public synonym MGMT$DELTA_ONEOFF_PATCHES;
drop public synonym MGMT$DELTA_INIT;
drop public synonym MGMT$DELTA_HOST_CONFIG;
drop public synonym MGMT$DELTA_HARDWARE;
drop public synonym MGMT$DELTA_FS_MOUNT;
drop public synonym MGMT$DELTA_COMPONENT_DETAILS;
drop public synonym MGMT$DELTA_COMPONENTS;
drop public synonym MGMT$DB_TABLESPACES_ALL;
drop public synonym MGMT$DB_TABLESPACES;
drop public synonym MGMT$DB_SGA_ALL;
drop public synonym MGMT$DB_SGA;
drop public synonym MGMT$DB_ROLLBACK_SEGS_ALL;
drop public synonym MGMT$DB_ROLLBACK_SEGS;
drop public synonym MGMT$DB_REDOLOGS_ALL;
drop public synonym MGMT$DB_REDOLOGS;
drop public synonym MGMT$DB_OPTIONS_ALL;
drop public synonym MGMT$DB_OPTIONS;
drop public synonym MGMT$DB_LICENSE_ALL;
drop public synonym MGMT$DB_LICENSE;
drop public synonym MGMT$DB_INIT_PARAMS_ALL;
drop public synonym MGMT$DB_INIT_PARAMS;
drop public synonym MGMT$DB_FEATUREUSAGE;
drop public synonym MGMT$DB_DBNINSTANCEINFO_ALL;
drop public synonym MGMT$DB_DBNINSTANCEINFO;
drop public synonym MGMT$DB_DATAFILES_ALL;
drop public synonym MGMT$DB_DATAFILES;
drop public synonym MGMT$DB_CONTROLFILES_ALL;
drop public synonym MGMT$DB_CONTROLFILES;
drop public synonym MGMT$CS_EVAL_SUMMARY_STANDARD;
drop public synonym MGMT$CS_EVAL_SUMMARY_RULE;
drop public synonym MGMT$CS_CONFIG_STANDARDS;
drop public synonym MGMT$CSM_WATCHLIST;
drop public synonym MGMT$CSM_URL_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_URL_DIST_DAILY;
drop public synonym MGMT$CSM_URL_DAILY;
drop public synonym MGMT$CSM_SUBNET_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_HOURLY;
drop public synonym MGMT$CSM_SUBNET_DIST_DAILY;
drop public synonym MGMT$CSM_SUBNET_DAILY;
drop public synonym MGMT$CSM_REGION_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_HOURLY;
drop public synonym MGMT$CSM_REGION_DIST_DAILY;
drop public synonym MGMT$CSM_REGION_DAILY;
drop public synonym MGMT$CSM_REGION;
drop public synonym MGMT$CSM_MT_URL_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_URL_DIST_DAILY;
drop public synonym MGMT$CSM_MT_URL_DAILY;
drop public synonym MGMT$CSM_MT_METRIC_DETAILS;
drop public synonym MGMT$CSM_MT_IP_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_IP_DIST_DAILY;
drop public synonym MGMT$CSM_MT_IP_DAILY;
drop public synonym MGMT$CSM_MT_DSR_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_HOURLY;
drop public synonym MGMT$CSM_MT_DSR_DIST_DAILY;
drop public synonym MGMT$CSM_MT_DSR_DAILY;
drop public synonym MGMT$CSM_METRIC_DETAILS;
drop public synonym MGMT$CSM_IP_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_HOURLY;
drop public synonym MGMT$CSM_IP_DIST_DAILY;
drop public synonym MGMT$CSM_IP_DAILY;
drop public synonym MGMT$CSM_DOMAIN_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_HOURLY;
drop public synonym MGMT$CSM_DOMAIN_DIST_DAILY;
drop public synonym MGMT$CSM_DOMAIN_DAILY;
drop public synonym MGMT$CSA_HOST_SW;
drop public synonym MGMT$CSA_HOST_RULES;
drop public synonym MGMT$CSA_HOST_OS_PROPERTIES;
drop public synonym MGMT$CSA_HOST_OS_FILESYSTEMS;
drop public synonym MGMT$CSA_HOST_OS_COMPONENTS;
drop public synonym MGMT$CSA_HOST_NICS;
drop public synonym MGMT$CSA_HOST_IOCARDS;
drop public synonym MGMT$CSA_HOST_CUSTOM;
drop public synonym MGMT$CSA_HOST_CPUS;
drop public synonym MGMT$CSA_HOST_COOKIES;
drop public synonym MGMT$CSA_FAILED;
drop public synonym MGMT$CSA_COLLECTIONS;
drop public synonym MGMT$CSA_CLIENT_RULE_VIOLS;
drop public synonym MGMT$CSA_CLIENTS;
drop public synonym MGMT$CPF_PATCH_INFO;
drop public synonym MGMT$CPF_PATCH_DATA;
drop public synonym MGMT$CPF_HOMES_INFO;
drop public synonym MGMT$CPF_ADVISORY_INFO;
drop public synonym MGMT$CONNECTOR_TYPE;
drop public synonym MGMT$CONNECTOR;
drop public synonym MGMT$CLUSTER_INTERCONNECTS;
drop public synonym MGMT$BLACKOUT_HISTORY;
drop public synonym MGMT$BLACKOUTS;
drop public synonym MGMT$AVAIL_ALERT_HISTORY;
drop public synonym MGMT$AVAILABILITY_HISTORY;
drop public synonym MGMT$AVAILABILITY_CURRENT;
drop public synonym MGMT$AUDIT_LOG;
drop public synonym MGMT$APPL_PATCH_AND_PATCHSET;
drop public synonym MGMT$APPLIED_PATCHSETS;
drop public synonym MGMT$APPLIED_PATCHES;
drop public synonym MGMT$ALERT_NOTIF_LOG;
drop public synonym MGMT$ALERT_HISTORY;
drop public synonym MGMT$ALERT_CURRENT;
drop public synonym MGMT$ALERT_ANNOTATIONS;
drop public synonym EMD_MNTR;
drop public synonym ECM_UTIL;
drop synonym DBSNMP.MGMT_EMREP_OOB_MONITORING;

drop public synonym MGMT$ADR_INFO;
drop public synonym MGMT$ARU_FAMILY_PRODUCT_MAP;
drop public synonym MGMT$ARU_LANGUAGES;
drop public synonym MGMT$ARU_PATCH_RECOM;
drop public synonym MGMT$ARU_PATCH_RECOMMENDATIONS;
drop public synonym MGMT$ARU_PLATFORMS;
drop public synonym MGMT$ARU_PRODUCTS;
drop public synonym MGMT$ARU_PRODUCT_RELEASE_MAP;
drop public synonym MGMT$ARU_RELEASES;
drop public synonym MGMT$ARU_TARGETS;
drop public synonym MGMT$CCC_ALL_OBSERVATIONS;
drop public synonym MGMT$CCC_ALL_OBS_BUNDLES;
drop public synonym MGMT$CCC_DIAG_ANALYTICS;
drop public synonym MGMT$CCC_DIAG_QUEUEBACKLOG;
drop public synonym MGMT$CCS_DATA;
drop public synonym MGMT$CCS_DATA_SOURCE;
drop public synonym MGMT$CCS_DATA_SOURCE_VISIBLE;
drop public synonym MGMT$CCS_DATA_VISIBLE;
drop public synonym MGMT$CM_CHANGE_PLANS;
drop public synonym MGMT$CM_CP_SYNCH_CONFLICTS;
drop public synonym MGMT$CM_C_P_CHNG_ITEMS;
drop public synonym MGMT$COMPLIANCE_STANDARD;
drop public synonym MGMT$COMPLIANCE_STANDARD_GROUP;
drop public synonym MGMT$COMPLIANCE_STANDARD_RULE;
drop public synonym MGMT$COMPOSITE_CS_EVAL_SUMMARY;
drop public synonym MGMT$CONFIG_VERSION;
drop public synonym MGMT$CS_ASM_DISKGRP_SETTINGS;
drop public synonym MGMT$CS_DBM_CELL_GROUPS;
drop public synonym MGMT$CS_DBM_GRIDDISK_MISCONF;
drop public synonym MGMT$CS_DB_CONTROL_FILE_COUNT;
drop public synonym MGMT$CS_DB_INIT_PARAMS;
drop public synonym MGMT$CS_DB_RBS_IN_SYSTEM;
drop public synonym MGMT$CS_DB_REC_SEG_SETTINGS;
drop public synonym MGMT$CS_DB_REC_TS_SETTINGS;
drop public synonym MGMT$CS_DB_REC_USER_SETTINGS;
drop public synonym MGMT$CS_DB_REDO_LOGS;
drop public synonym MGMT$CS_DB_REDO_LOG_COUNT;
drop public synonym MGMT$CS_DB_TABLESPACES;
drop public synonym MGMT$CS_DB_TBSP_SEGSPACE_MGMT;
drop public synonym MGMT$CS_EVAL_SUMMARY;
drop public synonym MGMT$CS_FEATURE_USAGE;
drop public synonym MGMT$CS_GROUP_EVAL_SUMMARY;
drop public synonym CM$COMPOSITE_WIRES_CONFIG;
drop public synonym CM$COREID_ACCESS_CONFIG_INFO;
drop public synonym CM$COREID_ACS_PROFILECONFIG_IN;
drop public synonym CM$COREID_ACS_SERVERCONFIG_INF;
drop public synonym CM$COREID_IDENTITY_CONFIG_INFO;
drop public synonym CM$EM$ECM_CSA_CUSTOM;
drop public synonym CM$EM$ECM_HW_CPU;
drop public synonym CM$EM$ECM_HW_IOCARD;
drop public synonym CM$EM$ECM_HW_NIC;
drop public synonym CM$EMAS_COH_CACHE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CLUSTER_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CMGR_CONFIG_ECM;
drop public synonym CM$EMAS_COH_CONN_CONFIG_ECM;
drop public synonym CM$EMAS_COH_GCAFTER_CONFIG_ECM;
drop public synonym CM$EMAS_COH_GCBEF_CONFIG_ECM;
drop public synonym CM$EMAS_COH_HTTP_SESSION_ECM;
drop public synonym CM$EMAS_COH_MEMORY_CONFIG_ECM;
drop public synonym CM$EMAS_COH_NODE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_OS_CONFIG_ECM;
drop public synonym CM$EMAS_COH_RUNTIME_CONFIG_ECM;
drop public synonym CM$EMAS_COH_SERVICE_CONFIG_ECM;
drop public synonym CM$EMAS_COH_WKA_CONFIG_ECM;
drop public synonym CM$EMAS_TM_CONFIG_ECM;
drop public synonym CM$EM_CCS_DATA_SOURCE;
drop public synonym CM$EM_CCS_PARSED_DATA;
drop public synonym CM$EM_CELL_HCA_CONFIG;
drop public synonym CM$EM_CELL_HCA_PORT_CONFIG;
drop public synonym CM$EM_DBM_COMPUTE_NODES;
drop public synonym CM$EM_ESM_FILESYS;
drop public synonym CM$EM_ESM_PORTS;
drop public synonym CM$EM_ESM_SERVICE;
drop public synonym CM$EM_ESM_STACK;
drop public synonym CM$EM_EXADATA_CELL;
drop public synonym CM$EM_EXADATA_CELLDISK;
drop public synonym CM$EM_EXADATA_FCACHE;
drop public synonym CM$EM_EXADATA_FCACHE_CDISK;
drop public synonym CM$EM_EXADATA_GD_CLIENTS;
drop public synonym CM$EM_EXADATA_GRIDDISK;
drop public synonym CM$EM_EXADATA_IORM;
drop public synonym CM$EM_EXADATA_IORM_CATPLAN;
drop public synonym CM$EM_EXADATA_IORM_DBPLAN;
drop public synonym CM$EM_EXADATA_LUN;
drop public synonym CM$EM_EXADATA_LUN_PDISKS;
drop public synonym CM$EM_EXADATA_PDISK_LUNS;
drop public synonym CM$EM_EXADATA_PHYS_DISK;
drop public synonym CM$EM_HOST_HCA_CONFIG;
drop public synonym CM$EM_HOST_HCA_PORT_CONFIG;
drop public synonym CM$EM_IB_NETWORK_CONNECTIONS;
drop public synonym CM$EM_IB_SWITCH_CONFIG_SUMMARY;
drop public synonym CM$EM_IB_SWITCH_PORT_CONFIG;
drop public synonym CM$EM_IB_SWITCH_VERSION;
drop public synonym CM$EM_ILOM_SYS_INFO;
drop public synonym CM$EM_TPROPS_ECM_VIEW;
drop public synonym CM$ESM_COLLECTION;
drop public synonym CM$ESS_DISPATCHER_CONFIG;
drop public synonym CM$ESS_PROCESSOR_CONFIG;
drop public synonym CM$MGMT_ASM_CLUSTER_ECM;
drop public synonym CM$MGMT_ASM_DG_ATTR_ECM;
drop public synonym CM$MGMT_ASM_DISKGROUP_ECM;
drop public synonym CM$MGMT_ASM_DISK_ECM;
drop public synonym CM$MGMT_ASM_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_ASM_INSTANCE_ECM;
drop public synonym CM$MGMT_BI_ANS_CONFIG;
drop public synonym CM$MGMT_BI_CC_CONFIG;
drop public synonym CM$MGMT_BI_DAC_CONFIG;
drop public synonym CM$MGMT_BI_DAC_ETL_CONFIG;
drop public synonym CM$MGMT_BI_PS_ALERTS_CONFIG;
drop public synonym CM$MGMT_BI_PS_CACHE_CONFIG;
drop public synonym CM$MGMT_BI_PS_CHARTS_CONFIG;
drop public synonym CM$MGMT_BI_PS_CLIENT_CONFIG;
drop public synonym CM$MGMT_BI_PS_CONFIG;
drop public synonym CM$MGMT_BI_PS_DISPLAY_CONFIG;
drop public synonym CM$MGMT_BI_PS_MARKETING_CONFIG;
drop public synonym CM$MGMT_BI_PS_OTHERS_CONFIG;
drop public synonym CM$MGMT_BI_PS_REP_CACHE_CONFIG;
drop public synonym CM$MGMT_BI_PS_STATE_POOL_CONFI;
drop public synonym CM$MGMT_BI_PS_THREADPOOL_CONFI;
drop public synonym CM$MGMT_BI_PS_XML_CACHEDEF_CON;
drop public synonym CM$MGMT_BI_SCH_IBOTS_CONFIG;
drop public synonym CM$MGMT_BI_SCH_MAIL_CONFIG;
drop public synonym CM$MGMT_BPELPROCESS_CONFIG;
drop public synonym CM$MGMT_BPEL_CLUSTER_CONFIG;
drop public synonym CM$MGMT_BPEL_CONFIG;
drop public synonym CM$MGMT_BPEL_CONFIGFILES;
drop public synonym CM$MGMT_BPEL_DOMAIN_CONFIG;
drop public synonym CM$MGMT_BPEL_DSTORE_CONFIG;
drop public synonym CM$MGMT_BPEL_GENERAL_CONFIG;
drop public synonym CM$MGMT_BPEL_PROCESS_CONFIGFIL;
drop public synonym CM$MGMT_BPMN_CONFIG;
drop public synonym CM$MGMT_CLUSTER_ACTV_SRVS_ECM;
drop public synonym CM$MGMT_CLUSTER_CONFIG;
drop public synonym CM$MGMT_CLUSTER_CSS_NODES_ECM;
drop public synonym CM$MGMT_CLUSTER_PSRVPOOLS_ECM;
drop public synonym CM$MGMT_CLUSTER_RESOURCES_ECM;
drop public synonym CM$MGMT_CLUSTER_SRVPOOLS_ECM;
drop public synonym CM$MGMT_COMPOSITE_CONFIG;
drop public synonym CM$MGMT_COMPOSITE_SENSOR_CONFI;
drop public synonym CM$MGMT_CONFIG_VERSION_ECM;
drop public synonym CM$MGMT_COREID_ACCESS_SYS_INFO;
drop public synonym CM$MGMT_COREID_IDENTITY_SYS_IN;
drop public synonym CM$MGMT_DB_ASM_DISK_ECM;
drop public synonym CM$MGMT_DB_AUTOTASK_CLIENT_ECM;
drop public synonym CM$MGMT_DB_COMPONENTS_ECM;
drop public synonym CM$MGMT_DB_CONTROLFILES_ECM;
drop public synonym CM$MGMT_DB_CPU_USAGE_ECM;
drop public synonym CM$MGMT_DB_DATAFILES_ECM;
drop public synonym CM$MGMT_DB_DBNINSTANCEINFO_ECM;
drop public synonym CM$MGMT_DB_HIGHWATERMARK_ECM;
drop public synonym CM$MGMT_DB_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_DB_INST_ONLY_INFO_ECM;
drop public synonym CM$MGMT_DB_INVOBJS_ECM;
drop public synonym CM$MGMT_DB_INVOBJ_CNT_ECM;
drop public synonym CM$MGMT_DB_LICENSE_ECM;
drop public synonym CM$MGMT_DB_LSNR_CONFIG_ECM;
drop public synonym CM$MGMT_DB_OPTIONS_ECM;
drop public synonym CM$MGMT_DB_RECSEGMENTSETTINGS_;
drop public synonym CM$MGMT_DB_RECTSSETTINGS_ECM;
drop public synonym CM$MGMT_DB_RECUSERSETTINGS_ECM;
drop public synonym CM$MGMT_DB_REDOLOGS_ECM;
drop public synonym CM$MGMT_DB_ROLLBACK_SEGS_ECM;
drop public synonym CM$MGMT_DB_SCHEDULER_JOBS_ECM;
drop public synonym CM$MGMT_DB_SERVICES_ECM;
drop public synonym CM$MGMT_DB_SGA_ECM;
drop public synonym CM$MGMT_DB_TABLESPACES_ECM;
drop public synonym CM$MGMT_DB_USERS_ECM;
drop public synonym CM$MGMT_DB_VOTING_DISK;
drop public synonym CM$MGMT_ECM_ADR_INFO;
drop public synonym CM$MGMT_ECM_CSA;
drop public synonym CM$MGMT_ECM_CSA_GENERAL_INFO;
drop public synonym CM$MGMT_ECM_CSA_RULES;
drop public synonym CM$MGMT_ECM_EMD_ALL_PROPERTIES;
drop public synonym CM$MGMT_ECM_EMD_CONFIG_PARAMS;
drop public synonym CM$MGMT_ECM_EMD_JAVA_PARAMS;
drop public synonym CM$MGMT_ECM_EMD_TARGETS;
drop public synonym CM$MGMT_LDAP_LDAPSERVERDBINFOC;
drop public synonym CM$MGMT_LDAP_OIDREPLTOPOLOGY;
drop public synonym CM$MGMT_LISTENER_PORTS_ECM;
drop public synonym CM$MGMT_LISTENER_SERVICES_ECM;
drop public synonym CM$MGMT_LL_HOME_INFO;
drop public synonym CM$MGMT_LL_INV_CLONE_PROPS;
drop public synonym CM$MGMT_LL_INV_COMPONENT;
drop public synonym CM$MGMT_LL_INV_COMP_INST_TYPE;
drop public synonym CM$MGMT_LL_INV_CRS_NODES;
drop public synonym CM$MGMT_LL_INV_DEPENDENCY_RULE;
drop public synonym CM$MGMT_LL_INV_DEP_HOMES;
drop public synonym CM$MGMT_LL_INV_PATCHED_FILE;
drop public synonym CM$MGMT_LL_INV_PATCHES;
drop public synonym CM$MGMT_LL_INV_PATCHSET;
drop public synonym CM$MGMT_LL_INV_PATCH_BUGFIX;
drop public synonym CM$MGMT_LL_INV_PATCH_COMP;
drop public synonym CM$MGMT_LL_INV_SUMMARY;
drop public synonym CM$MGMT_LL_INV_VERSIONED_PATCH;
drop public synonym CM$MGMT_MEDIATOR_CONFIG;
drop public synonym CM$MGMT_OC4J_ADAPTER_CONFIGFIL;
drop public synonym CM$MGMT_OC4J_ADAPTER_CONFIGPAR;
drop public synonym CM$MGMT_OC4J_APPLICATIONINFO;
drop public synonym CM$MGMT_OC4J_CONFIGFILES;
drop public synonym CM$MGMT_OC4J_CONNECTIONPOOLS;
drop public synonym CM$MGMT_OC4J_DATASOURCES;
drop public synonym CM$MGMT_OC4J_DEPLOYEDAPPS;
drop public synonym CM$MGMT_OC4J_GLOBALWEBSETTINGS;
drop public synonym CM$MGMT_OC4J_MANAGEDDATASOURCE;
drop public synonym CM$MGMT_OC4J_MODULES;
drop public synonym CM$MGMT_OC4J_NATIVEDATASOURCES;
drop public synonym CM$MGMT_OC4J_PORTRANGES;
drop public synonym CM$MGMT_OC4J_RESOURCECONFIG;
drop public synonym CM$MGMT_OC4J_WEBMODULESETTINGS;
drop public synonym CM$MGMT_OC4J_WEBMODULEURLS;
drop public synonym CM$MGMT_OHS_CIPHERSUITES;
drop public synonym CM$MGMT_OHS_CONFIGFILES;
drop public synonym CM$MGMT_OHS_GENERAL;
drop public synonym CM$MGMT_OHS_LISTENADDRESSES;
drop public synonym CM$MGMT_OHS_PERFRELATED;
drop public synonym CM$MGMT_OHS_ROUTINGGENERAL;
drop public synonym CM$MGMT_OHS_ROUTINGLOCATIONS;
drop public synonym CM$MGMT_OHS_VIRTUALHOSTS;
drop public synonym CM$MGMT_OID_GENERAL_CONFIG;
drop public synonym CM$MGMT_OID_LOG_CONFIG;
drop public synonym CM$MGMT_OID_PERFORMANCE_CONFIG;
drop public synonym CM$MGMT_OID_SASL_CONFIG;
drop public synonym CM$MGMT_OID_STATS_CONFIG;
drop public synonym CM$MGMT_OIF_IDPSAML1X_ASSERTPR;
drop public synonym CM$MGMT_OIF_SPSAML1X_ASSERTPRO;
drop public synonym CM$MGMT_ORACLE_BI_SCH_CONFIG;
drop public synonym CM$MGMT_ORACLE_FED_SYS_INFO;
drop public synonym CM$MGMT_ORACLE_HAS_CONFIG;
drop public synonym CM$MGMT_ORACLE_HAS_IC_ECM;
drop public synonym CM$MGMT_ORACLE_IDM_SYSTEM_INFO;
drop public synonym CM$MGMT_OSB_BIZ_RESOURCE_CONFI;
drop public synonym CM$MGMT_OSB_BIZ_TRANSPORT_CONF;
drop public synonym CM$MGMT_OSB_FE_DETAIL_CONFIG;
drop public synonym CM$MGMT_OSB_GLOBAL_CONFIG;
drop public synonym CM$MGMT_OSB_JMSQ_CONFIG;
drop public synonym CM$MGMT_OSB_PROXY_RESOURCE_CON;
drop public synonym CM$MGMT_OSB_REPORTING_DBDETAIL;
drop public synonym CM$MGMT_OSM_DISK_GROUP_ECM;
drop public synonym CM$MGMT_RACDB_CONFIG_ECM;
drop public synonym CM$MGMT_RACDB_SRVPOOLS_ECM;
drop public synonym CM$MGMT_RAC_SERVICES;
drop public synonym CM$MGMT_SOACOMPONENT_CONFIG;
drop public synonym CM$MGMT_SOAINFRA_CONFIG;
drop public synonym CM$MGMT_SOAREFERENCE_CONFIG;
drop public synonym CM$MGMT_SOASERVICE_CONFIG;
drop public synonym CM$MGMT_SOA_ENGINE_CONFIG;
drop public synonym CM$MGMT_SSO_SSOSERVER_DB_INFOC;
drop public synonym CM$MGMT_SSO_SSOSERVER_LDAP_INF;
drop public synonym CM$MGMT_STATSPACK_CONFIG_ECM;
drop public synonym CM$MGMT_STORAGE_REPORT_ALIAS;
drop public synonym CM$MGMT_STORAGE_REPORT_DATA;
drop public synonym CM$MGMT_STORAGE_REPORT_ISSUES;
drop public synonym CM$MGMT_STORAGE_REPORT_KEYS;
drop public synonym CM$MGMT_SYSTEM_CHANGES;
drop public synonym CM$MGMT_WEBCACHE_CLUSTERINFO;
drop public synonym CM$MGMT_WEBCACHE_CLUSTERMEMBER;
drop public synonym CM$MGMT_WEBCACHE_CONFIGFILES;
drop public synonym CM$MGMT_WEBCACHE_LISTENPORTS;
drop public synonym CM$MGMT_WEBCACHE_OPERATIONPORT;
drop public synonym CM$MGMT_WEBCACHE_ORIGINSERVERS;
drop public synonym CM$MGMT_WEBCACHE_PERFRELATED;
drop public synonym CM$MGMT_WEBCACHE_SITEALIASES;
drop public synonym CM$MGMT_WEBCACHE_SITEMAPPINGS;
drop public synonym CM$MGMT_WEBSPHERE_APPLICATION;
drop public synonym CM$MGMT_WEBSPHERE_EJBCOMPONENT;
drop public synonym CM$MGMT_WEBSPHERE_JDBCDATASOUR;
drop public synonym CM$MGMT_WEBSPHERE_JDBCPROVIDER;
drop public synonym CM$MGMT_WEBSPHERE_PORTCONFIG;
drop public synonym CM$MGMT_WEBSPHERE_RESOURCECONF;
drop public synonym CM$MGMT_WEBSPHERE_WEBAPPCOMPON;
drop public synonym CM$MGMT_WORKFLOW_CONFIG;
drop public synonym CM$MGMT_WORKFLOW_DAF_CONFIG;
drop public synonym CM$MGMT_ECM_HW;
drop public synonym CM$MGMT_ECM_HW_CPU;
drop public synonym CM$MGMT_ECM_HW_IOCARD;
drop public synonym CM$MGMT_ECM_HW_NIC;
drop public synonym CM$MGMT_ECM_HW_NIC_BONDS;
drop public synonym CM$MGMT_ECM_NON_OUI_BUGS_FIXED;
drop public synonym CM$MGMT_ECM_OMS_CONFIG_PARAMS;
drop public synonym CM$MGMT_ECM_OS;
drop public synonym CM$MGMT_ECM_OS_COMPONENT;
drop public synonym CM$MGMT_ECM_OS_FILESYSTEM;
drop public synonym CM$MGMT_ECM_OS_INIT_SERVICES;
drop public synonym CM$MGMT_ECM_OS_MODULES;
drop public synonym CM$MGMT_ECM_OS_PROPERTY;
drop public synonym CM$MGMT_ECM_OS_REGISTERED_SW;
drop public synonym CM$MGMT_ECM_OS_ULIMITS;
drop public synonym CM$MGMT_ECM_SERVICETAG_INSTANC;
drop public synonym CM$MGMT_ECM_SERVICETAG_REGISTR;
drop public synonym CM$MGMT_EMREP_DBA_TAB_PRIVS;
drop public synonym CM$MGMT_EMREP_DB_INFO;
drop public synonym CM$MGMT_EMREP_OMS_NAME;
drop public synonym CM$MGMT_EMREP_OMS_SECURE_ECM;
drop public synonym CM$MGMT_ESA_REPORT;
drop public synonym CM$MGMT_FEATURE_USAGE_ECM;
drop public synonym CM$MGMT_GEN_APACHE_CIPHERSUITE;
drop public synonym CM$MGMT_GEN_APACHE_GENERAL;
drop public synonym CM$MGMT_GEN_APACHE_LISTENADDRE;
drop public synonym CM$MGMT_GEN_APACHE_PERFRELATED;
drop public synonym CM$MGMT_GEN_APACHE_ROUTINGINFO;
drop public synonym CM$MGMT_GEN_APACHE_VIRTUALHOST;
drop public synonym CM$MGMT_HAS_MANAGED_ASM_ECM;
drop public synonym CM$MGMT_HAS_MANAGED_DB_ECM;
drop public synonym CM$MGMT_HAS_MANAGED_LSNR_ECM;
drop public synonym CM$MGMT_HA_CLS_INTR_CONN;
drop public synonym CM$MGMT_HA_FILES_ECM;
drop public synonym CM$MGMT_HA_INFO_ECM;
drop public synonym CM$MGMT_HA_INIT_PARAMS_ECM;
drop public synonym CM$MGMT_HA_RAC_INTR_CONN;
drop public synonym CM$MGMT_HA_RMAN_CONFIG_ECM;
drop public synonym CM$MGMT_IAS_CONFIGFILES;
drop public synonym CM$MGMT_IAS_CONFIG_PROPS;
drop public synonym CM$MGMT_IAS_CONSOLECONFIG;
drop public synonym CM$MGMT_IAS_DCMCONFIG;
drop public synonym CM$MGMT_IAS_DEPLOYEDAPPS;
drop public synonym CM$MGMT_IAS_DIP_CONFIG;
drop public synonym CM$MGMT_IAS_GENERAL;
drop public synonym CM$MGMT_IAS_MEMBERTARGETS;
drop public synonym CM$MGMT_IAS_OIF_DATASTORE_CONF;
drop public synonym CM$MGMT_IAS_OIF_IDPSAML20_ASSE;
drop public synonym CM$MGMT_IAS_OIF_IDPSAML20_PROT;
drop public synonym CM$MGMT_IAS_OIF_IDP_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_IDP_WSFED11PRO;
drop public synonym CM$MGMT_IAS_OIF_SERVER_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_SPSAML20_ASSER;
drop public synonym CM$MGMT_IAS_OIF_SPSAML20_PROTO;
drop public synonym CM$MGMT_IAS_OIF_SP_CONFIG;
drop public synonym CM$MGMT_IAS_OIF_SP_WSFED11PROP;
drop public synonym CM$MGMT_IAS_OPMNCONFIG;
drop public synonym CM$MGMT_IAS_OVD_LSNR_CONFIG;
drop public synonym CM$MGMT_IAS_OVD_SCHEMA_LOC_CON;
drop public synonym CM$MGMT_IAS_OVD_SEARCH_CONFIG;
drop public synonym CM$MGMT_IAS_OVD_SERVER_CONFIG;
drop public synonym CM$MGMT_JBOSS_APPSCONFIG;
drop public synonym CM$MGMT_JBOSS_DSCONFIG;
drop public synonym CM$MGMT_JBOSS_GENERALCONFIG;
drop public synonym CM$MGMT_JBOSS_POOLCONFIG;
drop public synonym CM$MGMT_JBOSS_PROTOCONFIG;
drop public synonym CM$MGMT_JBOSS_RESOURCECONFIG;
drop public synonym CM$MGMT_JVM_CONFIG_ECM;
drop public synonym MGMT$WEBLOGIC_APPLICATIONS;
drop public synonym MGMT$WEBLOGIC_CLUSTER;
drop public synonym MGMT$WEBLOGIC_DOMAIN;
drop public synonym MGMT$WEBLOGIC_EJBCOMPONENT;
drop public synonym MGMT$WEBLOGIC_JDBCMULTIDS;
drop public synonym MGMT$WEBLOGIC_JMSCONNFACTORY;
drop public synonym MGMT$WEBLOGIC_JMSQUEUE;
drop public synonym MGMT$WEBLOGIC_JMSTOPIC;
drop public synonym MGMT$WEBLOGIC_JOLTCONNPOOL;
drop public synonym MGMT$WEBLOGIC_MACHINE;
drop public synonym MGMT$WEBLOGIC_NETWORK_CHANNELS;
drop public synonym MGMT$WEBLOGIC_NODEMANAGER;
drop public synonym MGMT$WEBLOGIC_OPSSSYSPROP;
drop public synonym MGMT$WEBLOGIC_RACONFIG;
drop public synonym MGMT$WEBLOGIC_RAOUTBOUNDCONFIG;
drop public synonym MGMT$WEBLOGIC_RESOURCECONFIG;
drop public synonym MGMT$WEBLOGIC_STARTSHUTCLASSES;
drop public synonym MGMT$WEBLOGIC_VIRTUALHOST;
drop public synonym MGMT$WEBLOGIC_WEBAPPCOMPONENT;
drop public synonym MGMT$WEBLOGIC_WORKMANAGER;
drop public synonym MGMT$WEBLOGIC_WSCONFIG;
drop public synonym MGMT$WEBLOGIC_WSPORTCONFIG;
drop public synonym MGMT$CS_HA_INFO;
drop public synonym MGMT$CS_RULE_EVAL_SUMMARY;
drop public synonym MGMT$CS_TARGET_ASSOC;
drop public synonym MGMT$DB_ASSOC_DATA;
drop public synonym MGMT$DB_AUTOTASK_CLIENT;
drop public synonym MGMT$DB_CPU_USAGE;
drop public synonym MGMT$DB_FEATURE_USAGE;
drop public synonym MGMT$DB_HA_BACKUP_REPORT;
drop public synonym MGMT$DB_HA_CONFIG;
drop public synonym MGMT$DB_HIGHWATERMARK;
drop public synonym MGMT$DB_INST_ONLY_INFO;
drop public synonym MGMT$DB_INVOBJ_CNT;
drop public synonym MGMT$DB_SCHEDULER_JOBS;
drop public synonym MGMT$DB_SERVICES_ECM;
drop public synonym MGMT$DB_USERS;
drop public synonym MGMT$DIAGNOSTIC_CHECK_ERRORS;
drop public synonym MGMT$DIAGNOSTIC_CHECK_ROWS;
drop public synonym MGMT$ESM_COLLECTION_LATEST;
drop public synonym MGMT$ESM_FILE_SYSTEM_LATEST;
drop public synonym MGMT$ESM_PORTS_LATEST;
drop public synonym MGMT$ESM_SERVICE_LATEST;
drop public synonym MGMT$ESM_STACK_LATEST;
drop public synonym MGMT$HA_DG_TARGET_SUMMARY;
drop public synonym MGMT$HW_CPU_DETAILS;
drop public synonym MGMT$HW_IO_DEVICES;
drop public synonym MGMT$HW_NIC_BONDS;
drop public synonym MGMT$J2EEAPP_EJBCOMPONENT;
drop public synonym MGMT$J2EEAPP_JRFWS;
drop public synonym MGMT$J2EEAPP_JRFWSOPER;
drop public synonym MGMT$J2EEAPP_JRFWSPOLICY;
drop public synonym MGMT$J2EEAPP_JRFWSPORT;
drop public synonym MGMT$J2EEAPP_WEBAPPCOMPONENT;
drop public synonym MGMT$J2EEAPP_WSCONFIG;
drop public synonym MGMT$J2EEAPP_WSPORTCONFIG;
drop public synonym MGMT$J2EE_APPLICATION;
drop public synonym MGMT$OH_CLONE_PROPERTIES;
drop public synonym MGMT$OH_COMPONENT;
drop public synonym MGMT$OH_COMP_DEP_RULE;
drop public synonym MGMT$OH_COMP_INST_TYPE;
drop public synonym MGMT$OH_CRS_NODES;
drop public synonym MGMT$OH_DEP_HOMES;
drop public synonym MGMT$OH_FILE;
drop public synonym MGMT$OH_HOME_INFO;
drop public synonym MGMT$OH_INSTALLED_TARGETS;
drop public synonym MGMT$OH_INV_SUMMARY;
drop public synonym MGMT$OH_PATCH;
drop public synonym MGMT$OH_PATCHED_COMPONENT;
drop public synonym MGMT$OH_PATCHED_FILE;
drop public synonym MGMT$OH_PATCHSET;
drop public synonym MGMT$OH_PATCH_FIXED_BUG;
drop public synonym MGMT$OH_VERSIONED_PATCH;
drop public synonym MGMT$OSB_ADMIN_CLIENT_DB;
drop public synonym MGMT$OS_INIT_SERVICES;
drop public synonym MGMT$OS_LIMITS;
drop public synonym MGMT$OS_MODULES;
drop public synonym MGMT$OS_PATCH_SUMMARY;
drop public synonym MGMT$PA_FINAL_PATCH_LIST;
drop public synonym MGMT$PA_TARGET_MAPPING;
drop public synonym MGMT$RAC_MEMBERSHIPS;
drop public synonym MGMT$RECOM_METRIC_SOURCE;
drop public synonym MGMT$SERVICETAG_INSTANCES;
drop public synonym MGMT$SERVICETAG_REGISTRY;
drop public synonym MGMT$STATSPACK_CONFIG;
drop public synonym MGMT$SWLIB_UPG_REPORT;
drop public synonym MGMT$UNPATCHABLE_DB_TARGETS;
drop public synonym MGMT$VIEW_MT_TC_REPORT;

drop tablespace mgmt_tablespace including contents and datafiles cascade constraints;
drop tablespace mgmt_ecm_depot_ts including contents and datafiles cascade constraints;
drop tablespace mgmt_ad4j_ts including contents and datafiles cascade constraints;