Oracle如何断开用户连接 http://aryanwang.iteye.com/blog/619471
搜出该用户的session的SID,SERIAL码,然后kill掉
select sid,serial# from v$session where username='user_name';
alter system kill session 'sid,serial';
alter system kill session '527,2832';
删除用户
drop user user_name cascade;
删除表空间
drop tablespace tab_name including contents and datafiles
当前表空间大小
select * from dba_data_files where tablespace_name=$TABLESPACE
已使用的表空间大小
select * from dba_segments where tablespace_name=$TABLESPACE_NAME;
未使用空间大小
select * from dba_free_space where tablespace_name=$TABLESPACE_NAME;
-------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------
Oracle 11g删除表空间语法描述: DROP TABLESPACE tablespace_name [ including contents [ and datafiles ] [ CASCADE CONSTRAINT ] ]; 无选项 -- 当表空间为空才能删除; including contents — 删除表空间及对象; including contents and datafiles — 删除表空间、对象及数据文件; includingcontents CASCADE CONSTRAINT — 删除关联; including contents and datafiles cascade constraint -- 含前两项。