Toad® for Oracle

Version 11.0

Release Notes

September 30, 2011


Welcome to Toad for Oracle

New in This Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

Upgrade and Compatibility

System Requirements

Global Operations

Getting Started

For More Information

Welcome to Toad for Oracle

Toad for Oracle provides an efficient and accurate way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow and productivity. With Toad for Oracle you can:

The Toad for Oracle solutions are built for you, by you. Over 10 years of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over one million, Toad for Oracle continues to be the standard tool for development and administration.

Toad for Oracle Editions

All commercial versions of Toad are bundled with additional Quest products, based upon the Edition that you purchased. For more information about the latest features in your Toad Edition and the bundled products, see the Toad Editions Release Notes.

New in This Release

Review the following sections for new features in this release.

All Toad Editions



Schema Browser

Team Coding and Source Control


Professional Edition and Higher

Code Analysis (formerly CodeXpert) is Toad's powerful code review and analysis tool. It helps you ensure that the performance, maintainability, and reliability of code meets and exceeds your company’s best practice standards.

Watch the Evaluating PL/SQL Code Quality with Code Analysis video on Quest's video channel.

Code Analysis has the following new features:

DB Admin Module, DBA Suite Edition, and DBA Suite RAC Edition

Idea Pond

Idea Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.

The following Idea Pond submissions were implemented for this release:

Feature Enhancement Idea Pond ID
General Add a Date field to Query Viewer. 60
(Import Table Data) Ability to Automap source data to table columns for text files—You can match based on the first row of a text file that contains the column names. 98
Save files as NO BOM format. 128
Close all windows—Right-click the Window bar and selecting Close All Windows. 249
Remove Toad Tips. 143
Restore only the files that were not saved since their last edit. 162

Windows Task Bar flashes when execution completes.

Restrict Toad in production databases—Select the Read Only checkbox in the Database Login window. 172
Preserve tab names on recovered documents. 208
Added a 'Default spooler encoding' option on the General options page—You can now select ANSI or UTF-8. 284
Use DBMS_STATS to gather statistics for Compare Schemas—Previously Toad used ANALYZE TABLE, but DBMS_STATS is the preferred way of gathering statistics. 375
Connections Make tabs sortable in Window Bar and Connection Bar—To use this feature, right-click the bar and select Connection/Window Bar Button Order. 26
Export and import connection settings—Open the Database Login window and click the Import or Export button. 82
Provide an option to end all connections—Click the End Connection button and select all connections in the dialog. 199
Support executing Actions on startup—To use this feature, open the Edit Login Record window and select Execute Action upon Connection. 217

Test connections—From the Database Login window, click the Test Connections button on the toolbar.

Save connection without connecting—From the Database Login window click the Add Login Record button.

Grid Sort within memory—After all rows are fetched, you can right-click and select Memory Sorting. 19

Sum numbers when selecting multiple cells (like Excel)—You can now perform basic calculations on grid cells, such as finding the sum or average of the selected cells. To use this feature, select adjacent cells in the grid and press CTRL+N. The calculations display in a new row below the grid.

Editor Highlight all instances of a variable—Selecting a whole word will highlight all instances of that word in the Editor. 18
Show elapsed time of a statement during execution—A new panel was added to the status bar to display the execution time. 22
Ability to execute SQL embedded within PL/SQL—SQL extraction allows you to execute SQL embedded within PL/SQL with minimal additional work. You can execute embedded SQL by placing the caret within SQL and using the "Execute Snippet" command (CTRL+Enter or Shift+F9) or you can select embedded SQL and use the "Execute Statement at Caret" command (F9). 29, 232, 244
Bypass Toad's parsing to allow compilation—Toad will no longer block on syntax errors caused by the parser. 32
No code completion in comments—Code Insight no longer displays when you are typing within a string or comment. 65, 92
Automatically view results of SQL execution in Trace File Browser—Right-click in the editor and select SQL Trace | Enabled - Retrieve Trace File After Execution. This feature requires the DB Admin module. 66
More convenient word-wrap within Grid Popup Editor—New toolbar button added to grid popup Editor to toggle word-wrap. This affects only that editor and not the global Toad option to enable/disable word-wrap. 86
Close tabs using middle-click. 97
Ability to ignore substitution variables in comments—The option is accessible via the Editor right-click menu and on the View | Options | Execute/Compile options page. Select Ignore those in comments in the Substitution Variable Prompting field. 130

