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.