Oracle查询语句

查看该表空间上所有对象

SELECT t.owner, t.segment_name,SUM(bytes)/1024/1024 From dba_segments t WHERE t.tablespace_name = 'TBS_DEFAULT' GROUP BY t.owner,t.segment_name ORDER BY SUM(bytes) desc;

查看LOB类型的段所属的表

select table_name,column_name,segment_name,index_name from user_lobs;

移动表至其他表空间，并重建索引

alter table TICKETBASE move tablespace TB_LOB; alter index SYS_C005391 rebuild online;