Removing a reporting schema

Purpose—Removes a single reporting schema when the study and reporting schemas are located in different database instances.
Script—deinstall_reporting_diffdb
Where to run—Folder where the reporting software is located, for example, \Oracle\InForm\bin\DBORA\Reporting.

Before you start, review the parameters in the configdiffdb.sql file to make sure that they contain the same values that you used to install the reporting schema. For more information, see Configuring the reporting variables for a study—Different database instances.

Open a Command Prompt window, and change to the folder where the reporting software is located, for example, \Oracle\InForm\bin\DBORA\Reporting.
Run the script using the command:
deinstall_reporting_diffdb

You are prompted for the following parameters:
- trial_schema_owner_password—Password for the study schema owner.
- dbauser_trial_password—Password for the study DBA user.
- dbauser_rep_password—Password for the reporting DBA user.
- streams_admin_user_rep_passwd—Password for the reporting streams admin user.
- streams_admin_user_trial_pwd—Password for the study streams admin user. Y/N. Optional.
Check for any errors by searching for the word Error in the deinstall_reporting_diffdb.log file. If any errors are found, correct the problem and run the script again.
Rerun the script until it does not find anything to remove and does not have any errors. The log shows all steps with the message No object… was found.
Run the configandcheckdiffdb.sql script to make sure everything has been removed. If the script completes successfully, the uninstall succeeded.

For more information, see deinstall_reporting_diffdb.