Deleting User and Table spaces

Follow these steps to remove the user and table spaces that were created with the installation.

Warning: This removes all data related to TIBCO MDM and should be used very carefully.

Procedure

  1. Modify the $MQ_HOME/db/oracle/configure/dropuser.sql script to change the user name to the user you created. By default, this script drops user mdmuser.
  2. Modify the $MQ_HOME/db/oracle/configure/droptablepsace.sql script to change the names of the table spaces to what you have created.
  3. From the configure directory, run the script dropusertablespace.bat. This script removes the user and table spaces.
    Tip: In some cases, the data files may not get removed. Delete them manually.