Comma separate a list of text in Editor—You can use the Find and Replace window to do this, and now you can save your settings in the Find and Replace window as a reusable macro. See "Find and Replace Text" in the online help for more information.

Only describe an object if you press CTRL before clicking on it. 327
Display elapsed time and row/column on the same bar—A new panel was added to the status bar to display the execution time. 357
Display length of selected text in Editor in the line/col panel of the status bar. 371

Code completion on procedures fills in named parameters—The Editor now helps you complete parameters by inserting the parameter signature. It creates placeholders for the parameter values, which you can type over and use TAB/SHIFT+TAB to navigate between.

Schema Browser

Select favorite schemas—Schema drop-downs have been updated, and now it is easier to customize them by creating a list of favorites, hiding schemas, setting the default schema for connections, and other options. See "Customize Schema Browser Tabs" in the online help for more information.

Back/Forward buttons in the Schema Browser History. 154
Create insert statements—Feature already existed, but Toad 11 has enhanced features in Export Dataset: 1) exclude primary key columns, 2) exclude virtual columns, and 3) exclude columns by selecting them from a list. 156
Better support for Edition Based Redefinition. 180
Add a calendar view in the Schema Browser for Scheduler Jobs—New "Run Times" tab displays the scheduled run times for the Schedule or Scheduler Job. 266
Describe window (F4) stay open after pressing ESC—Toad has a new option under Options | Schema Browser | Describe Dialogs to control describe windows being closed by ESC or not. 268
DB Admin Tablespaces—Double-click on the tablespace to open the data files tab. 279
Do not collapse the tree view after a refresh. 308
Group Package variables and constants in the left-hand side. 354
Show virtual column information in the Columns grid. 359
Remove Datatype length option. 380
Include Column IDs in grid header. 383


Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad.

Feature Resolved Issue ID

If you have McAfee Antivirus installed, it no longer causes issues in Toad's user interface.

General An "Out of Memory" error no longer occurs when querying a table with a BFILE datatype column. ST82661
General Sending indexes to the Rebuild Multiple Objects window only loads indexes from all of the selected schemas. ST85250
General Toad Security now restricts FTP. ST81974
General A specific Toad Advisor warning now displays the correct metalink note. ST78745
General The Last Analyzed and Num Rows now work correctly in the Object Palette. ST76293
General Multiple Object Rebuild of indexes no longer goes in to a loop update. ST80770
General You can now retrieve Named SQL when only a single query is saved in Named SQL. ST68428
General Administer/Tablespaces now displays tablespace datafiles in 8i. ST79920
General A defunct grid menu was removed. ST68237
General Shortcut keys for chained rows now work correctly. ST81213
General Column settings are now saved in the control file of the SQL*Loader Wizard. ST82065

The Window menu now includes the name of the SQL open in each Editor window.

General Tabs no longer move to bottom after docking/undocking elements such as Object Palette and Code Snippets. ST56850

Toad Security: The accepted number of characters for the Feature column has been increased.

General You can now set menu animations to "None". ST56541
General In the Trace File Browser, a "not a valid integer value" error no longer occurs with certain kinds of trace files. ST66456
General Toad windows now stay on top when you switch between Toad and an external application. ST75860
General Toad Advisor no longer displays "untested version" for Oracle 11g R2. ST78038
General In the Filter Builder, an error no longer occurs when using the IN operator. ST68770
General The Buffer Cache Hit Ratio now calculates correctly in the AWR Browser. ST79509
General The StatsPack Browser Report no longer requires the Begin Snapshot ID. ST81095
General Server-side object generated scripts no longer have incomplete SQL statements. ST81967
General Corrected issues that caused "Out of memory" errors while working with large files. ST56751
Code Analysis

