Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2Oracle Warehouse Builder (OWB) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. There’s only one script to execute. And it completes flawless and does not require any workarounds.

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

The Oracle Warehouse Builder actually does come automatically installed until Oracle Database 11.2. OWB is a data warehousing-centered data integration solution. It got replaced by ODI in later released.For more information on OWB click here. You may have to license certain parts of OWB.

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2According to Oracle Data Integrator and Oracle Warehouse Builder Statement of Direction (First Published January 2010, Updated May 2011):

No major enhancements are planned for Oracle Warehouse Builder beyond the OWB 11.2 release. OWB 11.2 continues to be available and supported by Oracle, and patches and bug fixes will continue to be offered at regular intervals. Oracle will continue to support OWB 11.2 for the full lifetime of Database 11g and the full lifetime of the next major database release (“Database 12”) in accordance with Oracle’s Lifetime Support Policies for Database releases. Future database releases beyond Database 12 would not be certified with OWB 11.2.

Before you start removing anything from your database please make sure you read my introductory blog post about how to Remove and Clean Up Components from Oracle 11.2 – 12.2 . You’ll find links to monitor proper component removal there as well as in the SQL Scripts Repository on this blog.

Oracle Database 11.2.0.4

The removal of OWB is very straight forward. The following MOS Note:1074425.1 –  How to remove OWB Objects in 11.1 and higher gives useful advice.

$ sqlplus / as sysdba
SQL> @?/owb/UnifiedRepos/clean_owbsys.sql

Done!

Oracle Database 12.1.0.2

In Oracle Database 12.1.0.2 OWB won’t be installed. When you upgrade to Oracle Database 12.1.0.2 we set OWB to OPTION OFF.

Oracle Database 12.2.0.1

In Oracle Database 12.2.0.1 OWB won’t be installed. Once you upgrade to Oracle Database 12.2.0.1 we set OWB to OPTION OFF.

Component Clean Up Series

Finally download a slide deck about the Component Clean Up on this blog:
https://mikedietrichde.com/slides/

 

5 thoughts on “Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

  1. Pingback: JAVAVM and XML Clean Up in Oracle Database 11.2-12.2

  2. Pingback: Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle 11.2-12.2

  3. Pingback: Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-12.2

  4. Pingback: Oracle Label Security (OLS) Clean Up in Oracle Database 11.2-12.2

  5. Pingback: Oracle Workspace Manager (OWM) Clean Up in Oracle Database 11.2-12.2

Leave a Reply

Your email address will not be published. Required fields are marked *