Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

Toad for Oracle - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in 12.11?
Which Installer do I download?
Search KBs from within Toad
Common Connection Issues
How to find the license number
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 6567
Formatter puts the column alias for the CASE statement onto a separate lines after the CASE statement. (232209)

Formatter puts the column alias for the CASE statement onto a separate lines after the CASE statement. They are wrapping to the line below for each column. The issue is caused when there is a CASE statement in the select. ...

Product(s): Toad for Oracle
Last Updated On: 8/18/2017
(0 Ratings) 10 views
Unable to debug on RAC database on Exadata with several networks (232172)

When connecting to a RAC database in an Exadata environment, it's not possible to debug whilst connecting to this database. The error is: 'ORA-12170: TNS: Connect timeout occurred' Toad runs this query to make a connect string for RAC. Normally, it returns only one row. ...

Product(s): Toad for Oracle
Last Updated On: 8/18/2017
(0 Ratings) 10 views
Toad Query Builder. The Scroll Bar in the individual table boxes acts or behaves erratically. (232140)

Toad Query Builder. The Scroll Bar in the individual table boxes acts or behaves erratically. Once the height of the table box is adjusted, dragging the scroll bar up or down seems to stop prematurely, it doesn't want to scroll all the way to the top or the bottom. ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 11 views
How to launch SQL Optimizer from within Toad for Oracle? (105609)

How to launch SQL Optimizer from within Toad for Oracle? How to optimize SQL query statements in Toad for Oracle using SQL Optimizer? What are the different ways to launch SQL Optimizer? NOTE: Ensure the Toad for Oracle license key has the SQL Optimizer option. ...

Product(s): SQL Optimizer for Oracle, Toad for Oracle
Last Updated On: 8/16/2017
(1 Ratings) 6785 views
Toad installation gives a privilege or group policy error (69739)

The Toad installation may encounter one of the following errors: 1. ERROR: "You don't have the privilege to perform the installation. Please login as administrator to install the product.". or. 2. "The installation can't be completed. ". or. ...

Product(s): Toad Data Point, Toad for DB2 ZOS, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/16/2017
(2 Ratings) 8024 views
"Minimum size" for file definition is not computed correctly (213821)

In Toad For Oracle 12.10, under Schema Browser | Tablespaces | Alter Tablespace | Data Files | Edit, the minimum size is not calculated correctly in some cases. This issue is caused by a previous change in how Toad calculates this information. WORKAROUND None. ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 460 views
Double clicking on a package in schema browser leads to Access Violation (231794)

After using Toad for Oracle for a few hours and opening a package by double clicking it in the Schema Browser or by using "Load object from database" from the Editor window, an error occurs: "Access violation at address 00000000041A5CBE in module 'Toad.exe'. ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 1 views
How to relocate or cleanup folder C:\users\<>\Oracle\oradiag_<>? Why this folder is created? (229702)

A folder with many logs is created at the location "C:\users\<< Username>>\Oracle\oradiag_<<Username>>". Why this folder is created? How to relocate or cleanup this folder? Errors related to Oracle itself. Not a Toad issue. WORKAROUND: ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 7 views
Characters disappearing when copying from Toad Editor and pasting in Word 2010, Evernote or Outlook (218412)

With the "Copy text in rich text format" option activated, when pasting special characters such as å,ä,ö,Å,Ä,Ö from Toad for Oracle 12.10, 12.9 or 12.8 into Word, Evernote or Outlook, the characters disappear. Pasting them as ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 280 views
How to upgrade Toad for Oracle (231735)

How to upgrade Toad for Oracle? There is no upgrade process for Toad for Oracle. Toad for Oracle may be installed side by side with the old version, but installations are separated.

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings)
Schema Browser | Scheduler Jobs | Scheduled Run Times displays time zone incorrectly (213301)

In Toad for Oracle 12.9 and 12.10, in Schema Browser | Scheduler Jobs, the timezone time in the "Info" and "Scheduled Run Times" tabs are not the same. This can occur when the job is set to a timezone which is different from the one set in the NLS_LANG parameter. ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 508 views
Explain plan window does not display content properly (213969)

After upgrading to version 12.10, explain plan window displayed from session browser or editor is not displaying it's content properly, like some parts of it are not re drawed after changing session / sql. To fix it it is necessary ...

Product(s): Toad for Oracle
Last Updated On: 8/16/2017
(1 Ratings) 633 views
Non-secure FTP utility does not transfer files correctly (215389)

