Toad for Oracle - Search Global

Refine Your Search
Advanced Queries | | Increase Your Search IQ
Video - How to Backup and Restore Toad Settings and Options (196872)

How to Backup and Restore Toad Settings and Options? How to Backup and Restore your Toad Settings Option. 480 X 270 player for the Support Link Solution pages.

"TNS-03505: Failed to resolve name" error when trying to connect to database. (40788)

I am having an issue connecting to a database with the error "ORA-12154 TNS:could not resolve the connect identifier". I have copied over the entry in tnsnames.ora entry from the $ORACLE_HOME/network/admin/tnsname ...

How to use Toad for Oracle's SQL Tracker tool

Last Updated On: 4/29/2016
Product(s): Toad for Oracle
Encountering issues with the Record Macro feature in Toad for Oracle. Many of its functionality are not working properly. (197120)

Encountering issues with the Record Macro feature in Toad for Oracle. Many of its functionality are not working properly. For example, tried Recording a Macro as: typed: select * from dual and ran it. When the Macro is played, it showed garbled text in the Editor. ...

Toad for Oracle Schema Compare does not detect Queue Table differences (197158)

Using the feature Schema Compare and to check Queue Tables. When one schema has Queue Tables and the other does not, this fact does not appear under the Results Tab. Compare with Queue Tables not compared although schemas have differences with objects. ...

Out of Memory errors since upgrading to 12.8 (184320)

As TOAD 32-bit is open for a while, the memory it consumes (as noted in Task Manager) keeps increasing until it reaches over 1.2GB, and then starts giving Out of Memory errors. The only way to recover the memory is to kill TOAD. ...

"Out of Memory" error when viewing data from table with a lot of columns and rows. (16369)

Error received when viewing data in Schema Browser | Tables | Data tab or from SQL Editor | Data Grid tab from a table that contains a large amount of columns and rows: "Out of Memory" This error does not occur when the number of column or rows displayed are limited. ...

ORA-03113 end-of-file on communication channel when running a query in the SQL Window (3574)

Running a query in the SQL Window generates ORA-03113 end-of-file-on communication channel. It does not seem to occur the first time running a query after opening TOAD, but if running the query again, the problem is reproduced. ...

Getting "Stream Read Error" (95670)

Getting "Stream Read Error" and the general Toad program becomes slow and unresponsive. This error shows when. * Connecting to the database. OR. * When Auto Optimize is selected for a query. Problem caused by corrupt Toad user files. ...

Numbers displayed in scientific notation even when option is disabled. (55929)

Large numbers are displayed in scientific notation in the data grid, even when the "Display large numbers in Scientific Notation" Toad option is disabled. The width of the number may just be too large for Oracle and the NUMWIDTH settings needs to be adjusted. ...

How to download a commercial software installer? Need installer by FTP or mail. (17322)

How to download a Commercial version installer from the Dell 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: ...

Is there a way to find the history of all commands executed in current session in Toad? (189824)

Is there a way to query online and archived redo log files in Toad? RESOLUTION: LogMiner can enable you to query online and archived redo log files and it can be used as an audit tool. LogMiner Utility provides you: Extracting ...

"Division By Zero" error in Schema Browser. (30917)

In Schema Browser when going to the Views tab select a view click on the Script tab (RHS) Division by zero error occurs. Rename the TOAD.INI file in the TOAD folder. 1. Close TOAD 2. Go into TOAD folder and rename TOAD.INI to TOAD.INI.OLD 3. Restart TOAD.

Connection to Teradata database for Toad for Oracle (32582)

Is it possible to connect to a Teradata database in Toad for Oracle? No. Teradata databases are currently unsupported and there are no plans to develop a Toad for Teradata. There is another product called Toad Data Point ...

How to save (or export) data from the Data Grid to an Excel file ot instance. (15780)

How to save (or export) data from the Data Grid to an Excel file or instance. RESOLUTION 1: 1. Copy and paste data from the Data Grid directly into Excel by selecting the desired rows, then press CTRL+C to copy the selected ...

Can multiple installs of Toad be installed onto one system? (23235)

Can multiple installs of Toad be installed on one system? Yes, multiple installs of Toad can exist on the same system as long as they are not the same version. When installing, please specify two different install directories. Toad ...

SQL Recall F8 function key does not work after upgrade of Toad (31676)

F8 function key for SQL Recall window does not work after upgrade of Toad. Other F keys stopped working as well. RESOLUTION 1: If upgraded to version 9.0.1: 1. Close Toad 2. Locate and rename C:Program FilesQuest SoftwareToad ...

Unable to load Dell SQL Optimizer for Oracle engine (153496)

When trying to auto-optimize an SQL statement from the editor, got an error "Unable to load Dell SQL Optimizer for Oracle engine". Tried applied KB article 68789 but issue still persist. Trying on a fresh installation with another machine, the issue still persisted. ...

Which versions of Toad for Oracle can support Oracle 12c? (183947)

Which versions of Toad for Oracle can support Oracle 12c? Oracle 12 c works on Toad for Oracle 12.0, 12.1, 12.5, 12.51, 12.6, 12.7, 12.8 version. Toad has been tested on Oracle databases 12c.

Get "the connection w/server was reset" error when trying to download an application. (42980)

When trying to download from http://software.dell.com I get a "the connection w/server was reset" error. Possible internal firewall issue. Verify internal network and internet privileges. If download privileges are limited, contact Dell Software. ...

Parameters entered in Set Parameters tab are not propagated to anonymous block. (196045)

During execution of PL/SQL package from the Schema browser by clicking the right mouse button on the package, and clicking "Execute Package", the window "Set Parameters" appeared. Then values was entered at the tab ...

Installer for Toad for Oracle Suite does result in an error code 0x80070643 (SQL Optimizer issue) (195259)

Toad for Oracle Suite crashes with following errors. ExecutePackageComplete returned error code [0x80070643]. ExecuteComplete returned error code [0x80070643]. ApplyComplete returned error code [0x80070643]. Try installation ...

Team Coding Administrator cannot choose from all the database schemes when adding a new project (196049)

Team Coding (TC) Administrator cannot choose from all the database schemes when adding a new project. Toad returns an ORA-00942 table or view not exist error when trying to select from other database schemes. If the ...

Error: "ORA-01017: Invalid username/password; logon denied" when trying to connect to 11g database. (41864)

PROBLEM 1: When trying to connect to an 11g database from the command line or within Toad, the following error, "ORA-01017: Invalid username/password; logon denied" is received. Connection to a 10g database through the command line works, but not to 11g. ...

Predefined SQLs are not successfully to Toad Editor (194215)

Some SQLs are imported with forward quotes and some with backward quotes. Problem in source (eg Word file). Check quotes in source file. Use for example Notepad where differences between forward and backward quotes are better visible.