Next: , Previous: alert, Up: tools


4.16 Invalid Objects

This tool is useful to recompile invalid objects in the database.

images/invalid.png

To the left you see a list of invalid objects. Select an object and the editor on right hand side will be filled with code to recreate the object, you can then fix whatever problem may be with it. Rows with errors will have red background and you can see the error in the statusbar by putting the cursor on the row. You can also refresh the list or change the active connection by the buttons in the toolbar.

Recompile all invalid
This button will try recompiling all displayed invalid objects. Different types of objects are recompiled by callind different statements: Index:
     alter index <schema.index_name> rebuild
Package body:
     alter package <schema.package_name> compile body
Public synonym:
     create or replace public synonym <synonym_name> for <synonym_target>
All other objects are recompiled using:
     alter <object_type> <schema.object_name> compile