oracle删除用户和表空间

–删除用户

drop user SOC2 cascade;

–删除表空间
drop tablespace JILIN_SOC_1_TBS including contents and datafiles cascade constraint;

若用户登录了 则无法删除 需要先把用户踢下线

select sid,serial# from v$session where username=‘SOC2‘;

alter system kill session‘532,4562‘