My Oracle Support Banner

How To Locate Scripts To Recreate Invalid Objects In The OWB 11g Repository (Doc ID 1437978.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 and later
Information in this document applies to any platform.

***Checked for relevance on 07-Feb-2018***

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!


In this Document
Purpose
Troubleshooting Steps
References

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