Product Support - Toad for Oracle

Filter to browse recommended product support content
(Choose different product)

Self-service tools will help you to install, configure and troubleshoot your Dell product.

480 X 270 player for the Support Link Solution pages
Our technical support staff has identified the following critical information to get you started. To get the best results make sure you read through all material prior to using your Dell Product.

Toad for Oracle 12.6 Release Notes Contains information about new features, enhancements, bug fixes for Toad for Oracle
Toad for Oracle 12.6 Guide to Using Toad for Oracle (Korean) Contains instructions for installing and setting up Toad for Oracle.
It is possible to import settings from any version of Toad ? what importations are officially suported?
It is possible to import settings from any version of Toad ? what importations  are officially suported?
Toad for Oracle support for SDO_GEOMETRY objects
Toad for Oracle support for SDO_GEOMETRY objects. 
What does SQL Recall (F8) save?
What does SQL Recall (F8) save?
Below is a list of the recommended software along with any documentation that will help with the install process to bring your product to the version referenced.

Toad for Oracle 12.6 Installer (for 64-Bit Oracle Client)
Use this installer for the following:- Toad for Oracle Base- Toad for Oracle Professional- Toad for Oracle Xpert- DB Admin Module. Please refer to the Support Portal knowledge article SOL15106 to see the differences in each Toad for Oracle bundle.
Toad for Oracle 12.6 Installer (for 32-Bit Oracle Client)
Use this installer for the following:- Toad for Oracle Base- Toad for Oracle Professional- Toad for Oracle Xpert- DB Admin Module.Please refer to the Support Portal knowledge article SOL15106 to see the differences in each Toad for Oracle bundle.
Toad DBA Suite for Oracle 12.6 Installer (for 64-Bit Oracle Client)
Use this installer for the following:- Toad DBA Suite for Oracle- Toad DBA Suite for Oracle - RAC Edition- Toad DBA Suite for Oracle - Exadata Edition.Please refer to the Support Portal knowledge article SOL15106 to see the differences in each Toad for Oracle bundle.
Toad DBA Suite for Oracle 12.6 Installer (for 32-Bit Oracle Client)
Use this installer for the following:- Toad DBA Suite for Oracle- Toad DBA Suite for Oracle - RAC Edition- Toad DBA Suite for Oracle - Exadata Edition. Please refer to the Support Portal knowledge article SOL15106 to see the differences in each Toad for Oracle bundle.
Toad for Oracle 12.6 Base Edition Installation Guide Installation instructions for the base Edition of Toad for Oracle
Toad Development Suite for Oracle 12.6 Installer (for 64-Bit Oracle Client)
Use this installer for the following:- Toad Development Suite for Oracle.Please refer to the Support Portal knowledge article SOL15106 to see the differences in each Toad for Oracle bundle.
Technical Support has reviewed all the support information and has identified the most popular helpful tips and how to videos or articles to ensure you get the most out of your Dell Product.

Toad for Oracle Fundamentals Training - Free to Customers Using Toad for Oracle 12.5 or Later
This self-paced, web-based training course is available for FREE to customers using Toad for Oracle 12.5 or later. If you have an older release, please visit our Support portal  to upgrade. If you have any questions, please contact your local Sales Representative for further details at sales@software.dell.comSelf-paced, web-based course designed for Oracle professionals interested in learning...
Toad for Oracle Fundamentals Training
The Toad for Oracle Fundamentals Training is a self-paced, web-based training course is for Oracle Professionals who needs to learn how to install and configure the product, learn the core features, and how to increase his/her productivity utilizing Toad for Oracle.
The window database | administer | Tablespaces is empty
The window database | administer | Tablespaces is empty.  There is no information that appear in this window.  The Schema browser | Tablespace does show the info. 
Poor performance with Toad Insight in APPS schema after upgrading from 12.1 to 12.5
In Toad for Oracle 12.1, while logged in an APPS schema, the Toad Insight (Code Assist) had great performance after typing in the dot (.) after the schema name. However after upgrading to Toad for Oracle 12.5, after typing in the dot, Toad will be busy for about 3 minutes before becoming responsive yet no tables were populated in the Pick List.
Is there a way to disable Jump feature?
Jump feature is not used and the jump file is taking 5MB of space. Is there a way to disable this?
Accessibility of Toad with respect to vision impaired
Visually impaired Windows users can use screen readers such as JAWS by Freedom Scientific and NVDA (Non Visual Desktop Access).   Does Toad support screen readers?
The information below represents the most common issues customers are encountering or recent resolutions to help you trouble shoot your Dell Product.

