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.10?
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 6491
Schema Compare. Need a list of tables / views being accessed in the background to grant privileges to user. (213872)

Schema Compare. where to get a list of tables / views being accessed behind the scenes, so that access or grant can be given to a user. SELECT_CATALOG_ROLE has been revoked from the user due to restrictions. User is unable to do Schema Compare now. ...

Product(s): Toad for Oracle
Last Updated On: 5/22/2017
(0 Ratings) 511 views
How to run a silent installer as administrator (226994)

How to run a silent installer as administrator. Running as administrator can help if getting the following error message running install: 1. - Toad_xXxX has stopped working, when installing, the installer stops and does not install. 2. - The LOG says: ...

Product(s): Toad Data Point, Toad for SQL Server, Toad for Oracle
Last Updated On: 5/18/2017
(0 Ratings) 274 views
How to create the Support Bundle file in Toad (229559)

How to create the Support Bundle file in Toad In Toad for Oracle: Support Bundle: Can be found in Toad menu| Help | Support bundle >> Then click on the Support Bundle Tab and save this text file file in the Desktop. In SQL ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/18/2017
(0 Ratings) 10 views
Generate Database Script does not include the "Create Database" option. (44253)

Are there any options in Generate Database Script to include CREATE DATABASE statements in the script? This feature is not available. There are no future plans to add an option in Generate Database Script to include CREATE DATABASE statements in generated script.

Product(s): Toad for Oracle
Last Updated On: 5/17/2017
(0 Ratings) 1422 views
Toad hangs or takes long time to start with CPU spike (100%) on Windows Server 2008 and 2012 Virtual Machine. (65551)

Toad hangs, freezes, or takes a long time to startup or launch (or very slow to start up) with CPU usage spike increase of 100% on Windows Server 2008 VM and Windows Server 2012 VM. Trying to start Toad for Oracle on a virtualized Windows Server VM. ...

Product(s): Toad for Oracle
Last Updated On: 5/17/2017
(0 Ratings) 6199 views
Formatter does not save formatting options for Header when there is more than one line in the header (229496)

Steps to reproduce the issue: Go to View | Toad options | Formatter and, on the right panel , select “Oracle Formatter Options” | Header Select “Enable“ Write a header with two lines. For example: My Header Company Name Click Apply and Ok The second line is not saved. ...

Product(s): Toad for Oracle
Last Updated On: 5/17/2017
(0 Ratings) 7 views
VIDEO - How to configure TNSNAMES.ORA and the Oracle Instant Client to connect with Toad (76454)

How can one configure TNSNAMES.ORA for use with an "Oracle Instant Client" (OIC) without having to input the database connection information? OR. Databases not listed in the drop-down menu on the connection window using an Oracle Instant Client. RESOLUTION 1: ...

Product(s): Toad for Oracle
Last Updated On: 5/15/2017
(1 Ratings) 74956 views
Excel cannot open file XxXx.xlsx because the file format or file extension in not valid (229451)

When double clicking on the exported excel (.xlsx) file, one gets the message: "Excel cannot open file XxXx.xlsx because the file format or file extension in not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. ". ...

Product(s): Toad for Oracle
Last Updated On: 5/15/2017
(0 Ratings) 9 views
Querying from an Oracle 8i to an Oracle 11g DB via DBLink fails: ORA-03113 (228807)

Executing a select statement from an Oracle 8i to an Oracle 11g DB via DBLink with Toad for Oracle 12.7 provokes and error: ORA-03113: end-of-file on communication channel. This exception does not occur when executing the query from SQL Plus on the server. ...

Product(s): Toad for Oracle
Last Updated On: 5/15/2017
(0 Ratings) 5 views
Getting an error when trying to set up task scheduler. (229427)

Getting an error when trying to set up task scheduler. When tries to finish gets error saying application has encountered a problem and needs to close-interface not supported Os not supported by the version of Toad for Oracle installed ...

Product(s): Toad for Oracle
Last Updated On: 5/15/2017
(0 Ratings) 18 views
Version of Toad 12.10 is slower than version 12.7 when loading the list of packages (229378)

Version of Toad 12.10 is slower than version 12.7 when loading the list of packages. This only happens the first time the packages are loaded. There were some changes in the queries Toad runs on the background to load the ...

Product(s): Toad for Oracle
Last Updated On: 5/12/2017
(0 Ratings) 4 views
How to download a commercial software installer? Need installer by FTP or mail. (17322)

