Regenerating the Data Validation Tool Report from the Latest Data Check (Optional)
Regenerating the Data Validation Tool Report from the Latest Data Check (Optional)
You can regenerate the data validation tool report CSV file from data created when you last ran a check. You must have performed a data check to regenerate a report. The report appears in the location where you unzipped the data validation tool files.
Start SQL*Plus and connect to the Operation 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 regenerate the data validation tool report:
Enter
n
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
y
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.