Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

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 6521
"Compare to" contextual menu does not show all tabs of the editor for comparison if those tabs opened have the same filename (229977)

When using the "Compare to" you can compare the current script/query with other scripts already saved. When doing the compare with existing scripts that has the same filename, the "Compare to" feature does not show all the tabs for comparison. Defect WORKAROUND: None. ...

Product(s): Toad for Oracle
Last Updated On: 6/24/2017
(0 Ratings) 66 views
Toad does not retain a query in Saved SQL if the query was not run at least one time (230765)

When a query is wrote in the editor you can save it for later in Saved SQL. But, if Toad closes unexpected and the query was not run at least one time, the query will not be saved automatically by Toad. Defect WORKAROUND: None. STATUS: ...

Product(s): Toad for Oracle
Last Updated On: 6/23/2017
(0 Ratings) 30 views
SQL Loader ignoring Timestamp mask (152936)

Entering the Date Mask in the SQL Loader wizard in Toad is being ignored in the Control File. Example: Toad creates the following CTL file when specifying a TIMESTAMP datatype: INTO TABLE "GEORGE"." TIMES". INSERT. FIELDS TERMINATED BY ','. ...

Product(s): Toad for Oracle
Last Updated On: 6/23/2017
(0 Ratings) 1375 views
What should be done if antivirus software considers Toad.exe as a virus? (110097)

What do I have to do if my antivirus software (McAfee, Sophos,Trend Micro etc) considers Toad.exe as a virus? Please contact the company of the antivirus and let them know that Toad.exe is a benign tool. In case they need ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 6/22/2017
(0 Ratings) 1316 views
New installation of Toad for Oracle and Toad Data Point shows a trial key embedded inside (59493)

A new installation of Toad for Oracle and Toad Data Point (formerly known as Toad for Data Analysts) was done on a clean machine. Opening Toad Data Point for the first time will show a trial key (License Tab). After registering ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 6/22/2017
(0 Ratings) 5480 views
Import Table data: support input variables for file name (230321)

When using Folder Iterator, it is possible to filter CSV files and receive their path in a variable (eg %iter1%), but if this variable is used as a source file for the import, the automation task fails. WORKAROUND: None. SOLUTION: ...

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 2 views
Toad for Oracle generates incorrect SELECT statement. (230319)

When the SELECT is generated for the table from Project in Poroject manager, the select statment includes columuns which are not in the table. These columns are not mentioned in object details. If the select statement is generated ...

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 3 views
Formatter indents first line by 1 when comment or hint is used. (230314)

When a comment or hint is used the first result line (here: 'abcdef') is indented one column to the left of the following lines. Example: SELECT /*+ hint */ 'abcdef', 'bsdfjsdlafkjflasfkjdslffjlsdja', 'xsalkfjsdalfjdaslfjdls', 'yasjkdfsdjfl', 'zklfjdslfjdaslfsajdfl' FROM dual; WORKAROUND: ...

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 5 views
Describe table shows incorrect DDL for a table created with PERIOD FOR clause. (230317)

Describe table shows incorrect DDL for a table created with PERIOD FOR clause. WORKAROUND: None. SOLUTION: Waiting for a fix in a future release of Toad for Oracle.

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 2 views
Toad handing while using Export File Browser on large file (230316)

When Toad wants to look into dmp files using Export File Browser it hangs with large files. WORKAROUND: None. SOLUTION: Waiting for a fix in a future release of Toad for Oracle.

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 2 views
TeamCoding: Undo check out does not work properly (230315)

1. Connect to DB 2. Open a procedure in editor 3. check-out 4. Change some Sourcecode 5. compile (F9) 6. undo check-out. The result is: 1. The source is available for check-out 2. The source has changed (compared with the source before check-out). ...

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 2 views
Files, Directories, and Aliases tab do not display data from ASM storage. (230318)

Files, Directories, and Aliases tab do not display data from ASM storage when connected via ASM Manager. WORKAROUND: None. SOLUTION: Waiting for a fix in a future release of Toad for Oracle.

Product(s): Toad for Oracle
Last Updated On: 6/21/2017
(0 Ratings) 2 views
Is there a way to connect Toad for Oracle with DB2 database? (228098)

