删除Oracle用户的shell脚本

 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