My Oracle Support Banner

OWB 11.2 Repository Installation Leaves OWBSYS Objects Invalid (Doc ID 1269205.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Purpose

When creating an Oracle Warehouse Builder (OWB) repository in OWB 11.2.0.2, there are invalid objects after the repository creation completes.

The following objects might be seen as invalid in the OWBSYS schema:

WB_RTI_WORKFLOW_UTIL
WB_RT_MAPAUDIT
OWB_UPROP
OWM_VIEW_UTILITIES
SNAPSHOT
MANAGEPRIVILEGEFROMDB

These are all package bodies.

How are the objects, which are invalid after the OWB 11.2 repository creation completes, validated?

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.