Cleaning up Oracle

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

• Remove the tables called DBINPUT_CUSTOMER and DBINPUT_EVENTS that are used by the DatabaseInput Node sample.
• Remove the DBINPUT_SEQUENCE, DBIN_SEQ_TRIG and DBIN_CUST_EVENT sequence and triggers used by the sample.
• Remove the ODBC definition for the database.

To remove the database table and the ODBC definition:

1. In a command window enter the following command:

   sqlplus <uid>/<password>
   DROP TRIGGER DBIN_CUST_EVENT;
   DROP TRIGGER DBIN_SEQ_TRIG;
   DROP SEQUENCE DBINPUT_SEQUENCE;
   DROP TABLE DBINPUT_EVENTS;
   DROP TABLE DBINPUT_CUSTOMER;

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 IBM Integration Bus documentation.

Back to Cleaning up the database

Back to sample home