Online Documentation for SQL Manager for Oracle

Working with recompile service

Schema

Use the drop-down list to select the schema containing objects to search.

Object type

Use the drop-down list to select the object type to search.

With debug info

Adds the code for PL/SQL debugger.

To perform the search, click the Find invalid objects link on the Navigation bar.

To get dependencies of invalid objects click the Get invalid dependencies link on the Navigation bar.

The list below displays invalid objects of the specified type found within the selected schema as a grid with the following columns: Object name, Object ID, Hint. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Hint: Objects of different type are marked in the list by different icons.

To recompile invalid objects, click the Recompile all invalid objects link on the Navigation bar.

If you want to recompile a single dependency that is currently selected the click the Recompile dependency link on the Navigation bar.

If you want all dependencies to be recompiled then click the Recompile all dependencies link on the Navigation bar.