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 v13?
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

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 6629
Error "ORA-01427: Single-row subquery returns more than one row" when executing a query (28242)

The following error occurs when executing a query: "ORA-01427: Single-row subquery returns more than one row". Not a Toad issue. A Subquery in the sql statement is returning multiple rows, when one is expected. The outer ...

Product(s): Toad for Oracle
Last Updated On: 6/19/2018
(0 Ratings) 25 views
Windows in Workspace not opening in same order they were saved in (258797)

When opening a saved Workspace, the windows do not open in the same order they are saved. Instead, they are opening all grouped by the type of window they are. WORKAROUND: None. STATUS: Waiting of a fix to be released in a future version of Toad for Oracle.

Product(s): Toad for Oracle
Last Updated On: 6/18/2018
(0 Ratings) 7 views
How to create the Support Bundle file in Toad (229559)

How to create the Support Bundle file in Toad for Oracle, or Toad Data Point, or SQL Navigator? 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. ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 6/14/2018
(0 Ratings) 1411 views
Toad 13.0 is not importing a "Customized Toolbar" from 12.12 (258626)

Having a customized toolbar in Toad for Oracle (TFO) 12.12, when starting TFO 13.0 for the first time, it doesn't show it, the toolbar doesn't even exists in the "Customize" toolbars list. NOTE, when restarting 12.12, it's still in 12.12. ...

Product(s): Toad for Oracle
Last Updated On: 6/14/2018
(0 Ratings) 8 views
Access Violation error in Schema Browser treeview mode, when refreshing certain nodes (258515)

An access violation error occurs when using the Schema Browser in the Treeview mode, and doing a refresh (F5 or the refresh buttons) on certain objects only. This happens for the following items: * DB instance (root node) * Logon ...

Product(s): Toad for Oracle
Last Updated On: 6/13/2018
(0 Ratings) 12 views
Lost a tool bar in the Editor window (54323)

One of the tool bars is gone from the Editor window. How can it be brought back? Right click in the tool bar area and a menu will appear. The entries with checks next to them are the tool bars that will appear in the Editor window. Make sure the wanted tool bar is checked.

Product(s): Toad for Oracle
Last Updated On: 6/12/2018
(0 Ratings) 1521 views
Empty "Schedule Items" list, older version is still running automated tasks, they were not migrated (258434)

In Toad for Oracle (TFO), in its Automation Designer, in the "Schedule Items" section, for the old 12.12 one may see the list of tasks and a historical of executions, BUT, for 13.0, the list is empty. The question is, is it OK to have ...

Product(s): Toad for Oracle
Last Updated On: 6/12/2018
(0 Ratings) 7 views
What's new in Toad For Oracle 13.0? (255128)

This article contains some new features released with version 13.0. New features and enhancements. Dual Monitor Support has been added. You can now use Toad in either its standard MDI (Multiple Document Interface) modes or in SDI (Single Document Interface) mode. ...

Product(s): Toad for Oracle
Last Updated On: 6/12/2018
(3 Ratings) 1548 views
Compare Schemas does not work for PUBLIC schema (258174)

Compare Schemas tool does not work for PUBLIC schema (db links, synonyms, ...) WORKAROUND: None. SOLUTION: Waiting for a fix in a future version of Toad for Oracle.

Product(s): Toad for Oracle
Last Updated On: 6/12/2018
(0 Ratings) 9 views
Some Check constraints are falsely reported as different when doing a Schema Compare. (258401)

For some constraints the Schema Compare shows a difference in "columns" but double clicking on it will show in the side-by-side viewer that there are no differences. As an example create the table and constraint below in two databases and them compare them: ...

Product(s): Toad for Oracle
Last Updated On: 6/12/2018
(0 Ratings) 7 views
Unable to view or cannot see the data for CLOB datatype columns. (62123)

Unable to view or cannot see the data results for CLOB datatype columns. How to see / show / display a preview of CLOB data types in the Schema Browser or Editor window data grid? Right now it only shows (HUGECLOB) (HUGE CLOB). ...

Product(s): Toad for Oracle
Last Updated On: 6/11/2018
(4 Ratings) 22355 views
Assistance with the creation of ldap.ora file for connection using the LDAP tab (254995)

Help to create a ldap.ora file to connect to databases via Oracle Internet Directory or Active Directory. In general, if connection is to be made via the LDAP tab, then your Network Administrator or DBA should supply this file. This ...

Product(s): Toad for Oracle
Last Updated On: 6/8/2018
(0 Ratings) 60 views
Error "Access violation at address ..in module 'QP5CA.dll'. Read of address..." when typing in Editor (257877)

Loaded a package into the Editor. Started editing the Package Body and received the following error: "Access violation at address ..in module 'QP5CA.dll'". WORKAROUND. Go to View | Toad Options | Code Analysis | uncheck 'Check Rules as you type'. STATUS. ...

