set verify off
DEFINE role_prefix = SIM201

spool <SIM201_SERVER>\remove_SIM201_1.log

prompt Dropping user SIM201 - Please Wait
drop user SIM201 cascade;

spool off
spool <SIM201_SERVER>\remove_SIM201_2.log

prompt Dropping roles 
drop role &&role_prefix._USER_ROLE;

prompt Dropping tablespaces
drop tablespace SIM201_data;
drop tablespace SIM201_index;

spool off


spool <SIM201_SERVER>\done_remove_SIM201.log
prompt done remove_SIM201.sql 
spool off
exit


