set verify off
DEFINE role_prefix = SIM201

spool C:\storet\orasto2\SIM\SIM201_inst\remove_SIM201_1.log

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

spool off
spool C:\storet\orasto2\SIM\SIM201_inst\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 C:\storet\orasto2\SIM\SIM201_inst\done_remove_SIM201.log
prompt done remove_SIM201.sql 
spool off
exit


