Removing an Oracle InForm study

• Purpose—Removes an Oracle InForm study and server.
• Where to perform—Server where the Oracle InForm core software is installed.

1. Stop the study, using the following command:

   pfadmin stop trial <studyname>

2. Remove the study, using the following command:

   pfadmin remove trial <studyname>

   or

   To remove the DSNs from ODBC data source administration at the same time, use the following command

   pfadmin remove trial <studyname> /DSN

3. If you did not remove the study DSN with the pfadmin utility, remove it through the Windows Data Sources (ODBC) utility:
   1. Select Start > Administrative Tools > Data Sources (ODBC).
   2. Select the System DSN tab.
   3. Select the study DSN, and click Remove.
   4. If the study has a randomization or CDD DSN, remove those, as well.
   5. Click OK.
4. After removing all studies from an Oracle InForm server, remove the server with the following command:

   pfadmin remove server <servername>

5. Back up the study database.
6. Remove the study user from the database. As the pfdbadmin user, issue the following SQL*Plus command:

   drop user <study_uid>  cascade;

   Caution:

   When you perform this step, all study data is removed. Make sure that the backup is complete before you drop the study user.