To check potential unique index key confliction between the staging database to the production database:
To run the Stage Check utility to ensure there is no unique index key conflict:
- Set the PATH environment variables.
- Configure the database.
- Change to the directory to which you want log files written.
- Type the following:
stagingcheck -scope _unique_index_ -sourcedb staging_database_name -destdb production_database_name -dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
. stagingcheck.sh -scope _unique_index_ -sourcedb staging_database_name -destdb production_database_name dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
- Examine the stagingcheck_yyyy.mm.dd_hh.mm.ss.zzz.log file.