Skip to main content

Search

Welcome to Tibero GTS!

How to Verify the Accuracy of Transferred Data Quantity

Document Type | Technical Information

Category | Migration

Document Number | TMITI011

 

Overview

This provides a script that can be used to verify the accuracy of the number of transferred data after migrating from another DBMS (Oracle) to Tibero.
 
 

Method

After running the script below on both the other DBMS (Oracle) and Tibero, you can identify tables with numerical differences when comparing the number of transferred records.
select 'select '''||table_name||''', count(*) from '||owner||'.'||table_name||' union all'
from dba_tables
where owner='SYS'
order by owner,table_name;
  • It can be more easily applied when using DBlink integration between Oracle and Tibero.
  • When there are many data records and tables overall, it is more effective to generate individual queries instead of using union, perform spool, and then execute the queries to obtain results.
 
 
 

Related to