Is there a way to connect Toad for Oracle with DB2 database? WORKAROUND: Toad for Oracle only works with Oracle databases. If you want to connect to a DB2 database, Toad Data Point / Toad Intelligence Central or Toad for DB2 are the appropriate programs. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 25 views
Is it possible to compare two databases with Toad for Oracle? (230586)

I need to compare two different Oracle databases .Is it possible to do this with Toad for Oracle? Yes, that is possible : You can compare database-level objects such as tablespaces, roles, users, and so on between databases or Database Snapshot files. ...

Product(s): Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 8 views
Is there a way to identify the entire line of a connection with a color? (227909)

Toad for Oracle allows to define a color for a connection. This information can be found in one of the columns of that connection. Is there a way to place the color for the entire line of that connection? WORKAROUND: Toad currently ...

Product(s): Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 6 views
When configuring MyToad, the Dropbox connection doesn't work (226356)

When configuring MyToad feature, the connection to Dropbox account doesn't work. Toad for Oracle does not support Dropbox sync starting on version 12.10. WORKAROUND: You can retrieve older files by logging into Dropbox directly. ...

Product(s): Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 3 views
After performing a Data Compare, no data or column headers are showing in the tabs (230552)

After clicking the Perform Comparison button, in the Data Compare feature, no data or column headers are showing in the 'Source Only', 'Target Only', or 'Differences' tabs. A record count is done and shown in the 'Row Counts Differ' tab, but that is it. ...

Product(s): Toad for Oracle
Last Updated On: 6/19/2017
(0 Ratings) 10 views
‘Ctrl + S’ and ‘File | Save File’ opens the Export Dataset window instead of a window to save a file at some directory path location. (230535)

'Ctrl + S' and 'File | Save File' opens the Export Dataset window. Save File opens the Export window, instead of prompting to save to a file in some folder location. TESTS: Using the 'Save File' icon on the Editor Toolbar (or any ...

Product(s): Toad for Oracle
Last Updated On: 6/16/2017
(0 Ratings) 4 views
Error when connecting: "The procedure entry point (name) could not be located in the dynamic link library (name.dll)." (134232)

The following error is displayed when connecting to a database. Unable to connect. "The procedure entry point ons_init_wconfig_ctx could not be located in the dynamic link library oraons.dll.". or. "The procedure entry point knclgLcrRowGetBindVariables ...

Product(s): Toad for Oracle
Last Updated On: 6/16/2017
(1 Ratings) 5542 views
What is GIT? Does Toad for Oracle support it? (112077)

What is GIT? Does Toad for Oracle support it? Starting with Toad for Oracle 12.1, GIT is supported. GIT is a highly popular distributed version control system. There are some significant differences in the work flow of a distributed ...

Product(s): Toad for Oracle
Last Updated On: 6/16/2017
(1 Ratings) 2183 views
How to undock/dock/move panes to the side of the main Toad layout. (33341)

How can a window be docked/moved to the side of the main Toad layout? There are some panels in Toad, like SQL Recall, Object Palette, Output, etc that can be opened. Can the position of these panels be changed? If it's a floating window, how can it docked to the side? ...

Product(s): Toad for Oracle
Last Updated On: 6/15/2017
(1 Ratings) 3654 views
Does Toad have a version that is supported on Mac? (26230)

Does Toad support the Apple Mac platform? Commercial versions of Toad do not formally support use on Mac. There is a new option for Mac users. Please check out Toad-Mac in the Toad World community. http://www. toadworld.com/products/toad-mac-edition/default.aspx. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/15/2017
(0 Ratings) 2423 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: 6/14/2017
(0 Ratings) 21112 views
How to customize more the filter in Schema Browser in Toad? (230369)

How to customize more the filter in Schema Browser in Toad? For example how to customize the filter for different table names? 1. Open the filter located in the Schema Browser in the local toolbar area. 2. Click on 'Custom Filter (Use View/Edit Query to adjust). See images below ...

Product(s): Toad for Oracle
Last Updated On: 6/13/2017
(0 Ratings) 7 views
Using a commercial key returns "This installer does not accept commercial license keys, please provide a trial license key" (54989)

Entering a commercial license key returns: "This installer does not accept commercial license keys, please provide a trial license key". This message is also known as: Invalid Trial Key. Commercial license key are not accepted in a Trial Version of Toad for Oracle. ...

Product(s): Toad for Oracle
Last Updated On: 6/9/2017
(1 Ratings) 4013 views