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'.