Issues with editing Code Analysis rules have been fixed.

Compare Compare Schemas: The "skip when null" option is now preserved when creating a dimension. ST83562
Compare Compare Schemas: The sync script now includes the drop queue. ST83561
Compare Compare Schemas: Issues causing an ORA-01451 error in the sync script have been fixed. ST83483
Compare Compare Schema: The comparison is now accurate when you are only comparing constraints. ST83648
Compare Compare Schemas: Now displays grants for 'MERGE VIEW' privileges. ST83443
Compare Compare Schemas: The sync script now creates grant statements for directories. ST81540
Compare Compare Databases: Corrected a discrepancy in displaying passwords. ST80921
Compare Compare Single Objects: The sync script now prefixes the schema name to indexes. ST80883
Compare Compare Schemas: The sync script now correctly populates the schema for triggers. ST80769
Compare Compare Schemas: The sync script no longer automatically creates tables when creating a queue table. ST83704
Compare Compare Schemas/Databases: Constraints for VIEWs are now included in the sync script. ST83520

Compare Databases: In the sync script, the create directory statement now comes before the grant directory privilege statement to a user.

Compare Compare Schemas: Java keywords are no longer set to uppercase in the sync script. ST83557
Compare Compare Schemas/Databases: When the clusters tables option is selected, clustered tables are now included in the sync script. ST83792
Compare Compare Schemas: The status for Global Partitioned Index is now picked up. ST84295
Connections Starting Toad via a batch file correctly recognizes environment variables for instant clients. ST82747
Connections Numeric database names are now displayed correctly in the Database drop-down. ST81664
Connections An issue when switching sessions on Connection Bar has been fixed. ST79805
Connections A "Password must be saved in login screen" error no longer occurs when using a connection override. ST75501
Connections The New Connection window now works correctly with comma-separated TNS alias entries. ST79542
Connections There is now an Import/Export feature in Toad for the current database connection passwords. ST57188
Data Grid Modifying data in a grid now retains values when clicking in other cells. ST87581
Data Grid An "Access violation in user32.dll" error no longer occurs when the data grid is set on the right. ST58073
Database Browser The Hit Rates and Event Waits graphs in the Database Browser Overview now populate correctly. ST81281
Database Browser The Buffer Cache hit ratio now displays the appropriate value. ST81280
Database Browser The "Created" timestamp now displays correctly. ST79970
Database Browser The Overview graph now displays correctly. ST79721
DB Health Check The Dictionary Cache Hit Ratio now displays correctly. ST80980
Debug $$plsql_unit and $$plsql_line no longer cause issues in the Debugger. ST82405
Debug 'Where' values are no longer moved to the 'Value' column when using "Execute PL/SQL with Debugger". ST82140
Debug The Debugger can now be started when there are PL/SQL warning compilation messages. ST56558
Editor Formatting is now applied to code containing multi-line strings. ST84214
Editor The Editor now loads large SQL files faster. ST82628
Editor The format when printing Explain Plan has been corrected. ST60227

An issue that caused users to receive an access violation error after loading a script has been resolved.

Editor The ORA-01036 error no longer displays when editing certain variable names. ST81183
Editor Toad's Editor now preserves changes made in the external editor. ST80215
Editor Using the Ctrl+Enter shortcut now executes correctly when comments are present. ST79921
Editor The Editor supports creating procedures using CTRL+ENTER (SHIFT+F9). ST79891
Editor The "Trim string data in char and nchar columns" option now works correctly. ST79395
Editor SET TRIMSPOOL is now supported. ST79317
Editor The EDIT command now works over multiple lines. ST78624
Editor The Find and Replace keyboard shortcuts now work correctly. ST78365
Editor The Editor supports editing queries while running (F9) with threaded queries on. ST78453
Editor Typing in the Current Schema drop-down no longer results in an ORA-01435 error. ST78828
Editor The ANSI join syntax is now correct when sent from the Editor to the Query Builder. ST85297
Editor An issue that caused "Field type should be CLOB, BLOB, or File" errors while running a statement have been corrected. ST83276
Editor Optimize Current SQL now executes substitution variables. ST79460
Editor Selecting the ROWID from a table with no rows no longer causes Toad to hang. ST77771
Editor Toad no longer hangs when opening certain kinds of package bodies. ST75035
Editor Tab shortcuts now work correctly. ST74744
Editor Clicking the hex button in the popup editor no longer causes access violations. ST74703
Editor Optimize Current SQL now works when there is a date variable at the caret. ST74452
Editor The Undo option is no longer disabled after saving a file.



