Finding and Recompiling Invalid Objects

The Find Invalid Objects functionality allows to search your database schema for invalid objects that require recompilation.

To identify invalid objects:

  1. In Database Explorer, right-click a required connection node or a database node and select Find Invalid Objects on the shortcut menu. Alternatively, go to the Database menu and select Find Invalid Objects. The Invalid Object Manager document will open.

Find Invalid Objects

The Invalid Object Manager document contains two sections. The Action required section lists invalid objects that require recompilation, and the No action required section lists valid objects.

In the Invalid Object Manager, you can:

  • compile the selected invalid objects using the Compile button
  • generate a compile script for the selected objects via the Script changes button
  • export the compilation results to a CSV file via the Export to CSV button
  • search for a specific object in the list using the Search field
  • rerun the search using the Reanalyze button
  • select the type of object to search for from the Type drop-down list
  • select databases and connections from the corresponding Database and Connection drop-down-lists
  • filter and sort data in the grids using the filter glyph and error icon on a column header

To recompile invalid objects:

  1. In the list of invalid objects, select the objects you wish to recompile. You can use the search field to find specific objects.

    Compile invalid objects

  2. Click the Compile button. The results of recompilation will be shown in the Result column. The errors, if any, will be described in the Error List section below.

    Recompilation result

Want to Find out More?



Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?