删除用户和表空间

 

删除用户 

drop user username cascade 

删除表空间

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

 

删除不成功，先删除session

select saddr,sid,serial#,paddr,username,status from v$session where username is not null

 

执行命令

alter system kill session  '532,4562'