Editor The Code Assist window no longer obscures the Named SQL list. ST73447
Editor Typing with Named SQL (CTRL+N) now displays the options correctly. ST68151
Editor Packages with REF CURSOR now display data in the Results tab when executed in the Editor. ST57445
Editor Expanded nodes no longer collapse when switching between tabs. ST56833
Editor A PLS-00103 error no longer occurs when compiling scripts with Chinese characters. ST57011
Editor Making text upper case now highlights the save icon in the Editor. ST60771
Editor An error no longer occurs when selecting "fieldn" from dual (F5 and F9). ST56777

The Editor no longer executes more than the selection when it includes multiple queries and a syntax error.

Editor Insert/OVR mode no longer stops working after copying and pasting and backspace. ST58215
Editor The "show parameters archive" command now returns results. ST73590
Editor The execution time now displays independently for each tab. ST57232
ER Diagram The "Show more" icon now displays when exporting to the clipboard/graphic file. ST80350
ER Diagram Foreign keys and indexes now display graphically. ST78482
Import/Export Import table data: The date now displays correctly with rc_seed.xls. ST87630
Import/Export If you import from an .xlsx or .xlsm file and the environment is set to Korean, the data imports correctly. ST63195
Import/Export The internal data generation engine now obeys NLS parameters. ST84606
Import/Export Importing fixed width or delimited text now correctly saves AM/PM. ST84553
Import/Export Export Dataset no longer puts the line feed in the wrong place for inserts. ST83805
Import/Export Export Dataset now creates a new worksheet when Excel is open and contains a macro. ST83485
Import/Export Export File Browser: Now exports correctly when a filter is applied. ST82098
Import/Export Import Table Data: Importing now successfully stops when the user clicks Cancel. ST79467
Import/Export Export Dataset: Column headers now display correctly after exporting the LONG RAW data type. ST77880
Import/Export Import Table Data: An "Out of Memory" error no longer occurs when the user selects "show data" on an empty table. ST77927
Import/Export A tag stack error no longer occurs when exporting a large number of rows to Excel 2007. ST84601
Import/Export Importing table data from Excel 2007 is now faster. ST56577
Import/Export Toad's performance when importing to table with many records has been improved.



Import/Export Import Table Data: The preview and actual data import now match. ST76369
Project Manager The Project Manager now displays an error message when trying to overwrite a read-only file. ST81368
Project Manager The FTP Folder Items (Select Files) window now populates correctly. ST79502
Project Manager "External" connections now work in the Project Manager. ST71370
Quest Script Runner Running Quest Script Runner standalone no longer prompts for login when it has already been supplied. ST84506
Quest Script Runner Pasted text now displays in the correct location. ST79749
Schema Browser Nested procedures now display source in the right-hand side after two levels. ST83240
Schema Browser The cursor now moves to the end of a word after double clicking a column name in the Describe (F4) window. ST56638
Schema Browser You can now view objects belonging to that schema when connected as SYSDBA. ST68630
Schema Browser

An error no longer occurs when describing (F4) on a materialized view Explain Plan.

Schema Browser An ORA-02221 error no longer occurs when altering a materialized view. ST80922
Schema Browser LOB index table column names now display in the Indexes tab. ST83162
Schema Browser Favorites: You can now add synonyms from the Object Search window. ST83155
Schema Browser Favorites: When adding from the Object Search window with Show Schema cleared, it now displays the folder name. ST83112
Schema Browser The "Set Tablespace names as defaults for all User Creates" option now works correctly. ST82040
Schema Browser The Refresh button is now enabled when "Auto Refresh" is selected. ST80742
Schema Browser

