Help Center/ GaussDB(DWS)/ Best Practices/ Data Migration/ Migrating Data From Oracle to GaussDB(DWS)/ Migrating Full Table Data/ Verification
Updated on 2024-03-13 GMT+08:00
View PDF

Verification

  1. In the test database of GaussDB(DWS), run the following SQL statement to query the number of rows in the table apex2_dynamic_add_remain_test. If the number of rows is the same as that in the source table, the data is consistent. 

    1
    		 
    SELECT COUNT(*) FROM  db_user01.apex2_dynamic_add_remain_test;

  2. Run the following statement to check the data skewness:

    If the data skewness is within 10%, the data distribution is normal. The data migration is complete. 
    1
    		 
    SELECT TABLE_SKEWNESS('db_user01.apex2_dynamic_add_remain_test');