My Oracle Support Banner

How To Locate Scripts to Recreate Invalid Objects in the OWB 11g Repository (Doc ID 1437978.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Purpose

The 'Data Collection Script for Oracle Warehouse Builder 11.1 and 11.2' (Note 454044.1)  or  RDA output show invalid objects in the OWBSYS schema. 
If the objects are of type PACKAGE or PACKAGE BODY, the scripts to recreate the objects are located within the <ORACLE_HOME>/owb directory tree. They should always be recreated as a set, PACKAGE and PACKAGE BODY. 

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.