select owner,segment_name, segment_type from dba_segments where tablespace_name = 'EXAMPLE';
select distinct owner,segment_name, segment_type from dba_extents where tablespace_name='EXAMPLE';
查看哪些objects存储在EXAMPLE表空间，将其drop或者move，然后再drop tablespace
drop tablespace tablespace_name including contents; 命令删除表空间
posted on 2009-01-21 14:19
周锐 阅读(3681)
评论(0) 编辑 收藏 所属分类:
Oracle