I would like a sort of "All Schema" option in the schema browser that will list all objects, all Jobs, all Packages or all whatever, in the Schema Browser. Is there anyway of doing this in Toad?
There is no "All Schema" option that automatically lists all objects of a database.
There are other similar options currently in Toad though.
WORKAROUND 1:
In Schema Browser, set the browser style to "tree view". There is an option for "all schemas" but this is categorized by user, so it lists the different user/schemas in the database and you would need to further expand to see the objects that belong to that user.
WORKAROUND 2:
Object Search has been reworked in 9.1. In it, you can specify any or all schemas and then search for any object type. Once the results are listed, you can perform other actions on them.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center