Database Administration (MOSC)
MOSC Banner

Possible OBJ$ Status Codes and Meaning

I ask this question after failing to find the answer in any documentation. . .

In version 19c, in the data dictionary table SYS.OBJ$, what are all of the possible numbers in the STATUS column and what do they mean?


I ask because when we executed utlrp.sql to recompile objects following an upgrade to 19c, the following message scrolled by:

OBJECTS WITH ERRORS

26

I've seen documentation says that the figure above is the result of this query: select count(*) from sys.obj$ where status in (4,5,6) 

However, a query of the DBA_OBJECTS view only lists 21 objects that have a status of 'INVALID'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center