EM24AI EMREP部分卸载操作

郑全

1. 删除用户
drop user sysman%;

2.删除表空间
drop tablespace sysman%

3.删除同义词
   select 'drop synonym ' ||  owner || '.' || synonym_name || ';' from dba_synonyms where ower like 'SYSMAN%';

4.删除注册项
   drop registry

   select comp_name from schema_version_registry order by 1;
   把里面的几个项删除即可：
   delete from schema_version_registry where comp_name='Oracle Platform Security Services';
   delete from schema_version_registry where comp_name='Service Table';
   delete from schema_version_registry where comp_name='Metadata Services';

  执行以上几项后，即可干净清除EMREP里面的东西

这个与135一样，具体可以参见: note 2107485.1