oracle删除表空间、删除已连接的用户

oracle删除表空间、删除已连接的用户
 
删除表空间：
 
drop tablespace ECPTABLESPACEIDX including contents and datafiles;
 
删除已连接的用户
 
alter user ecp account lock;
 
select username,sid,serial# from v$session where username like '%ECP%';
 
//alter system disconnect session '30,5427' immediate;
 
alter system kill session'28,21617';
 
drop user ecp cascade;
 

上一个：oracle多个结果集拼接字符串
下一个：oracle查看编码以及修改编码