An error no longer occurs when recreating a sequence and entering a value in the "Start With" field.

Schema Browser The Tablespaces | Objects tab now displays the tablespace name after refreshing. ST80276
Schema Browser Synonyms now display in the tree view mode. ST80340
Schema Browser

The Script tab and original query are no longer different when creating a job with DBMS_SCHEDULER.

Schema Browser Partition information now displays for an indexed organized partitioned table. ST79535
Schema Browser

The "Next refresh" property is now generated when creating a materialized view.

Schema Browser The table rebuild script now includes parameters for compression and parallel. ST78423
Schema Browser An "Out of memory" error no longer occurs when viewing a script for ORDSYS. ST78066
Schema Browser Loading a package to one tab now includes the spec. ST78411
Schema Browser "Copy Data to Another Schema" now works when multiple tables are selected and one of them does not have data. ST77505
Schema Browser The Describe's filter window is no longer obscured when switching between apps. ST74910
Schema Browser The available actions on Users | Role Grants have been clarified. ST57584
Session Browser Adding the client_version column no longer causes the session to disappear. ST83168
Session Browser Blocking locks now display in a RAC environment. ST82249
Session Browser The current statement now displays for Oracle Apps R12 databases. ST81943
Session Browser An ORA-01435 error no longer occurs when used with a shared schema. ST81371
Session Browser

The login information now displays for Oracle Apps R12 databases.

Session Browser Sorting in VARCHAR2 columns has been improved. ST78512
Team Coding Errors experienced with Microsoft Team Foundation Server 2010 have been resolved. ST82082
Team Coding "Failed to initialize VCS provider" errors have been resolved. ST80681
Team Coding The "Automatic Check In" option now works correctly in the Editor. ST83042

Known Issues

The following is a list of issues known to exist at the time of this release.


Known Issue

Defect ID


Database Probe does not work with Oracle version 8.1.5.

Workaround: Upgrade to supported Oracle version 8.1.7


Viewing nested data object types on a 10g database with the 8i client closes Toad.

Workaround: Use a newer client.

General Toad's help cannot be opened from an installation path that contains Unicode characters. ST72966

If you check "Indexes" on the Scripts tab for snapshots, then the primary key for the snapshot will be included in the script, even though the CREATE MATERIALIZED VIEW statement implicitly creates this primary key.

Toad currently does not differentiate between indexes created explicitly on the snapshot and indexes created automatically when the snapshot is created.

Workaround: If you are running the generated script to recreate the snapshot, then you can simply ignore the error that occurs when the script tries to recreate the primary key index for the snapshot. If you do not normally create indexes on snapshots, then you can uncheck "Indexes" when generating the snapshot script.


You may get the following error when moving from the first screen of the LogMiner to the second screen of the LogMiner: "17:46:25 Info: ORA-06532: Subscript outside of limit ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 ORA-06512: at line 2" This results from an Oracle bug in and

Workaround: Upgrade to Oracle version or later, or see Oracle Metalink Note:124671.1 for details of how to fix the package.


If you use 11g Oracle ODP.NET client or any other client that does not have the oci.dll in the BIN directory, Toad has the following problems:

  1. Client shows as invalid
  2. Client version is not detected
  3. As a result of #2, columns of the following datatypes are not shown in the Schema Browser table data: CLOB, BLOB, NCLOB, XMLTYPE, TIMESTAMP, INTERVAL, BINARY_DOUBLE, and BINARY_FLOAT

After running a "Profile Code", "Check Syntax", or "Format Code" against files in the Project Manager, a results tab appears in the output window. Clicking on an occurrence node in the results tab will load the file in the appropriate Toad window. If you are loading a full package into the Editor in this manner and select "yes" to the Spec/Body file split prompt, your file will be split into two Editor tabs. At this point, selecting an occurrence node in the output window will only highlight the appropriate line in the Editor if the line is in the "Spec" tab. Clicking on an occurrence in the Body of the Package will always highlight the last line in the Spec tab.

