You run the following ssadbcopy command in the target system:

ssadbcopy -i /u01/vtruskov/dbcopy_archive/idvmeta_backup_transfer_2014_03_11_11_48_57.tar -r /u01/vtruskov/temp 

The following figure shows the command and the command output:

The utility extracts the files from the

idvmeta_backup_transfer_2014_03_11_11_48_57.tar

TAR archive file to the

/u01/vtruskov/temp

temporary file directory. The utility validates that all of the data files listed in the data file text file exist in the

/u01/sct_stage

data file directory. The utility creates the table structure in the target database. The utility registers the tables and data files in the Data Vault repository. The utility validates the metadata in the Data Vault repository for all objects in the table.

You want to verify that the target TICKET table includes the same amount of rows as the source TICKET table. The source TICKET table included 30,000 rows. You run a query to count the rows in the TICKET table in the target system. The TICKET table includes 30,000 rows. The tables include the same row count.

The following figures shows an example of the query and the query results: