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
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in 12.12?
Which Installer do I download?
Search KBs from within Toad
Common Connection Issues
How to find the license number
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 6612
How to group the Toad Windows toolbar according to the DB connection? (233907)

How to group or organize the other or Toad Windows toolbar (below the Connections bar) according to the database connection? Right-click the 'Window Bar' area (this is the toolbar below the 'Connection Bar'), and click on “Show Buttons for Current Connection”. ...

Product(s): Toad for Oracle
Last Updated On: 10/20/2017
(0 Ratings) 7 views
Anonymous Block with with a cursor output parameter Executing Twice (233434)

When executing an anonymous block ( pl/sql blocks ) with with a cursor output parameter, Toad is executing the block twice. Toad is doing an OCI describe, before running the query, to determine the ideal fetch size of the result set. ...

Product(s): Toad for Oracle
Last Updated On: 10/19/2017
(0 Ratings) 4 views
The DDL for partitioned indexes are not extracted correctly (233763)

In the Schema Browser, looking for a partitioned Index, and clicking on the Script Tab, one may see that the partitions only have names at the beginning, after a few partitions, they start coming nameless The partition name is ...

Product(s): Toad for Oracle
Last Updated On: 10/19/2017
(0 Ratings) 12 views
Random or common or generic "Access Violation" error while using Toad for Oracle. (17405)

I receive an "Access Violation" error while using Toad. These errors appear to be random, do not seem to have a pattern, and do not happen in a common window. Access Violations are generic error messages that were not properly handled by Toad. ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 3681 views
Toad 12.12 menu font size cannot be increased (233812)

In Toad 12.12, the main top menu bar (File, Edit, Tools etc) does not change size when the Windows display setting is set to 125% in the Control Panel. It still shows the same way as when this Windows setting is at 100%. In ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 4 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 10/18/2017
(1 Ratings) 7717 views
An object's team coding status is not correct when checking it out (228097)

An object's team coding status is not correct when checking it out. Steps that cause the error: 1) Open an instance of Toad, load an object (procedure/package/etc.) and check-out. 2) Open another instance of Toad as another user and connect to the same instance. ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 1 views
Installation of Toad fails with the following error 'Https Error: mismatch the file IDs or the file services unreachable' (233805)

During installation of Toad using the .exe bundle installer (either Commercial or Trial version), the following error occurs: 'CachePackageComplete returned event status code: [0x80070570]. ToadForOracle_Trial_12.12.0.39_x64_En ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 16 views
How to use kerberos authentication in Toad for Oracle (130589)

Customer configured oranet to authenticate through Active Directory kerberos mechanism. Question: how to make toad for oracle to use kerberos authentication? RESOLUTION. Please put EXTERNAL in the username field and leave the password blank. ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(2 Ratings) 3321 views
Toad hangs or freezes at startup or launch. (2439)

Toad hangs at startup or launch and the Task Manager indicates that the application is not responding. Disabling the sound card, a corrupted sound card driver or a port conflict. RESOLUTION 1: Perform a complete Reboot or Restart of your computer and then retest Toad. ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 35725 views
Error connecting to database:"ORA-12545:Connect failed because target host or object does not exist" (55934)

The following error occurs when connecting to a remote database: "ORA-12545: Connect failed because target host or object does not exist". Firewall 'Blocked' setting for Toad.exe. RESOLUTION #1: Change existing firewall ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 4345 views
Schema Compare does not work correctly when Ignore User/System name differences is enabled. (233641)

During schema comparison when system generated foreign key constraint names are different, regardless if an option "Ignore User/System name differences" is checked. This was working in Toad for Oracle 12.10. WORKAROUND: None. SOLUTION: ...

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 2 views
Wrong formatting of Create Table statement (233644)

The CREATE TABLE command has a bad formatting in Editor window. WORKAROUND. None. SOLUTION. Issue fixed in version 12.12. The latest version of Toad for Oracle can be downloaded here.

Product(s): Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 1 views
Automation script errors when the SQL is run: 'Script was executed with 0 errors and 1 compile error' (233733)

