A forum question today reminded me that I’ve never talked about dealing with your broken Oracle database objects in SQL Developer. So let’s take care of that in today’s post.
Show me EVERYTHING that is broken
Run the report.
Optionally provide a schema to filter the report, the default is to show the entire database.
I want to fix an entire schema’s worth of broken stuff!
Right-click on your connection.
Set ‘ALL OBJECTS’ to ‘false’ – that will only recompile invalid objects in that schema.
This dialog will run this code:
BEGIN dbms_utility.compile_schema( schema => USER, compile_all => FALSE, reuse_settings => TRUE ); END;
Note: this can take quite awhile to run, so you may want to open up a session in SQLcl…