Workaround: When loading a package into the procedure edit in this manner, select "no" to the Package spec/body split prompt.

Code Analysis Saving results to a database: When dealing with nested procedures, CodeXpert can only insert run data from procs one level deep. N/A
Code Analysis

Saving PL/SQL results to a database may fail or save invalid data to the database for invalid PL/SQL objects.

Workaround: To ensure PL/SQL results are saved to the database correctly, verify the validity of all objects before running CodeXpert.

Connections If you have a custom column and the newer version of Toad is introducing a new column to the Database Login window, your grid customizations will not be retained (such as column order and grouping). Custom columns are retained. N/A
Connections While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly. These features include but may not be limited to Quest Script Runner, Database Browser, and Service Manager. N/A

Selecting a new Oracle home in the ''Connect Using'' dropdown box does not guarantee that the correct home will be used. Switching between major Oracle client versions works correctly in Toad. Switching between patch or mid-release versions of Oracle will not always work. For example, switching from Oracle client and Oracle will not guarantee the correct Oracle home is used.

Workaround: Close Toad use the Oracle Home Selector to select your home, and reload Toad. Select the correct home in the ''Connect Using'' dropdown and login.

Data Grids

You may receive an "ORA-00902 invalid datatype" error when editing an object, nested table, or varray data if you have redefined the data type for that data during the current session.

Workaround: If you redefine an object type, nested table, or varray and then need to edit data in a table based on that type, end your current connection and begin a new one.

Data Grids An ORA-21525 error may display in the data grid while editing a record in a nested table. ST69178
Data Grids

The data grid may hang while scrolling data on Windows 2000.

Data Grids

Pasting multiple rows of text into a cell will only register the first row of the data.

Workaround: Paste multiple rows of text into the text editor (popup editor) instead of into the grid cell.

Debugger An error may display in the Debugger if you select the "Load into grid from memory (strong and weak)" option in the Set Parameters window. ST55847

When file splitting is used in the Editor, Code Analysis does not automatically check the code in the Editor.

Workaround: Click the "Analyze Code in Editor" button.


Toad errors when you query on a field of Oracle collection types.

Workaround: Execute using SQL*Plus.


When spooling to an unpinned output window, the window becomes unresponsive and errors are given when Toad is closed ("Canvas does not allow drawing").

Workaround: Keep the output window pinned.


On an Oracle 8.0 client, if "Display large numbers in scientific notation" is unchecked, and the query contains a non-alphanumeric other than "*", the error "OCI-22061: invalid format text [TM9]" is returned.


  • Select Display large numbers in scientific notation on the Options | Data Grid | Data page.
  • Upgrade to Oracle client 8.1.6 or later.
Editor If you select object tables with nested VARRAYs, the statement is busy and cannot be aborted. ST62336
Editor Toad Insight (Code Assist) is activated in comments, which may decrease Toad's performance. ST64254

If you use a non fixed-width font, the results are misaligned in the of Script Output tab in Editor after executing a SQL script.

Workaround: Go to Options | Scripts and select a fixed-width font for script output.

Editor Pressing CTRL and clicking a type object in the Editor does not open the object's code. ST55866

Exporting data grid cells of over approximately 800 bytes could cause "OLE error 800A03EC" for Microsoft Office 2003 when using the "XLS Instance" option.

Workaround: Save using the "XLS file" option instead.

Import/Export Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause. ST59228
Schema Browser

Sometimes on Oracle 8.1.7 or higher, after pressing "Compile invalid objects", you may get ORA-20000, ORA-06512, or ORA-06512 errors. This could mean that you do not have the privileges to compile the object, but it also happens when the schema contains a package body that does not have an associated spec.

