Skip to content

What's the best way to get a list of any invalid database objects (including custom ones) in an IFS environment, rather than writing a custom query against the Oracle data dictionary?

Answer

Use the Application Monitoring Console — it has a dedicated view for exactly this, listing invalid objects (including custom ones) without needing to write or maintain a custom query against USER_OBJECTS/DBA_OBJECTS yourself.

← Browse Developer Studio, deployment, and upgrades questions