When using the non-secure FTP to transfer a file, the output shows that the transfer completes, but only part of the file is transferred. There is no difference when selecting ASCII, binary or default mode. When doing the transfer ...

Product(s): Toad for Oracle
Last Updated On: 8/14/2017
(0 Ratings) 175 views
Launching or starting Toad gets the error: "Toad cannot update its client folder..." (100869)

After installing Toad, users are getting the following error when they start Toad: 1). Toad cannot update its client folder. Please make sure that you have full read and write access to. 'C:\Users\Administrator\AppData\Roaming\Quest ...

Product(s): Toad for Oracle
Last Updated On: 8/10/2017
(1 Ratings) 6137 views
Get "Ora-12641: Authentication servers failed to initialize" error when connecting (232005)

When connecting to a database, the following message is received. Ora-12641: Authentication servers failed to initialize. This is usually not a Toad for Oracle issue. It is usually an issue on the Oracle side. Click here for an article ...

Product(s): Toad for Oracle
Last Updated On: 8/10/2017
(0 Ratings) 6 views
Common Oracle connection problems (7712)

How to troubleshoot connection errors when logging into a supported Oracle database Common Oracle connection errors: * ORA-12154: TNS: could not resolve service name * ORA-12505 TNS: listener could not resolve SID given in connect descriptor * Error: 1.0 [Load ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 8/10/2017
(0 Ratings) 31288 views
Schema Browser is too slow (231991)

12.9 used to work fine, but, after installing 12.11 Toad for Oracle takes too long to open the Schema Browser, the list of object is visible but is like it's hanging because you can't click on anything. One may see the column "Team ...

Product(s): Toad for Oracle
Last Updated On: 8/10/2017
(0 Ratings) 9 views
Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks (213218)

Error "ORA-00936: Missing Expression" when clicking on 'System' tab of Session Browser | Locks. Open Session Browser; Don't select a session; Click on lower right hand side LOCKS tab; click locks tab between User and System. ...

Product(s): Toad for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 552 views
Would like the ability to run a compare multiple times in the new Schema Compare window (231979)

In the legacy Schema Compare window, users could run a compare, make changes, and then run the compare again. In the new Schema Compare window, once a compare is run the Compare button becomes disabled. It is ...

Product(s): Toad for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 8 views
Would like ability to save schema compare as a template. (231980)

There are compares that are done on a regular basis. It would be nice to have the ability to save a schema compare, so it does not need to be filled out each time it is to be done. It would be nice to be able to create it once, then ...

Product(s): Toad for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 8 views
Would like to have tabs, like the legacy Schema Compare window, added to new window, instead of Back and Next buttons (231978)

Would like to see the workflow of the new Schema Compare window be closer to how the legacy window was. In the new Schema Compare, users have to use the back and forth buttons to move within the feature. Having tabs ...

Product(s): Toad for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 6 views
How to find out who is using what license key in order to deactivate the user from the license? How to track the license keys? (105289)

How to find out who is using what license key in order to deactivate the user from the license. In the event of a Toad user leaving, how can the licensed key be tracked down and deactivated from the user. It is the responsibility ...

Product(s): Toad Data Point, Toad Data Modeler, Toad for DB2, Toad for SQL Server...
Last Updated On: 8/9/2017
(1 Ratings) 4890 views
Launching Toad. "No valid Oracle Clients found" error message when opening or starting Toad. (71545)

When starting the Toad application or trying to connect to a database, Toad for Oracle returns the following error: "No valid Oracle Client found. Please note that Toad only supports 32-bit Oracle Client installations.". OR. "No valid Oracle clients found. ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 8/8/2017
(5 Ratings) 119271 views
How to connect to an Oracle Cloud Database (using SSH) (231921)

How to connect to an Oracle Cloud Database (using SSH) Please review the following ToadWorld article which discusses how to set up the necessary tns entry and the instructions for setting up SSH via PuTTY. How to connect to an Oracle Cloud Database.

Product(s): Toad for Oracle
Last Updated On: 8/7/2017
(0 Ratings) 1 views
Schema Compare in Toad 12.11 does not find any differences when using Direct connection to the database and schema name is the same in both databases (231612)

In Toad 12.11, when using a Direct Connection to the database, the Schema Compare function does not find any differences if the compared schemas are from different Oracle database connections, but have the same name (eg comparing a schema from a development ...

Product(s): Toad for Oracle
Last Updated On: 8/7/2017
(1 Ratings) 83 views