--oracle如何查看表的数据量
--1、系统表查询,可能不准确,需要做分析表的动作
--num_rows
select * from user_tables;
--2、直接使用统计函数进行统计
create or replace function count_rows(table_name in varchar2,
owner in varchar2 default null)
return number authid current_user IS
num_rows number;
stmt varchar2(2000);
begin
if owner is null then
stmt := 'select count(*) from "' || table_name || '"';
else
stmt := 'select count(*) from "' || owner || '"."' || table_name || '"';
end if;
execute immediate stmt
into num_rows;
return num_rows;
end;
select table_name, count_rows(table_name) nrows from user_tables order by nrows desc
--3、方式2有时候会出现需要等待很久的情况,下面有匿名块来执行
create table chl_record as
select row_number() over (