Oracle Management Database Considerations › Remove the Oracle MDB

Remove the Oracle MDB

The MDB should not be removed except in extreme cases.

Before removing an MDB, make sure the data stored in the database is no longer needed and that all products that were accessing the database have been uninstalled or configured to work with another MDB. Once an MDB is removed the data is lost.

Note: You should make a backup of the MDB before removing it, especially if more than one product has shared it.

To remove an Oracle MDB

1. Drop the mdb_data and mdb_index tablespaces.

   For example:

   DROP TABLESPACE MDB_DATA INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   DROP TABLESPACE MDB_INDEX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   

2. Drop the MDBADMIN user. For example:

   DROP USER MDBADMIN CASCADE
   

3. Drop the users that were created by the CA products that were using the MDB.
4. Drop the roles that were created by the MDB installation.