dropOracleUser.sh
sqlplus -S "/as sysdba" << EOF
begin
for rec in (select serial#,sid from v\$session where username='JIANGSUYIDONG')
loop
execute immediate 'alter system kill session '||''||rec.sid||','||rec.serial#||'';
end loop;
exception
when others then
null;
end;
/
declare
i_dba_exist number;
begin
select count(0)
into i_dba_exist
from all_users
where username='JIANGSUYIDONG';
if i_dba_exist > 0 then
execute immediate 'drop user JIANGSUYIDONG cascade';
end if;
commit;
end;
/
quit
EOF