删除表空间:
可以先将其offline
alter tablespace wangzhan offline;
将磁盘上的数据文件一同删除
drop tablespace wangzhan including contents and datafiles;
删除用户:
drop user xxx;
如果用户的schema中有objects ,需要加cascade参数,即drop user wangzhan cascade;
select username,sid,serial# from v$session
alter system kill session '17,129'; session和数字之间有空格
可以先将其offline
alter tablespace wangzhan offline;
将磁盘上的数据文件一同删除
drop tablespace wangzhan including contents and datafiles;
删除用户:
drop user xxx;
如果用户的schema中有objects ,需要加cascade参数,即drop user wangzhan cascade;
select username,sid,serial# from v$session
alter system kill session '17,129'; session和数字之间有空格