Is there a way to view only certain schemas in the Schema Browser?
I have hundreds of schemas in my environment and to then scroll through them all alphabetically, repeatedly, can be hassle task. Is there a way to view only the schemas I frequently go to in the Schema Browser some how?
The Oracle Users List option will allow customizations on which schemas are shown in the Schema Browser:
1. Close the Schema Browser.
2. Go to Session | Oracle Users List in the main menu.
3. In the Configure User Lists window, click on the "UnSelect ALL" button.
4. Check only the Schemas desired to be seen in the "All Schemas" list. (tree-view mode).
5. Click OK.
6. Launch the Schema Browser and only the Schemas selected will be shown in the All Schemas drop-down menu.
NOTE: This setting is remembered separately for each connection.