Workaround: Look in the schema that you are trying to compile to see whether there are any orphan package bodies. If it is your own schema, then do:select * from user_objects o1 where object_type = ''PACKAGE BODY'' and not exists (select ''x'' from user_objects o2 where o2.object_name = o1.object_name and o2.object_type = ''PACKAGE'') Then drop any orphan package bodies that are found.

Schema Browser

Viewing XML_TYPE data in the F4 Describe Objects window may cause memory leaks.

Workaround: Try to limit the amount of times the describe window is used to view XML_TYPE data during a given Toad session. Use the Editor or Schema Browser data grid to do the majority of your work with XML data.

Schema Browser

For data in tables, changing the order of the columns in the "View/edit query" popup does not change the order of the columns in the grid.

Renaming a column in the "View/edit query" popup moves the renamed column one position to the left. The renamed column will not be editable.

Workaround: Use drag-and-drop in the grid to change the column order.


Session Browser

Session Browser does not work with Oracle version 8.1.5.

Workaround: Upgrade to supported Oracle version 8.1.7 or later.

Session Browser The Program name in the Session Browser may be blank or may be the full path to the executable instead of just the executable name. This depends on the Oracle client, not on Toad. N/A
Session Browser

In RAC databases, version (and possibly other 10.1 versions), the query used to populate the "Current Statement" in the Session Browser fails with the following error: Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance <instance name> ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments.

Workaround: Clear the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary.

Team Coding

When using Microsoft Team Foundation Server, customers may receive an "Unable to get revision from VCS repository" error followed by "VCS archive is empty". This error generally occurs if customers use different workspaces when logged in to TFS.

Workaround: See Quest Support Solution SOL74899.

Team Coding Team Coding is disabled for mixed-case object names. N/A
Team Coding

Team Coding and SourceSafe:

  • Integration via the SCC API is available but not recommended for SourceSafe 6.0
  • SourceSafe 5.0 ignores the "Force revision" flag and ''Create a new revision for existing objects'' option when exporting.
Team Coding

With CVS, Toad may fail to retrieve the list of projects for you to select from in the CVS browser or in the Code Control Groups configuration.

Workaround: See "Missing CVS\Entries File Error" in the online help.

Team Coding Team Coding and StarTeam: If you cancel the login dialog for StarTeam, you will not be able to log in to StarTeam until you restart Toad. N/A
Team Coding

Team Coding and PVCS:

  • PVCS Version Manager 6.6 and above only supports "Tip Revisions" via the COM interface used by Toad. Attempting to retrieve a non-tip revision using the Version Control Browser will always return the latest revision. (Merant case ID 1230782). This means that comparing revisions in the VCS Browser will fail because both versions will return the text of the latest version of the file.
  • After connecting to a PVCS database, successive connections made during the same Toad session will always connect to the same PVCS database, even if a different database is specified in the "Logon to PVCS" dialog.

Workaround: Close and re-open Toad before attempting to connect to a different PVCS database. If simultaneous connections to two different PVCS databases are required, this can be achieved by opening a second copy of Toad.

Team Coding Team Coding and Clearcase: Dynamic Views are not supported via SCC interface. Snapshot Views must be used instead. (Rational case ID v0830629, Rational Defect # CMBU00053934) N/A

The following features in Toad do not support Unicode:

  • ASM Manager
  • CodeXpert
  • Export File Browser
  • Hex Editor
  • Toad Group Policy Manager

In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser.

Unicode Connections to Service Names with Unicode Characters are not supported. N/A

The Editor does not fully handle Unicode words, and as a result highlight object names, CTRL + Click, and mousing over watch hints may not work.

Workaround: The fix is to change a regular expression in the PL/SQL language parser. New installations will not have this issue, but the language parser is not applied for upgrading users (so you do not lose any language parser customizations). If you are upgrading, you need to modify the PL/SQL language parser and add "?r)" (without quotes)  to the beginning of the “Any name" parser rule’s expression if you want full Unicode object name support. For detailed instructions, please see the Unicode Troubleshooting topic in the Help file.

Unicode Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names. N/A
Unicode XML (Plain) format creates bad XML if Unicode string values and Unicode column names are exported through Export Dataset. N/A

Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean).

