SchemaBrowser

One thing you can do is to right-click over the tabs and choose "Configure". This will let you rename and reorder the tabs. Another option is to choose a different style of schema browser. Go to Options→Schema Browser→Visual and look at the different options available. After you change an option there, open a new schema browser to see the new style.

1. Use filters on the left hand side to limit the number of objects to be loaded into the list. You can get TOAD to prompt you for a filter before it even loads the list, if you check Options→Schema Browser→Data→Automatically show filter dialog for filtered lists on browser.
2. If you have not already done so, upgrade to TOAD 7.6. The control used for most of the left hand side lists in TOAD 7.6 loads a lot faster than the one used in TOAD 7.5 and earlier.

In TOAD 7.6 and up, you can get a list of what the icons mean by clicking the "Schema Browser Icon Legend" button that is located at the top of the right hand side of the schema browser.

View → Options → Datatypes + Include Byte/Char spec when creating DDL from 9i databases Its not really an issue, unless you are on a db with a NLS_LANG that uses more than 1 byte per character. In some cases you could be using 4 Bytes per character and if you ran your script from a normal ASCII DB to one that was storing multi-byte chars, you would run into some trouble.

Package bodies that belong to another schema appear in the Oracle view DBA_OBJECTS but not in ALL_OBJECTS. If you don't have access to DBA_OBJECTS, then Oracle will not give us that information. If you have access to DBA_OBJECTS but you are still not seeing the package bodies for another schema, go to View→Options→Startup and check "Check for access to DBA views". Then make a new connection.

Jobs that belong to another schema appear in the Oracle view DBA_JOBS but not in ALL_JOBS. If you don't have access to DBA_JOBS, then Oracle will not give us that information. If you have access to DBA_JOBS but you are still not seeing the jobs for another schema, go to View→Options→Startup and check "Check for access to DBA views". Then make a new connection.

From Richard Squires on the TOAD group :

Option 1: Right Click on the Object List/Tabs and select "Show RHS" or
Option 2: Press F12

From the TOAD group, answer supplied by Jeff Smith with enhancements by Norm

On most pages in the SB, you can change the query used to interrogate the database as follows :

• Right click on the object in the SB left side, 'Tables' or 'Indexes' for example.
• Click on the 'Filter xxxx' option.
• On the dialog, enable the 'View/Edit Query Before Executing'
• Enable the 'Custom Filter' option as well. If you do not do this, the modified query is used once only. The next refresh will revert to the original query.
• Click OK.
• Replace existing query with your mods.
• Voila!

That saves you waiting for a new patch to fix the problem. However, if you make the changes to the query, it will only be saved for the current connection. Other sessions (new or existing) are not affected - unless they are to the same schema@database as the one you edited.

If you wish to save the new query with a name :

• Open the filter dialog again, as above.
• Click the 'Saved Filters' button.
• Click 'Save current filter as ...'
• Fill in a name for the filter and a filename to save it to.

Next time you click on the 'Saved Filters' button, you will see the name you gave your filter. This saved filter will appear in the list of saved filters for all connections, present and future - until you delete it of course.

Another often asked query from the Toad lists. From Louis Brouillette:

In old versions of TOAD (like 7.6), there was a "users with role" tab in the SB for roles. I can't find it anymore. Is it still available somewhere?

To which John Dorlon replied :

• In the SB left side, click on roles.
• Click on the role in question in the list of roles.
• On the right side of the SB, click on the Role Grants tab.
• Check the option to display Grants Made.

The RHS will now list all schemas that have been granted the selected role.