drop user sde cascade;
drop tablespace sde;
KIll连接Session
alter system kill session '71,791';
drop tablespace sde;
查看当前连接Session:
SELECT * FROM V$SESSION WHERE USERNAME='SDE' and status='INACTIVE';KIll连接Session
alter system kill session '71,791';