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 6646
Can't login to Toad. What is the Toad password? (80949)

Cannot or unable to login. What is the Toad password? The account is locked so it needs to be unlocked and the password reset. There is a prompt that the password has expired, and to reset, the old password is needed, but what is the old password? ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 12/15/2017
(2 Ratings) 13712 views
RAC connection. ‘Toad Script Runner (TSR)’ gets error: ORA-12154: TNS: could not resolve the connect identifier specified (235391)

RAC connection. Starting 'Toad Script Runner (TSR)' or 'Quest Script Runner (QSR)' gets error: ORA-12154: TNS: could not resolve the connect identifier specified. For the TSR, the error also happens on regular non-RAC connections. ...

Product(s): Toad for Oracle
Last Updated On: 12/15/2017
(0 Ratings) 7 views
What are Team Coding Roles? How to administer Team Coding status settings? (46011)

What are Team Coding roles? How to do administration on Team Coding status settings? It gives the message: "Connection settings will be read-only. For read and write privileges, you have to have the Administrator role". or. "Version Control System (VCS) is not enabled". or. ...

Product(s): Toad for Oracle
Last Updated On: 12/13/2017
(0 Ratings) 2518 views
Team Coding error: "Team Coding Upgrade Required" (210429)

Getting the message: Team Coding Status Checks: Team Coding Upgrade Required. Team Coding (TC) objects need to be upgraded (Team Coding | Configuration | 'Migrate legacy Team Coding settings'). Have a DBA user or a user with proper privileges perform the upgrade. ...

Product(s): Toad for Oracle
Last Updated On: 12/12/2017
(0 Ratings) 831 views
Poor Performance when Clicking Script tab or doing Single Object Compare (234360)

In 12.7.1.11 of Toad for Oracle, clicking "script" tab in Schema Browser for table in large schema, or do "Compare" of "Single Object" for table in large schema across 2 DBs, returns quickly, < 1 sec elapsed time. Later versions ...

Product(s): Toad for Oracle
Last Updated On: 12/12/2017
(0 Ratings) 55 views
Get ORA-02019 after runner query with dblink for database that moved servers (235199)

Database just got migrated from one server to another. Now, when running a query with a dblink for that database, the following error is returned. ORA-02019: Connection Description for Remote Database Not Found. DBlink no longer contains the correct information. ...

Product(s): Toad for Oracle
Last Updated On: 12/8/2017
(0 Ratings) 5 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: 12/7/2017
(0 Ratings) 1757 views
Export Dataset to default to XLSX files when browsing to find Excel files. (97609)

Export Dataset to default to XLSX files when browsing to find Excel files. Export Format XLS File is selected and "..." is chosen for File field. The only option available in file type drop down to find files is XLS files. Please add XLSX to this list and make it a default file type. ...

Product(s): Toad for Oracle
Last Updated On: 12/7/2017
(0 Ratings) 2211 views
Connection error: "The PL/SQL language parser must have a rule named Toad_UserTables" (86948)

When I tried to connect to my database, I get the error: "The PL/SQL language parser must have a rule named 'Toad_UserTables'. Please correct this on the Editor-Behavior options page.". RESOLUTION: 1. Close out of Toad - very important. 2a. ...

Product(s): Toad for Oracle
Last Updated On: 12/6/2017
(1 Ratings) 9229 views
Navigator is very slow to populate with a package that has over 10,000 rows (235021)

The Navigator is very slow to populate when opening a large package in version 12.12. It seems to be related to Code Analysis. To reproduce the problem you need a very large package (about 10000 lines) which includes ...

Product(s): Toad for Oracle
Last Updated On: 12/4/2017
(0 Ratings) 8 views
Unable to install Toad. Error: Exception has been thrown by the target of an invocation. Access is denied. (218473)

Unable or cannot install Toad. ERROR: System.Reflection. TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'C:\Users\<your_user>\AppData ...

Product(s): Toad for Oracle
Last Updated On: 12/1/2017
(0 Ratings) 883 views
How to format one or more files with Toad's Formatter? (235005)

How to format one or more files with the Formatter ie like a batch formatter? For instructions on how to format multiple files, please go to the Help menu | Contents | Search Tab | type: formatter | press enter | double-click on 'Formatting Files'. ...

Product(s): Toad for Oracle
Last Updated On: 12/1/2017
(0 Ratings) 14 views
After upgrading, the filter/sort window, for the Schema Browser's data grid, is different (235004)

After upgrading, when clicking on the filter/sort button, above the data grid on the right hand side of the Schema Browser, the window that comes up is different looking. Does not look like what could be done in previous versions can be done with this new window. ...

Product(s): Toad for Oracle
Last Updated On: 12/1/2017
(0 Ratings) 12 views
ODBC connection not working, Oracle to Oracle, no error message, only freezes (234992)

Having a ODBC connection to import from, and using TFO 12.12: And going to “Schema Browser | Tables | Right-Click on a Table | Select 'Import Table Data' | Next”: If you try to expand the “Source Table Name”, Toad hangs, nothing happens, no error messages, it just hangs. ...

Product(s): Toad for Oracle
Last Updated On: 12/1/2017
(0 Ratings) 13 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: 12/1/2017
(0 Ratings) 1785 views
Is there a Toad license that includes Quest Code Tester for Oracle? (94307)

Is there a Toad license that includes Quest Code Tester for Oracle? 'Toad Development Suite for Oracle' includes Quest Code Tester for Oracle. The latest bundled version of this can be downloaded here. For further information ...

Product(s): Toad for Oracle
Last Updated On: 11/30/2017
(0 Ratings) 1492 views
Team Coding - Toad does not show the subfolders in the "Select Project" window (234941)

If an initial Subversion checkout is done as "Empty" or "Immediates" from an existing subversion (server) repository, Toad won't allow to drill down into the sub-folders when setting up Team Coding and selecting a server project. ...

Product(s): Toad for Oracle
Last Updated On: 11/30/2017
(0 Ratings) 15 views
SQL Recall Window opens and closes very slowly in v12.12 when unpinned (234927)

In v12.12 the SQL Recall window is slow to appear and re-appear, when unpinned and showing a full list of statements. This doesn't happen in 12.11 or earlier, but is seen in v12.12 and v13 beta. It opens normally if the output ...

Product(s): Toad for Oracle
Last Updated On: 11/30/2017
(0 Ratings) 6 views
Starting SQL Tracker receives the error, "No valid Toad for Oracle, SQL Nav... licenses is found". (103036)

Starting SQL Tracker either from within Toad for Oracle or the Start Menu, will invoke the error below. "No valid Toad for Oracle, SQL Navigator, or Space Manager licenses found. SQL Tracker will shutdown now.". Other computers ...

Product(s): Toad for Oracle
Last Updated On: 11/14/2017
(0 Ratings) 3283 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: 11/8/2017
(1 Ratings) 6491 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: 11/1/2017
(1 Ratings) 8844 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) 3416 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) 7237 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) 9012 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) 5759 views