The Support Bundle window provides information about several aspects of your Oracle and Toad setups. In addition, the Support Bundle lets you easily report problems to our peer-to-peer mailing lists or directly to Support.
If Toad itself fails, the Error dialog box displays. This type of an error creates a log, saved as toad.elf. This Eureka LogFile (.elf) contains both the application information and the callstack of the error created, and can be very helpful to Support in solving issues you are having with Toad.
To create a support bundle
- Select Help | Support Bundle.
- Review the following for additional information:
|
Email Support |
Click to open the Email Quest Support window which provides instructions and links for contacting Quest Support. Use an existing Case or Service Request ID, or click the links to open a new service request. |
| Online Support |
Click to open Quest Software's award-winning Support Portal in your default browser, with access to Licensing assistance, a searchable Knowledge Base, product downloads, and more. |
|
Attach TOAD.INI (or SQL Tuning Support details) to emails |
If selected, this attaches the details to any email sent through the support bundle, whether it is to the peer-to-peer Toad list or to Support. |
Required Privileges for Toad
To use Toad, certain privileges are required both in an Oracle database and in your Windows environment.
Some Toad features require special Oracle privileges. This topic lists required privileges per Toad Edition.
Base Edition
| Audit SQL/Sys Privs |
To audit occurrences of a SQL statement, you must have the AUDIT SYSTEM privilege.
To audit operations on a schema object, the object you choose for auditing must be in your own schema or you must have AUDIT ANY system privilege. In addition, if the object you choose for auditing is a directory object, even if you created it, then you must have AUDIT ANY system privilege. |
| Current Schema Toolbar |
ALTER SESSION system privilege. |
| DBMS Debugger |
DEBUG CONNECT SESSION privilege. |
DB Admin Module
| Alert Log Viewer |
The user account must have the EXECUTE privilege on Oracle's UTL_File package. (The SYS schema has this privilege by default.) |
| Analyze All Objects |
SELECT privileges on the CHAINED_ROWS table to view chained rows. |
| DBMS_Flashback |
EXECUTE privileges for DBMS_FLASHBACK. |
| Index Monitoring |
To see another user’s indexes you must have access to the SYS.OB$, SYS.IND$, SYS.USERS$ and SYS.OBJECT_USAGE views and the ALTER ANY INDEX privilege. |
| Instance Manager |
SYSDBA or SYSOPER privileges to shut down or alter the status of a database. |
| LogMiner |
EXECUTE privileges on DBMS_LOGMNR and DBMS_LOGMNR_D. |
| Toad Space Manager |
The Toad schema must have the privileges to create and alter jobs, create and drop its own tables and procedures, and must have SELECT access on: DBA_TABLESPACES, DBA_DATA_FILES, DBA_FREE_SPACE, and V_$FILESTAT. |
In order to install and run Toad for Oracle, make a connection, and do basic operations, you must have the following privileges:
|
Windows non-Server
Windows Server |
- Read access to the Oracle client folder
- Read/write privileges on the Oracle Home directories that you use for your connections
|
|
Note: Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Installation requires administrator privileges on all supported operating systems. |
|
Note: Other functionality in Toad may require additional privileges. |
