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 …

How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 9 Comments

Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing about 90 tables. Our user …