Product(s): Toad for Oracle
Last Updated On: 6/6/2018
(0 Ratings) 3 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. It opens normally if the output is ...

Product(s): Toad for Oracle
Last Updated On: 6/5/2018
(3 Ratings) 210 views
NCHAR literal replacement changes NCHAR character from N to U in the Schema Browser Script tab (257115)

In Toad, if you run the following statement: CREATE OR REPLACE FORCE VIEW TESTVIEW AS select N'Hello world!' as column1 from dual; If you view it in the Schema Browser | Views | TESTVIEW | Script tab, the NCHAR character changes automatically (from N to U ...

Product(s): Toad for Oracle
Last Updated On: 5/31/2018
(0 Ratings) 1 views
Get Access Violation error viewing table with ST_GEOMETRY datatype (257094)

An Access Violation error is returned when viewing a table with a ST_GEOMETRY datatype in the Schema Browser. WORKAROUND: None. STATUS: Waiting for a fix to be released in a future version of Toad for Oracle. This ...

Product(s): Toad for Oracle
Last Updated On: 5/31/2018
(0 Ratings) 1 views
Toad for Oracle GUI is incorrectly displayed when 150% font size is used. (255694)

When Toad for Oracle window is maximized it shows only part of the screen area, cca 1/2 to 1/4 o the area is broken. Sometimes this happens even if the window is not maximized. Windows Visual effects Switch off Windows visual effects. ...

Product(s): Toad for Oracle
Last Updated On: 5/31/2018
(0 Ratings) 12 views
Workspaces are incorrectly transferred between versions of Toad for Oracle. (256081)

When upgrading from the previous version of Toad for Oracle Workspaces are incorrectly transferred. Corrupted Workspaces.dat or using of tabs which are no longer available in the current version of Toad for Oracle. Please ...

Product(s): Toad for Oracle
Last Updated On: 5/31/2018
(0 Ratings) 15 views
How to export results direct to CSV format in Toad for Oracle (58570)

How do I export query results direct to CSV format in Toad for Oracle? To do it repeatedly use Automation Designer: 1) Create a new app and add the action Export Set 2) Open properties of the Export Set and set the output format to Delimited and configure output as needed. ...

Product(s): Toad for Oracle
Last Updated On: 5/31/2018
(2 Ratings) 17531 views
Browsing for packages or package bodies takes a long time in Toad 12.x if there are many objects (256914)

When browsing for packages, the following query is run by Toad 12.11: ==== with PACKAGES as (Select :own owner, object_name, object_type, decode(status, 'VALID', 'V', 'I') status, last_ddl_time ...

Product(s): Toad for Oracle
Last Updated On: 5/30/2018
(0 Ratings) 4 views
License Key is correct / valid, but still gets the error: "You must enter a valid license and site message in order to continue". (255663)

Issue happens during the Toad for Oracle installation. License Key is new, correct, and valid, but still gets the error: "You must enter a valid license and site message in order to continue". User has not yet clicked on the 'Add' button. User went straight to clicking the 'Next' button. ...

Product(s): Toad for Oracle
Last Updated On: 5/29/2018
(1 Ratings) 252 views
Getting "Require Built-in Adminstrator" message during installation (256719)

When installing, the following message is shown in the Prerequisite Checks window. "Require Built-in Adminstrator=> Failed with warning". Need administrator privileges on that machine to install. Make sure Toad is being installed ...

Product(s): Toad for Oracle
Last Updated On: 5/29/2018
(0 Ratings) 8 views
Keyboard shortcuts not working in the 'New Connection' window in Toad v13 (256697)

In Toad v13, some of the keyboard shortcuts of the New Connection dialog box are no longer working. ALT-d: Should move the cursor to "Database". Instead this now opens the Database menu in Toad. ALT-u: Should move the cursor to "User". ...

Product(s): Toad for Oracle
Last Updated On: 5/29/2018
(1 Ratings) 7 views
Export Dataset in version 13 works differently to version 12 and can break the import statements with error 'ORA-12899: value too large for column' (256679)

When using Export Dataset to export some data into insert statements, the way carriage returns are handled has changed. They are now encoded as "CHR(13)||CHR(10)" within text fields. This causes an issue where previously ...

Product(s): Toad for Oracle
Last Updated On: 5/29/2018
(0 Ratings) 8 views
Team Coding User Setting 'Check-in object on closing' is doing an undo check-out instead of checking in. (239055)

Team coding is configured correctly and integrates with a 3rd party VCS. Checking out/in using the toolbar works OK. However: 1. Go to the User Settings page of the Team Coding Configuration window and enable "Check ...

Product(s): Toad for Oracle
Last Updated On: 5/28/2018
(0 Ratings) 138 views