Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Is there a way to filter out schemas with no objects in the explorer?
In some of our databases we have many schemas that are just users and a few schemas that hold objects. It would be very helpful to be able to only have to see those few schemas that own objects. I almost never need to browse a schema with nothing in it.
Best Answer
-
Can you connect directly to the user that owns the schema? That would make a clean separation - only the schemas you connect to will be displayed.
If not, I take it you make heavy use of the "Other Users" node in Oracle Explorer?
We are working on a Oracle Explorer filter for an upcoming release. This is good feedback. Thanks.
Answers
-
Can you connect directly to the user that owns the schema? That would make a clean separation - only the schemas you connect to will be displayed.
If not, I take it you make heavy use of the "Other Users" node in Oracle Explorer?
We are working on a Oracle Explorer filter for an upcoming release. This is good feedback. Thanks.
-
Yes for some databases there is one particular user and we could possibly connect as our own user and use the "Current Schema" option. But for nearly all our databases there are a few (or a few dozen) important schemas that contain objects and hundreds of user accounts that shouldn't ever contain any objects.
So we indeed heavily use the Other Users tab. This works best when we can filter out these users that have no objects. For our use case in fact the Other Users tab is the only part that is useful. But I can understand that maybe most people don't work like this. Most other tools are also heavily biased towards having everything in one schema and logging in or proxying in to that schema.
Any other improvements that reduced noise like hiding categories of object that a user doesn't own would also be very helpful.
Another helpful feature would be able to search or filter by name while browsing the explorer to help navigate schemas that have hundreds of tables.
In any case the VS Code Developer tools are really cool and with a few improvements in the Object explorer I might be able to convince some old dogs to try them out.