查看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;