How to download a Commercial version installer from the Quest Support Portal? In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. Steps to download a commercial product: ...

Product(s): Toad Intelligence Central, Toad for SAP Solutions, Backup Reporter for...
Last Updated On: 5/11/2017
(0 Ratings) 20202 views
Is Toad for Oracle certified with Oracle client version 12.2? (227908)

Is Toad for Oracle fully certified with Oracle client version 12.2.0.1 and 12.2.0.2? There is no information in the release notes of Toad for Oracle version 12.9 or 12.10. In the release notes of Toad for Oracle 12.9 or 12.10 it states Oracle client 12c is certified. ...

Product(s): Toad for Oracle
Last Updated On: 5/11/2017
(0 Ratings) 5 views
Does Toad for Oracle supports Team Foundation Server? (101208)

Is Toad supported with Team Foundation Server (TFS)? What versions of TFS are supported? TFS 2012 support starts from version Toad 12.1. TFS 2013 support starts from version Toad 12.5. TFS 2015 support starts from version Toad 12.9. TFS 2017 is not supported yet.

Product(s): Toad for Oracle
Last Updated On: 5/11/2017
(1 Ratings) 2815 views
Is there an expected date to reach the end of life of Toad for Oracle? (227638)

Is there an expected date to reach the end of life of Toad for Oracle? Toad for Oracle is one of the best tools to develop and manage Oracle databases. One of the major benefits Toad offers is, it reduces the effort and time you ...

Product(s): Toad for Oracle
Last Updated On: 5/11/2017
(0 Ratings) 82 views
How to disable message - Toad Memory Usage (229348)

When starting Toad For Oracle, one gets a "Toad Memory Usage" pop-up. How to disable that popup? In the User Files Folder, look for DEBUG=1 in "Toad.ini". Change it to DEBUG=0 or remove it.

Product(s): Toad for Oracle
Last Updated On: 5/11/2017
(0 Ratings) 6 views
Cannot get the column headers background to be "Filled" with gray when exporting to Excel (59248)

Under previous version, when exporting data grid contents to Excel, the column headers would use a "fill color" of gray. Now, when exporting, the column headers have no fill color. Is that behavior user-configurable? Is it possible ...

Product(s): Toad for Oracle
Last Updated On: 5/9/2017
(0 Ratings) 1384 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: 5/8/2017
(0 Ratings) 4848 views
Installation, Unable to install product, "Unknown Error: this installation package failed due to an unknown error, returned error code [0xXXXXXXXX]. (229237)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Unknown error. The issue happens on there is an unknown error happened during the installation. ERROR: "Unknown Error ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 23 views
Installer, Unable to install, getting the [8007051B] or [0x80070002] or [0x80070005] error. (229234)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the [8007051B] or [0x80070002] or [0x80070005] error. The issue happens on the bundle installer does not have the administrative privileges to perform the installation. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 27 views
Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD] (229235)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Https error. The issue happens on the web installer then your internet connection is unreachable. ERROR: "HTTPs Error: This package download processes are interrupted. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 30 views
Installation, "Insufficient Disk Space Error: this installation package failed due to insufficient disk space, returned error code [0x80070643] (229236)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the insufficient disk error. The issue happens on then there is no sufficient disk space to perform the installation. ERROR: "Insufficient ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 22 views
Database | Administer | Tablespace is slow in 12c database (229197)

When connected to a 12C Oracle database, the Database | Administer | Tablespace feature is significantly slow. There are not any other Oracle performance issues in the Application for this Oracle database and we do not have ...

Product(s): Toad for Oracle
Last Updated On: 5/5/2017
(0 Ratings) 7 views
“Move configuration to Intelligence Central” option is grayed out (229196)

When trying to install Team Coding objects on the Toad Intelligence Central (TIC) server, the “Move configuration to Intelligence Central” option is grayed out. What are the requirements to have this selection enabled? Here ...

Product(s): Toad for Oracle
Last Updated On: 5/5/2017
(0 Ratings) 7 views
What is a "license number" and how to find the license number in Toad for Oracle. Invalid license number error. (120553)

How can a Toad for Oracle or Toad family products license number be looked up? What is the difference between a "license number" and a "license key"? A license number is different from a license key. A license number is ...

Product(s): Toad Decision Point, Toad Intelligence Central, Toad for SAP Solutions...
Last Updated On: 5/4/2017
(4 Ratings) 22768 views