Dba_dependencies

How to Identify and Fix Invalid Objects in an Oracle Database Purpose A list of invalid objects tells you more than it first seems to. Ten invalid objects in one application schema right after a release can point to one changed table. Hundreds of invalid objects across many schemas more often follow a patch or an …