Follow these instructions to drop the Oracle databases
that were used by IBM® XDMS.
About this task
The databases include one or more of the
following:
- Shared List database
- Shared Group database
- Shared Profile database
- Shared Policy database
- Shared Enablers database
- Presence Rules database
- JMS SIBus database
- Usage Record database
- Log on to the database server as the database administrator.
- Connect to the first database by running
the following command:
sqlplus $dbuser/$dbuserPW@$db_name
where:
- dbsser is the user ID for the authorized user.
- dbuserPW is the password for the authorized
user.
- db_name is the name of the usage records database,
for example XDMSUR.
- Remove the database tables by running
the DROP TABLE command for each table that is defined.
- Drop the database using the standard Oracle
procedure.
- Repeat steps 2 through 4 for each of
the other databases.