30 SQL Developer Tips in 30 Days, Day 24: Hiding Schemas That Don’t Own Anything

thatjeffsmith SQL Developer 10 Comments

Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply a Filter Make sure your …

30 SQL Developer Posts in 30 Days, Day 23: Invalid Objects

thatjeffsmith SQL Developer 5 Comments

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. Browsing 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 …