Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Back Next

Run the Data Validation Tool to Generate the Initial Results

To generate the initial data validation results, run the dvt_start.sql script.

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

for the first option,

Check data and generate DVT report (y/n) [n]

Enter

for the second option,

Fix data using generated DVT report(y/n) [n]

Enter

for the third option,

Regenerate DVT report (y/n) [n]

Enter

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.