Common Oracle connection issues in Toad for Oracle 10.x & above. Frequently asked questions.
How to troubleshoot connection errors when logging-in to a supported Oracle database using either a 32-bit or 64-bit Oracle Client. Common Oracle Connection errors: ORA-12154: TNS: could not resolve service name ORA-12505 TNS:listener could not resolve SID given in connect descriptor ORA-06413: Connection not opened Error: 1.0 [Load Interface dlls failed] Initialization error: Could not fi...
Error 1603 (Internal error 2738) when installing SQL Optimizer as part of Toad bundle.
Getting error 1603 when installing SQL Optimizer as part of Toad bundle. The following error is displayed in the msi log:"Error 2738: Could not access VBScript runtime for custom actionMSI (s) (AC:84) [14:37:52:749]: Product: Quest SQL Optimizer for Oracle -- Internal Error 2738"
Toad Editor pauses or is busy for 5 seconds every minute or so
Whether connected to an Oracle database or not, the Toad Editor will pause or freeze for about 5 seconds and then is responsive again like normal. This cycle of it freezing or pausing happens approximently every mintue.Having the Task Manager up and seeing the CPU for the Toad.exe process shows it spike from 0 to 25 when the issue occurs. This happens every minute as well whether activly typing in...
Tablespace object browser refresh error
Open the tablespace browser and select a tablespace containing objects. Clicking the refresh button results in the object contents view being empty.1.) Open tablespace browser and choose a tablespace e.g Users, the associated objects are displayed.2.) Click the refresh button and the display is reset as the tablespace selection is reset. This is by-design.3.) Choose the same tablespace name from t...
Gets the error: "Cannot create file...SettingsLocations.ini. The process cannot access the file because it
When launching or starting Toad for Oracle, the error below is received:ERROR:Toad has encountered an unexpected error.  Details: Cannot create file "C:\Users\<User_Name>\AppData\Roaming\Quest Software (or Dell)\Toad for Oracle\SettingsLocations.ini". The process cannot access the file because it is being used by another process.
Copying a query statement script into Toad Editor hangs Toad. Simply copying it in causes Toad to hang or freeze.
The following script, when copied into Toad 12.5 Editor, causes Toad to hang, and never get a chance to execute it. Simply copying it in causes Toad to freeze. The parenthesis before the upper command should not be there, and when removed, the script does not hang. In Toad 12.6, copying the script does not freeze Toad, but running it using F9 will hang Toad.select distinct lower(b.gobeacc_username...
SQL Loader error: The program can’t start because oraodm12.dll is missing from your computer.
SQL Loader error:  The program can’t start because oraodm12.dll is missing from your computer. Try reinstalling the program to fix this problem.
Odd messages when trying to type in the editor. Unable to type a particular letter in Toad Editor.
Certain keyboard keys bring up unexpected windows or messages when typing in the editor. 1. In one case, when in the editor, every time the 's' is typed, the message, "no SQL to add" comes up.2. In another case, typing the letter  'r' does not do anything. No 'r' is displayed, or any window pops up when it is typed.
Exporting a table with many columns, to an Excel Instance, is slow
When exporting a dataset to an Excel Instance, Toad seems to be very slow and only exports around 100 rows at a time.
Version Full Support as of Limited Support as of Support Discontinued
12.6 9/25/2014
12.5.x 6/5/2014 12/5/2015
12.1 9/19/2013 3/19/2015 9/19/2015
12.0 6/20/2013 12/20/2014 6/20/2015
11.6.x 10/2/2012 9/23/2014 3/23/2015
Earlier product versions not listed are considered discontinued.

The Product Support Lifecycle table above describes the phase during which Dell Software products are eligible for product support and new release downloads.