Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Retrieve License Keys

Quest provides a web site to retrieve lost license keys. You must provide the email address associated with the license and your license number.

To retrieve your license key

  1. Select Help | Licensing.
  2. Click Retrieve License Key.
  3. Complete the fields on the web site


Create Support Bundles

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

  1. Select Help | Support Bundle.
  2. Review the following for additional information:
    Option Description

    Email Quest Support

    This opens the "Email Quest Support" window with instructions and links to contact Support, and to open a new case or service request.

    Quest Web Support This opens Quest Software's award-winning Support portal in your default browser , with access to Licensing Assistance, the 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

To use Toad, certain privileges are required both in an Oracle database and in your Windows environment.


Required Oracle Privileges

Some Toad features require special Oracle privileges. This topic lists required privileges per Toad Edition.

Base Edition

Window Privileges
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 For Oracle 10g and 11g, DEBUG CONNECT SESSION privilege.

DB Admin Module

Window Privileges
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.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating