Welcome, we are now Quest! Learn more about Support at Quest

Toad for Oracle - Search Global

Refine Your Search
Advanced Queries | | Increase Your Search IQ
How to reset Data Grid to default? The Data Grid cannot be viewed, missing, hidden, or not showing. (76911)

The Data Grid cannot be viewed, missing or hidden, or not showing, and cannot drag it up. How to reset the Data Grid to default view? RESOLUTION 1: 1. Put your cursor on the blue top boarder of the Data Grid. 2. Right-click and select 'Restore Default Desktop'. ...

How to disable Automatic Updates or the Toad Update message? How to silently deploy that setting? (101358)

Each time Toad is launched, it displays the following message at the bottom right of the screen: Toad update A newer version of Toad is available to download. How to disable Automatic Updates or the Toad Update message? How to silently deploy that setting? ...

Schema browser is unusable. ORA 00904: COLS.IDENTITY_COLUMN: invalid identifier (226138)

Schema brower is unusable. ORA-00904: COLS.IDENTITY_COLUMN: invalid identifier Appears to be some corruption on that database being tested. Rerun the upgrade scripts. Afterwards, the column appears where it should.

SQL Editor Window in Toad returns an error when a new line is entered (226200)

Working with SQL Editor window returns an error when a new line is entered. How to deactive this behavior in Toad? This behavior can be deactivated in Toad for Oracle by going to View | Toad Options | Execute / Compile | Behavior ...

Get "cannot open file... The Parameter is incorrect" error exporting data for multiple tables (226162)

When exporting data from multiple tables into one file, if Insert Statements is selected as the Export Format, then a "cannot open file . The Parameter is incorrect" error is returned. It exports data for the first table in the list, but the error is returned for the second table. ...

Error when starting Toad: The following tags were not closed: FilterHistory, Filter. Line :0. (226113)

Toad is not starting. Cannot launch Toad. Getting the error: "The following tags were not closed: FilterHistory, Filter. Line :0.". Laptop crash caused Toad user files corruption. Perform a reset on the Toad user files. NOTE: If some ...

A few things don't look right under Large Text conditions (223679)

WORKAROUND: Choose "100% (Default)", in Windows 7 "Control Panel | All Control Panel Items | Display", in order to make the dropdowns look correctly. RESOLUTION: Waiting for a fix in a future release of Toad for Oracle. ...

The same select in a new installation of Toad outputs a different result than with the old installation (220498)

The same select in a new installation of Toad outputs a different result than with the old installation. The select is executed as part of an Automation Designer app, in an Export Dataset activity, and is exported to an Excel file. ...

Automation Designer action, run with specific parameter file, works when launched within Toad, but not from command line. (225955)

In Automation Designer, a simple app is created, which contains a single 'export dataset' action. Create a parameter file for that app 'param.ini' Copy the parameter file to 2 other names and edit them to produce different results. ...

Using 'Switch with Source Schema' option returns different results (225860)

When comparing two schemes and using the 'Switch with Source Schema', the results sometimes differ from the original run. Steps to reproduce the problems (note that this only happens under some circumstances). Go to Database ...

Toad: Error, "The procedure entry point OCIPOrastreamFormLob could not be located in Oraclient11.dll" after connecting (204972)

When connecting to the database after opening Toad this error is returned: "The procedure entry point OCIPOrastreamFormLob could not be located in the dynamic link library oraclient11.dll." or "The procedure entry point kokoicvttstz ...

The DBMS output window in Procedure Editor is not updated (10988)

The DBMS output window in the Debug part of the Procedure editor window is not updated if I step through my code (with DBMS_OUTPUT statements), but the window is only updated at the very end of the Debugging session. The same is true for the DBMS Output window. ...

Is there a way to view contents of savedsql.dat file outside of Toad? (225719)

For auditing purposes, we need to be able to view the savedsql.dat file. However, when it is opened in Notepad, it is not easy to read. Is there anyway to view the savedsql.dat file outside of Toad. If using v12.10, there's an Export ...

Schema and Multiple Schema Compare generates DROP POLICY for Data Redaction Policies (225707)

Multiple Schema Compare generates DROP POLICY statements for Data Redaction Policies. The same Redaction policies exist on an 11g RAC database and a 12c RAC database. Multiple schema compare generates the following: ...

How to get execution plans for all SQL statements in a script? (41950)

What functionality is used to get the execution plans for each SQL statement in a sql script? Launch Quest SQL Optimizer for Oracle either as standalone, or via Toad for Oracle or SQL Navigator. 1. Select 'Scan SQL' tab 2. Create ...

Code Assist does not bring up filtered column list for more complicated queries (225447)

When amending a query to add a new column to the select portion of the query,using aliasname. and then further filtering eg typing 'A', Toad displays a blank screen instead of the columns that start with 'A'. So typing aliasname. brings up a list of columns OK. ...

How to automate the install process (225658)

What is the best way to automate the install process? To automate an installation, a job will need to be created and run that runs the silent install commands for Toad. Click here to read our installation guide that shows the commands to silently install Toad for Oracle.

Is there a way to configure Toad to use Kerberos authentication with a Proxy User? (179664)

Logging into Toad using Kerberos as External user and logging into a Proxy user by itself works, but not will not work with attempting to a proxy user using Kerberos authentication. What is the configuration to use in Toad to utilize both Kerberos and Proxy user? ...

Install, web service, Web Service error: Phone home web service not available to process key (155627)

User gets the same error after multiple trials installing trial " TOAD for Oracle 64 bit version " software. Server was not up. Download the installer app again from same download site.

Unable to load 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. ...

How to Backup and Restore Toad Settings and Options (196872)

How to Backup and Restore Toad Settings and Options? Using the feature " Copy User Settings". 480 X 270 player for the Support Link Solution pages.

Cannot find the Quest Uninstaller after installing Toad for Oracle 12 (147699)

Cannot find the Quest Uninstaller after installing Toad for Oracle 12. In previous versions it was possible to uninstall products through the Quest uninstaller . This feature has been deprecated Please uninstall products through the Windows add/remove option.

How to use the SQL Tracker tool? (193849)

Video - How can SQL Tracker be used to troubleshoot issues in Toad? SQL Tracker can be used to troubleshoot issues in Toad by allowing you to capture and view the queries being run in the background of Toad. For example ...

How to install Toad for Oracle using the new Web Installer (178737)

How to install Toad for Oracle using the new Web Installer. The Transcript to the Toad for Oracle Installer video: In this video, one will see the new installer for Toad for Oracle. The installer introduces a new User Interface (UI ...

VIDEO - How to install Toad for Oracle 12.7 using the new Web Installer. (153938)

How to install Toad for Oracle 12.7 using the new Web Installer. The Transcript to the Toad for Oracle 12.7 Installer video: In this video, one will see the new installer for Toad for Oracle 12.7. The installer introduces a new User ...