Uninstalling Oracle Business Intelligence Schemas from Oracle Database

1. Uninstall Oracle Business Intelligence Enterprise Edition.
2. Navigate to \RCU\BIN\ from the installation archive, and then double-click the rcu batch file to start the Oracle Repository Creation Utility (RCU).
3. On the Drop Repository screen, select Drop.
4. On the Database Connection Details screen, enter the database information, and then enter credentials for a SYSDBA account.
5. Click OK after the RCU wizard checks for prerequisites.
6. On the Select Components screen, make sure Metadata Services and Business Intelligence Platform are selected, as shown in the following screenshot:

   Figure 12-1 Oracle RCU Components Selection for Oracle Database

   
7. Click OK to confirm schema removal despite affecting current applications, and after the wizard checks for prerequisites.
8. Click Drop, verify the completion summary, and then click Close.
9. Using a database connectivity tool, verify that the orclrna_biplatform and orclrna_mds users no longer exist.
10. Navigate to root\Oracle\databaseInstanceName\mymicros\ and verify that ORCLRNA_BIPLATFORM.DBF, ORCLRNA_MDS.DBF, and ORCLRNA_IASTEMP.DBF have been deleted.
11. Use the following query to delete the System.SCHEMA_VERSION_REGISTRY$ entry:

    delete from System.SCHEMA_VERSION_REGISTRY$ where mrc_name='ORCLRNA';

12. Use the following query to delete obieeRcu records from the CORE_OPTIONS table:

    delete from CORE_OPTIONS where modulename='obieeRcu';