Chat now with support
Chat with Support

Toad for Oracle 13.1.1 - Getting Started Guide

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

Create Support Bundles

Toad Resources > 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 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

Required Privileges for Toad

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

 

Required Oracle Privileges

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

 

Required Window Privileges

Required Privileges > Required Window Privileges

In order to install and run Toad for Oracle, make a connection, and do basic operations, you must have the following privileges:

Operating System Requirements

Windows XP

Windows Server

  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Homes directories that you use for your connections
  • Be a Power User or Administrator

Windows Vista

Windows 7

  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Homes directories that you use for your connections
  • If UAC (user account control) is enabled, you must have administrator privileges

Windows 8

Windows Server 2012

  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Homes directories that you use for your connections

Note: Other functionality in Toad may require additional privileges.

 

Related Documents