An automation script errors when the SQL is run, with the message 'Script was executed with 0 errors and 1 compile error' Oracle configuration Test the script in the Editor, and if the error occurs there also, please ensure that the Oracle client is the same version as (or later than ...

Product(s): Toad for Oracle
Last Updated On: 10/16/2017
(0 Ratings) 9 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: 10/13/2017
(0 Ratings) 106 views
Toad for Oracle v12.11 Trial version doesn't uninstall fully (233593)

With the uninstallation of the Toad for Oracle v12.11 Trial version, in the Add/Remove programs list, once all the Quest applications are uninstalled, there still remains an entry for the actual trial installer. When you try to uninstall ...

Product(s): Toad for Oracle
Last Updated On: 10/13/2017
(0 Ratings) 18 views
'Copy selected columns to clipboard' button in Schema Browser doesn't copy. (231441)

The button 'Copy selected columns to clipboard' in Schema Browser | Tables | Right Hand Side does not copy anything. WORKAROUND. Use the dropdown arrow to the right of the button to select the relevant copy type. STATUS. Issue fixed in version 12.12. ...

Product(s): Toad for Oracle
Last Updated On: 10/13/2017
(0 Ratings) 180 views
What's new in Toad For Oracle 12.12? (233622)

This article contains some new features released with version 12.12. The following new features were introduced in this minor release of Toad for Oracle 12.12. New Features. Automation Designer. -The Automation Designer ...

Product(s): Toad for Oracle
Last Updated On: 10/12/2017
(0 Ratings) 83 views
Export Dataset to Excel Overwrite option does not work (233555)

In an automation, when using Export Dataset to an Excel file, and selecting Overwrite for "If file exists", it seems to behave as if you selected "Add new sheet". WORKAROUND: none. STATUS: fixed in the 12.11 release of Toad For Oracle, it can be downloaded here.

Product(s): Toad for Oracle
Last Updated On: 10/11/2017
(0 Ratings) 38 views
Oracle's LISTAGG function is not working in Toad, and it works in SQL Plus* (233286)

Using LISTAGG in a query, the list is empty in Toad, but not in SQL Plus* NVARCHAR2 datatype, The issue is in the way strings are handled in the program. Toad's database connectivity layer handles them in a way that treats "ASCII-0" as "end of string". ...

Product(s): Toad for Oracle
Last Updated On: 10/11/2017
(0 Ratings) 38 views
TFO 12.10. Subversion. Even if 'VCS Naming Options' is unchecked, it still puts the schema name in front of the filenames after Check Out and Check In. (233527)

Toad for Oracle (TFO) 12.10. Team Coding. Subversion. Even if 'VCS Naming Options' is unchecked in the Team Coding Configuration, it still adds the schema name in front of the file names after Check Out and Check In. Install and use Toad for Oracle 12.11 instead. ...

Product(s): Toad for Oracle
Last Updated On: 10/11/2017
(0 Ratings) 10 views
What is Compare "Multiple Tables" and where is it located? (233491)

What is Compare "Multiple Tables" and where is it located? Where can I find it? What version was it first offered? The new Compare Multiple Tables feature (new feature added to the 12.11 version) allows you to compare and synchronize multiple tables between two schemas. ...

Product(s): Toad for Oracle
Last Updated On: 10/9/2017
(0 Ratings) 18 views
Invalid command to Lock/Unlock partition stats in Analyze All Objects window (233464)

In Toad 12.11, it does not generate the expected statement when doing the following steps: 1. Load a partitioned table into Analyze All Objects window. 2. Check some partitions on tables tab, 3. Check either the Lock or Unlock Mode in Options Tab. ...

Product(s): Toad for Oracle
Last Updated On: 10/9/2017
(0 Ratings) 32 views
Formatter issue. The index hint itself is off one space. It's one space too far to the right. (233436)

Toad for Oracle 12.11. The index hint itself is off 1 space. The first slash of the index hint should align with the stacked columns below it, so in the example below, the slash should be above the letter "d" (first character of first stacked column) and not “a” the second character. ...

Product(s): Toad for Oracle
Last Updated On: 10/6/2017
(0 Ratings) 43 views
Operation aborted: MaxElementDepth constraint violated ... (233408)

Trying to create an Explain Plan for an INSERT statement, one may see the error: Error: "Operation aborted: MaxElementDepth constraint violated. Line: 1<PlanElement id = '674' operation="HASH JO..... The error only occurs ...

Product(s): Toad for Oracle
Last Updated On: 10/5/2017
(0 Ratings) 34 views