drop user sysman cascade;
drop user sysman_types cascade;
drop user sysman_stb cascade;
drop user sysman_opss cascade;
drop user sysman_biplatform cascade;
drop user sysman_bip cascade;
drop user sysmanupgr_opss cascade;
drop user sysman_apm cascade;
drop user sysman_ro cascade;
drop user sysman_mds cascade;
drop user cloud_engine_user cascade;
drop user cloud_swlib_user cascade;
drop user mgmt_view cascade;
drop user eus_engine_user cascade;
drop role mgmt_user;


spool synonyms.lst
select 'drop synonym ' ||owner||'.'||synonym_name||';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIP', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO', 'SYSMAN_BIPLATFORM', 'SYSMANUPGR_OPSS', 'CLOUD_ENGINE_USER', 'CLOUD_SWLIB_USER', 'EUS_ENGINE_USER', 'SYSMAN_TYPES', 'SYSMAN_STB') ;
spool off
@synonyms.lst

drop tablespace MGMT_ECM_DEPOT_TS including contents and datafiles cascade constraints;
drop tablespace MGMT_TABLESPACE including contents and datafiles cascade constraints;
drop tablespace MGMT_AD4J_TS including contents and datafiles cascade constraints;


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';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='OracleBI and EPM';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Service Table';
commit;