Discussions
Categories
- 385.1K All Categories
- 2.6K Data
- 618 Big Data Appliance
- 2K Data Science
- 452.3K Databases
- 222.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 576 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 576 SQLcl
- 4K SQL Developer Data Modeler
- 187.8K SQL & PL/SQL
- 21.5K SQL Developer
- 13 Data Integration
- 13 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.4K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.5K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 186 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 175 Java 8 Questions
- 86K Java Programming
- 82 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
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 588 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 197 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 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.