1、分别在源Oracle和目标达梦ecology_target下执行
declare num number;
begin
select count(1) into num from user_tables where table_name = ‘TMP_GET_ACTURAL_TABLE_COUNT’;
if num > 0 then
execute immediate ‘drop table TMP_GET_ACTURAL_TABLE_COUNT’;
end if;
end;
/
create table TMP_GET_ACTURAL_TABLE_COUNT(table_name varchar(100),table_cnt int);
/
CREATE OR REPLACE PROCEDURE “GET_ACTURAL_TABLE_COUNT”(isrun integer) AUTHID CURRENT_USER IS
sqlstr varchar2(4000);
begin
for cursor_sql in(
select ‘insert into TMP_GET_ACTURAL_TABLE_COUNT(table_name,table_cnt) select ‘’’||table_name||’’’ as table_name,count(1) as table_cnt from “’||table_name||’”’ as sqlstr1 from user_tables
where table_name not like ‘SREF_CON_%’
) loop
execute immediate (cursor_sql.sqlstr1);
commit;
end loop;
end;
/
truncate table TMP_GET_ACTURAL_TABLE_COUNT;
/
call GET_ACTURAL_TABLE_COUNT(1);
/
commit;
/
select *from TMP_GET_ACTURAL_TABLE_COUNT order by upper(table_name);
/
oracle

DM

2、将结果导入excel比对数据

F2列，点击图片红框内的小绿点，将列应用到其他行
=IFERROR(VLOOKUP(D2,$A:$B,2,FALSE),“表不存在”)

!
G2列
=IF(VALUE(E2)=VALUE(F2),0,1)

将G2列，结果为1的的筛选出来就是表行数不一致的表，如果结果集都是0证明数据行数一致；