Cleaning up Oracle

These instructions assume that you are using an Oracle database and guide you through the following tasks:

To remove the database table and the ODBC definition:

  1. In a command window enter the following command:
    sqlplus <uid>/<password>
    DROP TABLE DATAWAREHOUSE;
  2. Remove the ODBC definition for the database, it has a data source name (DSN) of USERDB, which is achieved by undoing the ODBC setup step; see Enabling ODBC connections to the databases in the WebSphere Message Broker documentation.

Back to Cleaning up the database

Back to sample home