My Oracle Support Banner

How to Recompile Invalid Database Objects (Doc ID 1272098.1)

Last updated on JUNE 28, 2024

Applies to:

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

Goal



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.

Solution

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
Goal
Solution
 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:
References


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