1,先对表进行分析:
analyze table [table] compute statistics;
2,然后查询表分区记录数
select
t.partition_name,t.num_rows
from
all_tab_partitions t
where
table_name=
'table_name'
1,先对表进行分析:
analyze table [table] compute statistics;
2,然后查询表分区记录数
select
t.partition_name,t.num_rows
from
all_tab_partitions t
where
table_name=
'table_name'