WebSphere brand IBM WebSphere XML Document Management Server, Version 7.0

Dropping the Oracle databases

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
  1. Log on to the database server as the database administrator.
  2. 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.
  3. Remove the database tables by running the DROP TABLE command for each table that is defined.
  4. Drop the database using the standard Oracle procedure.
  5. Repeat steps 2 through 4 for each of the other databases.



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.