查询oracle数据中所有表的大小
select t.bytes,TO_CHAR((t.bytes)/(1024*1024),'999G999D999'),
t.* from sys.dba_segments t where t.owner='xxxxx'
order by t.bytes desc
select t.bytes,TO_CHAR((t.bytes)/(1024*1024),'999G999D999'),
t.* from sys.dba_segments t where t.owner='xxxxx'
order by t.bytes desc