Obtaining information about the HCL Workload Automation databases installed on an Oracle instance

About this task

To determine which HCL Workload Automation databases are installed on an Oracle instance, do the following:
su - oracle (UNIX only)
 sqlplus system/system_password@service_name
SQL> select * from all_tws_schemas;
The output should look like the following:
SCHEMA_NAME
------------------------------
MDL
mdm85TWS_user
Note:
  1. More than one instance of HCL Workload Automation can be shared in one instance of Oracle, using different schemas.
  2. In Oracle, the concept of "schema" and "user" are the same, so dropping an Oracle schema means dropping an Oracle user, which you do as follows:
    SQL> drop user MDL cascade;