Unicode In Team Coding, objects with Unicode contents are supported, objects with Unicode names are not. Supported Version Control Providers do not support Unicode names. N/A
Virtualization An access violation error may display when you close Toad in a Citrix XenApp environment. ST76354

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this Toad for Oracle release.

Feature Known Issue Defect ID
EurekaLog Does not support Unicode characters in exception logging folder. ST62140
E-Control (Editor component) Odd word-wrapping behavior in some languages. Word wrapping may appear between symbols, with no space required to wrap, and some characters cannot be word-wrapped at all (for example, multi-byte characters in ANSI text). N/A

ODAC does not support Unicode in XMLTYPE.

Oracle When the OCI is in Unicode mode, an error occurs when querying XMLTYPE data that uses binary storage. Toad uses the OCI in Unicode mode, and there is no way to disable this. You should be able to view XMLTYPE data without errors using CLOB storage and an Oracle client version of 10.2 or later. N/A

Upgrade and Compatibility

Upgrades for Toad install side-by-side with any previous versions you have installed. You can run the new and previous versions concurrently. The first time you run the new version of Toad you are asked to migrate previous settings files.

Note: Toad supports importing settings only if the new version is within two releases of the previous version. If your versions are more than two releases apart, you need to install an intermediate version to successfully import the files.

Deprecated Features

The following features have been removed from the menus in Toad 11. They will be permanently removed after Toad 11.

System Requirements

Before installing Toad, ensure your system meets the following minimum hardware and software requirements:


512 MB RAM required, 1 GB recommended

Note: The memory required may vary based on the following: 

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Hard Disk Space
75 MB
Operating System

Windows Server 2003 (32-bit and 64-bit)

Windows XP (32-bit and 64-bit)

Windows Vista (32-bit and 64-bit)

Windows Server 2008 (32-bit and 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit and 64-bit)

Note: When running on a 64-bit operating system, you must use the 32-bit Oracle Client.

Database Client

Oracle Client

Oracle Client

Oracle Client or Instant Client

Oracle Client or Instant Client

Note: Only the 32-bit Oracle client is supported.

Database Server

Oracle 8.0.6; 8.1.7; 9i; 9i R2; 10g R1; 10g R2; 11g R1, 11g R2

Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

Cloud Database Service

Oracle databases running on Amazon EC2

Additional Software

Microsoft Internet Explorer 6.0 or later (to view the Release Notes)

Adobe Acrobat Reader 7.0 or later (to view the Installation Guide)

Virtualization Support

Before installing Toad, review the following for virtualization support:

Application Virtualization

Citrix XenApp 5.0 has been tested.

Desktop Virtualization (VDI)

Quest vWorkspace 7.0 has been tested.

Server Virtualization

VMware ESX Server 3.5 has been tested.

Note: Toad may work in virtualization environments other than the ones listed.

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: Toad is a Unicode application. As such, it has native support for any Oracle Unicode character set, such as UTF8 or AL32UTF8. There are some features in Toad which use or invoke Oracle Utilities or applications which are not themselves Unicode applications. Their functionality is therefore limited to the character set of the client on which Toad is running, and NLS_LANG must be carefully set to match the Windows character set.

We have also observed issues with US7ASCII when used with non-Latin characters.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad for Oracle 11.0

    Note: Toad is available in different editions. The release package includes the edition that you purchased.

  2. Product Documentation, including:

Installation Instructions

Refer to the Toad for Oracle Installation Guide for installation instructions.

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad team and other community members. Join the Toad for Oracle community or visit ToadWorld for more information about Toad.

Contact Quest Software



Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656 


Web site

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at:

This guide is available in English only.

© 2011 Quest Software, Inc.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656

Refer to our Web site ( for regional and international office information.


Quest, Quest Software, the Quest Software logo, Benchmark Factory, Knowledge Xpert, Quest vWorkSpace, Spotlight, Toad, T.O.A.D., Toad World, and vToad are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see