Before removing any owb workspace owners or users verify that these are no longer required. The OWB workspace contains the source code for your warehouse project; it is strongly recommended that a backup of the repository is taken before deletion.
Deletion of the OWB schema's through the standard Oracle tools like SQLPLUS does not achieve the same result as the following steps. When removing an OWB workspace or target schema complete the following steps.
Follow these steps to drop the OWB Workspace Users using the Repository Assistant:
Step 1: Enter the Host Name, Port Number and Oracle Service Name, which can all be found in your tnsnames.ora file.
Step 2: Select Manage Warehouse Builder workspace users
Step 3: Enter the Workspace Owner's User Name, e.g. CuramBI and Password.
Step 4: Select the Workspace Name
Step 5: Unregister Warehouse Builder workspace users
Step 6: Select all users, e.g. CuramST, CuramDW, CuramDM, CuramDMO and CuramBIROLE
Review the Summary and click finish to unregister the Warehouse Builder workspace users.
Follow these steps to drop the OWB Workspace Owner using the Repository Assistant:
Step 1: Enter the Host Name, Port Number and Oracle Service Name, which can all be found in your tnsnames.ora file.
Step 2: Select Manage Warehouse Builder Workspace
Step 3: Select Drop an existing Warehouse Builder workspace
Step 4: Enter the Workspace Owner's User Name, e.g. CuramBI, and Password.
Step 5: Select the Workspace Name
Review the Summary and click finish to drop the OWB Workspace Owner.