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 TRIGGER ADAP_ADD_EVENT;
    DROP TRIGGER ADAP_CUST_EVENT;
    DROP TRIGGER ADAP_INV_EVENT;
    DROP TRIGGER IBM_SEQ_TRIG;
    DROP SEQUENCE IBM_SEQUENCE;
    DROP TABLE IBM_EVENTS;
    DROP TABLE ADAPTER_ADDRESS;
    DROP TABLE ADAPTER_CUSTOMER;
    DROP TABLE ADAPTER_INVOICE;
  2. To remove the ODBC definition for the DBINPUT database (which has a data source name (DSN) of DBINPUT), undo 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