Rerun the Data Validation Tool to Confirm Issues are Resolved
Rerun the Data Validation Tool to Confirm Issues are Resolved
When non-zero counts have been addressed, run the data validation tool report again. When you rerun the data validation tool to create another report, the report contains the previous results beside the recent results.
Start SQL*Plus and connect to the Operational Reference Store for which you want to generate data validation tool results.
In SQL*Plus, run the dvt_start.sql script.
The first of four options appears.
Select the appropriate option to get the initial data validation results:
Enter
y
for the first option,
Check data and generate DVT report (y/n) [n]
.
Enter
n
for the second option,
Fix data using generated DVT report(y/n) [n]
.
Enter
n
for the third option,
Regenerate DVT report (y/n) [n]
.
Enter
n
for the fourth option,
Drop temporary DVT tables in schema (y/n) [n]
.
Open the data validation tool report in a program that can open CSV files, such as Excel, to review the data issues identified for your schema.