list_invalid_objects
List Oracle objects with INVALID status to find broken code needing recompile. Filter by schema or object type; index and LOB partitions are excluded.
Instructions
List objects whose status is INVALID (broken code needing recompile). Excludes index/LOB partitions. Optional schema and type filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | No | Object type, e.g. 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TABLE', 'VIEW'. | |
| schema | No | Schema (owner) name. Omit to search all schemas. |