My Oracle Support Banner

How to Recompile Invalid Database Objects (Doc ID 1272098.1)

Last updated on JUNE 29, 2022

Applies to:

Oracle Communications Network Charging and Control - Version 4.1.0 and later
Information in this document applies to any platform.


The goal of this KM is to recompile objects stated as invalid in an Oracle database.

Some of these objects are often recompiled before use, but some still stay invalid.


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
 1. Check for invalid objects in the database
 1.1 Connect on the SMS and connect to oracle
 1.2 Check for invalid objects
 2. Recompiling the invalid objects in the database
 2.1 Creating the commands to recompile the invalid objects
 2.2 Recompiling the invalid objects
 2.3 Final check
 3. Errors
 Further references:

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