Obtaining information about the IBM Workload Scheduler databases installed on an Oracle instance

About this task

To determine which IBM Workload Scheduler 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
mdm85˂TWS_user>
Note:
  1. More than one instance of IBM Workload Scheduler 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;