查看表的大小的脚本

select owner,table_name,
NUM_ROWS,
BLOCKS*8192/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
 where table_name =XXand owner=XX  order  by  "Size M"   desc;
 
 查看表中的blob字段
select distinct(table_name),owner,column_name,data_type
from dba_tab_columns
where table_name=XX and owner= XX and data_type in('CLOB','BLOB');