Validation

This chapter checks the Object Count and Constraint by comparing them with the Object and Constraint counts in the Target DB.

Compare the number of Objects and Constraints in the Target DB with Object Count Check and Check Constraint Check in 'Checklist and Check Methods' described on the Source DB operations page.

If the number does not match, check the View as shown below.

Table - DBA_TABLES
View - DBA_VIEWS 
Synonym - DBA_SYNONYMS 
Sequence - DBA_SEQUENCES
Package - DBA_SOURCE(TYPE = 'PACKAGE')
Package Body - DBA_SOURCE(TYPE = 'PACKAGE BODY') 
Function - DBA_SOURCE(TYPE = 'FUNCTION') 
Procedure - DBA_SOURCE(TYPE = 'PROCEDURE') 
Index - DBA_INDEXES
Constraint - DBA_CONSTRAINTS 
Grant - DBA_TAB_PRIVS
Trigger - DBA_TRIGGERS

When querying objects and constraints of the Target DB, refer to ‘Check Object Count’ and ‘Check Constraint’.

Additionally, separate verification is required if data other than unsupported lists has been transferred.