Help Center> Data Warehouse Service (DWS)> Best Practices> Data Migration> Migrating Data From Oracle to GaussDB(DWS)> Migrating Full Table Data> Verification
Updated on 2024-04-25 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');