Cleaning up Oracle
These instructions assume that you are using an Oracle database and
guide you through the following tasks:
- Remove the tables ADAPTER_ADDRESS, ADAPTER_CUSTOMER, ADAPTER_INVOICE, and IBM_EVENTS that are
used by the AdapterMigration sample.
- Remove the IBM_SEQUENCE, IBM_SEQ_TRIG, ADAP_ADD_EVENT, ADAP_CUST_EVENT, and ADAP_INV_EVENT
sequence and triggers used by the sample.
- Remove the ODBC definition for the database.
To remove the database table and the ODBC definition:
- 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;
- 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