Cleaning up Oracle
These instructions assume that you are using an Oracle database and guide you through the following tasks:
- Remove the tables called XMLFLIGHTTB and XMLPASSENGERTB that are used by the Airline Reservations sample
- Remove the ODBC definition for the database
To remove the database tables and the ODBC definition:
- In a command window enter the following command:
sqlplus <uid>/<password>
DROP TABLE XMLFLIGHTTB;
DROP TABLE XMLPASSENGERTB;
- Remove the ODBC definition for the database, it has a data source name (DSN) of RESERVDB,
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