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');
阅读(692) | 评论(0) | 转发(0) |
