Dropping the 11.1.1.9.2 ODI Repository Schema

Use the BI Applications RCU to drop the existing 11.1.1.9.2 ODI Repository schema.

You can use either the BI Applications 11.1.1.9.2 RCU or the 11.1.1.10.1 RCU. You will be prompted with a list of schemas that have already been installed. You must select the schema where the ODI repository for 11.1.1.9.2 exists.

Note:

ONLY drop the <prefix>_BIA_ODIREPO. Do not drop any other schema.
To drop the 11.1.1.9.2 ODI repository schema:
  1. Launch the BI Applications RCU and select the Drop radio button.
  2. In the Database Connection Details screen, provide the connection details to the database which hosts the ODI Repository for BI Applications 11.1.1.9.2.
  3. From the Prefix All Schema Owners drop down, select the prefix for your BI Applications 11.1.1.9.2 schemas.
  4. Select only the Oracle Data Integration Master and Work Repository from the Select Components screen. Do NOT select any of the other schema components.
  5. Click Drop to drop the ODI repository schema for 11.1.1.9.2.