1.登录plsql,打开命令窗口
2.查找表空间下用户
select owner, segment_name from dba_segments where tablespace_name = 'XXX'
3.删除表空间下用户
drop user xxx cascade;
4.删除表空间
drop tablespace xxx INCLUDING CONTENTS and datafiles;
1.登录plsql,打开命令窗口
2.查找表空间下用户
select owner, segment_name from dba_segments where tablespace_name = 'XXX'
3.删除表空间下用户
drop user xxx cascade;
4.删除表空间
drop tablespace xxx INCLUDING CONTENTS and datafiles;