Chatee ahora con Soporte
Chat con el soporte

Toad for Oracle 14.1 - Release Notes

Resolved Issues

The following is a list of issues addressed and enhancements implemented in this release of Toad for Oracle.

Toad for Oracle 14.1

The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.

Issue ID Link to Forum Post Resolved Issue
TMB-2737  

Code Insight: Toad hangs in some cases

TOR-1205  

Formatter: "List Arrangements" option of Wrapped is non-functional

TOR-1644  

Automation Designer: Can't add action to app if the app node has lost focus in the left side treeview

TOR-1820 link

Toolbars: Connection bar does not update to identify the active session in some cases

TOR-1938  

Object Search: Table partitions and subpartitions are not found

TOR-2199  

Code Analysis: Slow to analyze some code when rule 2128 is included

TOR-2346  

Code Insight: List is blank when typing the first character of a valid column name

TOR-2669  

Application: Ctrl+Tab and Ctrl+Shift+Tab does not activate some windows when Toad is in SDI window mode

TOR-2770  

Workspaces: Connection and window order is not retained when saving workspaces

TOR-3071  

Editor: Execute as Script throws an Access Violation when the connection has closed due to timeout

TOR-3314  

SQLNET Editor: ESC key does not close the window

TOR-3390  

Workspaces: Cannot close Toad after loading a saved workspace that opens a Describe Objects window

TOR-3598 link

Data Grids: Various dataset navigation issues with the nested table popup editor

TOR-4593  

Team Coding: Team Coding Manager dock panel is blank if in an unpinned/hidden state when connecting to database

TOR-4651  

Editor: Execute as Script grids do not use sequential numbering in the tab captions when SELECT statements producing no rows are in the script

TOR-4653 link

Editor: Connection shown in the title bar and status bar can get out of sync in some cases when changing the session associated with the window

TOR-4654  

Editor: Executing SELECT against a table with a user-defined type column crashes if the type contains an integer value greater than 2147483647

TOR-4655 link

Editor: Execute as Script does not cancel promptly when the script executes long running PL/SQL

TOR-4656  

Data Grids: Access Violation occurs when editing a field via the popup editor if the connection has terminated

TOR-4657  

Data Grids: Access Violation occurs when posting edits directly in the grid if the connection has terminated

TOR-4658  

Editor: Executing SELECT against a table with a user-defined type column throws an error if the type contains a SMALLINT datatype

TOR-4659  

Data Grids: Access Violation occurs when the next block of results is fetched if the connection has terminated

TOR-4660  

Schema Browser: Access Violation or Invalid Pointer Operation occurs when viewing the data in a Queue Table

TOR-4662 link

Team Coding: Materialized Views don't get versioned in the VCS when recreated

TOR-4675  

Editor: Editing large text is slow if Sensitive Data Awareness is enabled

TOR-4677  

Compare Schemas: Access Violation occurs when closing the compare text dialog while it is still loading

TOR-4678  

Toolbars: Connection bar images do not update to indicate lost connection

TOR-4679 link

Rebuild Table: VALIDATE/NOVALIDATE constraint states are excluded when the table has a Foreign Key constraint

TOR-4680  

Login: Custom fields are removed from the recently used connections grid when the connections are grouped by custom field(s) and the view style is changed

TOR-4690  

Quest Script Runner: Favorite Folders aren't being retained after restart

TOR-4692  

Code Analysis: Results exported to comma delimited text do not use the same precision for Halstead Volume and Maintainability Index as shown within Toad

TOR-4693  

Team Coding: Error converting VCS timestamps on machines with custom time formats when viewing the debug log

TOR-4694  

Database Browser: Access Violation occurs when selecting the node for a database having no connection

TOR-4702 link

Explain Plan: Viewer (tree style) does not support Adaptive Plans

TOR-4705 link

Compare Schemas: Byte/Char differences are not identified/synced when the "Include Byte/Char when creating DDL scripts" option is unchecked on the Datatypes page in View|Options

TOR-4709  

Roles/Editions: On Fail behavior (View | Options | Oracle | Roles and Editions) does not work when the schema lacks privileges on the Role or Edition

TOR-4710 link

HTML Database Doc Generator: Objects privileges granted to Roles are not shown

TOR-4713  

Schema Browser: Comparing CDB Resource Plans does not check "CDB Resource Plans" in the Compare Databases window

TOR-4714 link

Application: Various modal windows are pushed to the background when they should remain as the top-most window

TOR-4715  

Import Table Data: Error occurs when importing from MS Access file having erroneous data

TOR-4717 link

Data Grids: Popup editor closes immediately upon opening when invoked from the last row in the dataset

TOR-4718  

Data Grids: Duplicate Row does not work if the table has an IDENTITY column

TOR-4722  

Editor: Team Coding prompt to check-in occurs twice when closing the tab in some cases

TOR-4730  

Editor: Overwriting selected text causes Toad to hang

TOR-4731 link

Compare Objects: Object privileges granted to Roles are excluded

TOR-4733  

Alter Table: Locations and Default Directory are not editable when altering an External Table

TOR-4734 link

Schema Browser: Can't rename Datafile in non-Enterprise editions of Oracle

TOR-4739  

Connections: Oracle 10g RAC connections are not detected

TOR-4740  

Tablespaces: Access Violation occurs when clicking in the Tablespaces window quickly as it is opening

TOR-4741  

Automation Designer: Access Violation occurs when running actions against multiple connections if the option to highlight table names is checked (View | Options | Editor | Display)

TOR-4742  

Copy Table Data: Access Violation occurs in some cases

TOR-4743 link

Editor: Saving a file that was split (View | Options | Editor | Open/Save) saves the file using ANSI encoding

TOR-4745  

ADDM Report: "'' is not a valid floating point value" error occurs

TOR-4746 link

Alter Tablespace: Floating point values are not accepted when altering the size of a datafile

TOR-4747  

Login: Access Violation occurs when testing a saved connection if no Oracle clients are configured

TOR-4748  

Data Grids: Error occurs when pasting into a read-only grid in some cases

TOR-4749 link

Data Grids: Export Dataset | "Create insert statements for selected rows" is slow to load

TOR-4750  

Connections: Various errors within Toad for schemas that are limited by a Profile having sessions_per_user set to 1

TOR-4751  

Quest Script Runner: Unable to login with a schema configured for External Authentication

TOR-4752  

Sensitive Data Protection Search: Previously used settings aren't being remembered

TOR-4754 link

Application: Some message dialogs are shown on the wrong monitor

TOR-4759  

Schema Browser: Compiling invalid objects does not refresh the window to show the new state

TOR-4760  

Editor: Prompt to reconnect a connection that has terminated does not occur when compiling PL/SQL

TOR-4762  

Data Grids: Single Column Export is disabled in some cases when it should not be

TOR-4763  

Editor: Backup file recovery does not work for tabs that were loaded from a previous backup recovery

TOR-4770 link

Connections: Ending a connection that has been terminated results in a prompt to reconnect in some cases when the "Execute queries in threads" option is checked (View | Options | Oracle | Transactions)

TOR-4772 link

Data Grids: Changes made to a newly inserted row are cancelled when entering invalid data into a TIMESTAMP field

TOR-4774  

Export Dataset: NULL values are excluded in some cases when the "Display large numbers in Scientific Notation" option is unchecked (View | Options | Data Grids | Data)

TOR-4777  

PL/SQL Templates: Access Violation occurs when creating a new object from template if the path to the template is invalid (View | Options | PL/SQL Templates)

TOR-4779  

Rebuild Multiple Objects: Access Violation occurs when closing the window while it is loading Lob Segments

TOR-4780  

Query Builder: Wrong error dialog is used when assigning null to a field having NOT NULL constraint in the data grid

TOR-4781  

Advanced SQL Optimization: "'value' is not a valid floating point value" error when sending View to Quest SQL Optimizer if Toad and Windows have differing decimal and thousand separator values

TOR-4782  

Application: When setting a temporary folder to a path that is inaccessible to the current Windows account the following errors occur: Access Denied exceptions and Toad will not start after being closed (View | Options | General)

TOR-4783  

Login: Wrong error dialog is used when trying to save changes made in either the TNSNames Editor, SQLNET Editor, or LDAP Editor if the current Windows account does not have write access to the respective Net Configuration File for those windows

TOR-4786  

Login: Exporting saved connections excludes all passwords if the global "Save passwords" option is unchecked on the login window

TOR-4787 link

Schema Browser: Adding a constraint to an existing View uses ALTER TABLE instead of ALTER VIEW in the generated SQL

TOR-4790  

Login: Importing connections into a new install of Toad does not allow for including passwords associated with the connections

TOR-4791  

Application: Proxy Automatic Configuration (PAC) scripts are not handled (see Known Issues)

TOR-4793  

Automation Designer: Access Violation occurs when executing an Import Table Data action after opening its properties dialog and closing the dialog

TOR-4796  

Alter Tablespace: Backspace key does not work when editing the size of a datafile

TOR-4798 link

Schema Brower: Materialized View script options dialog does not retain the "Add to refresh group after create, subtract before delete" option

TOR-4801  

Object Palette: GUI control alignment is broken in some cases

TOR-4815  

Session Browser: Not tolerant of missing fields in V$SESSION after an unfinished Oracle database upgrade

TOR-4818  

Data Grids: Popup editor for BFILE data will work once and subsequent attempts to show the dialog do not work

TOR-4819 link

Connections: Closing Toad with connections that have been terminated results in a prompt to reconnect in some cases when the "Execute queries in threads" option is checked (View | Options | Oracle | Transactions)

TOR-4821  

Editor: NCHAR string literal corruption when executing SQL against non-Unicode databases (see Known Issues)

TOR-4825 link

Data Grids: Cannot edit data for tables having a period in the schema name, e.g. "QUOTED.USER"

TOR-4826 link

Data Grids: Erroneous data appended after string literals in some cases

TOR-4833 link

Describe Objects: Current connection's schema name is prepended to the object name when describing objects through a database link

TOR-4837 link

Editor: Duplicate prompts to reload files that have been deleted externally when the "Prompt for reload on activation..." option is checked (View | Options | Editor | Open/Save)

TOR-4840  

Schema Browser: The selected table loses focus after a "Refresh all" when the Browser Style is set to Treeview

TOR-4841  

Export Dataset: Exporting a new sheet to an existing Excel File which contains a pivot table causes file corruption

TOR-4843  

Editor: Opening the data grid popup editor repeatedly for grids in multiple Editor tabs can lead to Toad hanging in some cases

TOR-4847  

Connections: Slow connect times on some databases due to checking for Team Coding's installation state

TOR-4848 link

Editor/Quest Script Runner: Execute as Script does not support bind variables that are declared and set using a single statement, e.g. var bind_var VARCHAR(10) = 'foo';

TOR-4895  

Data Grids: Access Violation occurs when using Ctrl+Insert to copy records if there is no active connection

TOR-4896  

Project Manager: Access Violation occurs when Ctrl+RightClick if there are no focused nodes

TOR-4897  

Master-Detail Browser: List Index Out of Bounds occurs when cancelling the Select Detail Table dialog in some cases

TOR-4898  

Application: Unexpected error dialogs are shown in various places when invalid or inaccessible directories are set as output destinations

TOR-4901  

Schema Browser: Argument out of range error occurs upon Ctrl+C or typing in the Tables | Referential tab when no node is selected


Trace File Browser: Argument out of range error occurs upon Ctrl+C when no node is selected

TOR-4904  

Schema Browser: Access Violation occurs upon Ctrl+Click on an object name in the Script tab when Favorites is active on the left hand side

TOR-4905  

Schema Browser: List Index Out of Bounds occurs when refreshing the left side if a package having a body and no spec is selected and the Browser Style is set to Treeview

TOR-4906  

Import Table Data: List Index Out of Bounds occurs when the import source is "MS Windows clipboard" with some clipboard content

TOR-4908  

Explain Plan: Errors occur if any of the configuration files are corrupt

TOR-4909  

Team Coding: Cannot focus disabled or invisible window error occurs when editing SVN WebDAV configuration

TOR-4917  

Data Grids: Wrong error dialog is used when filtering on a date column and entering an invalid date value

TOR-4923  

Schema Browser: Error occurs when recovering a Tablespace

TOR-4924  

SQLNET Editor: Error occurs upon opening if sqlnet.ora has comments following some parameters and on the same line

TOR-4926 link

Session Browser: INST_ID invalid identifier error occurs when viewing the Current Statement | Explain Plan if connected to RAC and the "Use RAC views" checkbox is checked

TOR-4927  

Editor: Access Violation occurs when shutting down Toad after using Add Breakpoint on the Breakpoints tab if the caret is on an empty line and the Script Debugger is the set as the active debugger

TOR-4929 link

Team Coding: Closing an inactive Editor tab results in a prompt to check-in the current object of the active tab

TOR-4930  

Copy Table Data: Access Violation occurs when shutting down Toad in some cases following multiple Copy Table Data operations

TOR-4931  

Alter Table: Access Violation occurs when clicking Cancel immediately after clicking OK

TOR-4938  

AWR Browser: Access Violation occurs and incorrect legend items are shown then the "Overall Phys Reads and Writes" chart is active

TOR-4939 link

Schema Browser: LOGGING_FAILED_RUNS is not supported when viewing scripts for a Scheduler Job Classes


Create/Alter Job Class: LOGGING_FAILED_RUNS is not supported

TOR-4942  

Database Browser: Various issues with drag/drop behavior

TOR-4945  

Analyze Objects: Access Violation occurs when closing the window before it has finished loading objects

TOR-4946  

Schema Browser: Access Violation occurs when closing the window quickly after a refresh if the objects have not finished loading

TOR-4947  

Schema Browser: Access Violation occurs when selecting a table that has UNDEFINED datatype if the Data tab is active

TOR-4948 link

Editor: Toad hangs when using the mousewheel to scroll if a text selection occurs within a collapsed folding region

TOR-4952  

Schema Browser: Access Violation occurs when using the right or left arrow key when the left side packages tree has focus, but there is no selected node

TOR-4953  

Schema Browser: DataController not in GridMode error occurs when using Export Dataset | "Create insert statements for selected rows" and the Memory Sorting grid option is checked

TOR-4954  

Connections: Access Violation occurs when clicking the End Connection button if more than one connection exists and a filter in the Select Session grid excludes the active connection

TOR-4955 link

Generate Schema Script: Triggers are not included in the script when Extract | Object Types specifies Triggers and Views and Filters | By Name specifies specific triggers and views

TOR-4956 link

Schema Browser: "Team Coding Status" and "Collection Name" columns are not shown when viewing the all tables detail grid and connected to a Team Coding enabled database


Schema Browser: The "View" column header caption changes to "Table" after refresh when viewing all views detail grid and connected to a Team Coding enabled database

TOR-4958  

Schema Browser: Viewing all sequences detail grid incorrectly lists "Cache Size" value in the "Increment By" column

TOR-4959 link

Document Recovery: Poor performance when selecting a large backup in the Recover Documents window

TOR-4960 link

HTML Schema Doc Generator: "Create Table List File" excludes newlines when a View has a name exceeding 30 characters


HTML Schema Doc Generator: Views having names exceeding 30 characters are not included in the report


HTML Schema Doc Generator: Report shows "is referenced by" instead of "references"

TOR-4962 link

Editor: Unable to end connection or close Editor when debugging and the debug session has terminated

TOR-4978  

Schema Browser: Unable to retrieve details for packages having an OBJECT_ID greater than 2147483648

TOR-4979  

Code Analysis: "Test selected rule" does not flag all occurrences in the Code Analysis Rules window (View | Options | Code Analysis | General | Edit Rules)

TOR-4981 link

Toolbars/Menus: Ctrl+P continues to print even when the shortcut has been cleared (View | Options | Toolbars/Menus | Shortcuts)

TOR-4984  

Schema Browser: Access Violation occurs when dropping a package if a node beneath "Local Subprograms" is selected

TOR-4987  

TNS Error Assistant: Connection failures due to Oracle client incompatibility are not caught, e.g. Oracle client 19.10 does not work on Windows 7

TOR-4997  

Describe Objects: Blank window remains open when describing a table the connected schema has no privileges on

Toad for Oracle 14.0

The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.

Issue ID Link to Forum Post Resolved Issue
TMB-1562   Export Dataset to Excel file results in spreadsheet corruption with certain data.
TMB-2229   Viewing a package in the Schema Browser hangs Toad if the code contains mixed usage of space and tab characters for indentation.
TMB-2284   Exporting table DDL will raise an ORA-00904 exception if the "Audit statements" option is included and the database's COMPATIBLE initialization parameter is set to a version less than the database version.
TMB-2355 link Database Monitor graphs display large negative spikes when values in V$SYSSTAT reach their maximum and roll back to 0.
TMB-2511 link Code Insight can be positioned or scaled incorrectly in a multiple monitor setup where the monitors have differing pixels per inch.
TMB-2545 link The Set Variable action in the Automation Designer does not allow for assignment to the value of another variable.
TMB-2584 link Editor, Auto Replace does not make replacement upon Tab key press when the tab mode is set to spaces.
TMB-2587   Analyze Objects, Global Preferences do not update when the connection is changed.
TMB-2594   Closing a session does not remove the associated Connection Bar button in some cases.
TMB-2600   Code Analysis, SQL Scan does not display results.
TMB-2621 link Creating a MATERIALIZED VIEW from the Schema Browser does not add the view to Team Coding for controlled schemas.
TMB-2654   Importing a Code Analysis rule set containing custom rules omits the custom rules if they are new to that installation of Toad.
TMB-2658 link Reordering Connection Bar buttons does not always save the layout.
TMB-2662 link The Unit Test Manager throws an Access Violation exception when a package decorated with utPLSQL annotations is compiled in the Editor.
TMB-2687   Search as you type is non-functional in the Object Palette's schema chooser.
TMB-2696 link Database Health Check does not run against all connections when multiple connections are configured and the health check is executed from command line or from the Automation Designer.
TMB-2697   Team Coding allows multiple people to check out the same object in a specific circumstance.
TMB-2718 link Database Health Check raises exception when the "list segments with < n%..." check is included and its rules are satisfied.
TMB-2726   Export Dataset does not include "null" text for null fields when the "Include null text" option is used with the Fixed Field Spacing output format.
TMB-2728   An exception is raised when creating the Space History tables in the TOAD schema from the Administer Tablespaces window on Oracle Database 19c.
TMB-2731 link The list of objects goes blank when viewing Favorites in the Schema Browser after popping the window out.
TMB-2748 link The Backspace key does not delete TIMESTAMP data from the data grid.
TMB-2762 link Rebuild Multiple Objects does not restore the NOCACHE cache mode.
TMB-2776   Executing SQL from the Editor with the Auto Trace option enabled may show 0's for all statistics when logged in as SYS.
TMB-2801 link Script execution using the "SHOW ERRORS" command does not show errors for PL/SQL that is fully qualified to include the schema.
TMB-2822   Failure to execute a SELECT statement joining two or more tables having ambiguous columns when an XMLTYPE column is also included in the result set.
TMB-2829 link Schema Browser, Clone/Copy schema does not automatically enclose password in double quotes when required.
TMB-2841   When viewing Tablespaces in the Schema Browser treeview display mode, refreshing the detail view (right side of browser) first loads summary data for all tablespaces before returning to the detail panel you had activated.
TMB-2842   When using the "Top to Bottom" layout in the Session Browser the height distribution between the top and bottom areas of the window is not remembered.
TMB-2844   Changing the active session does not always return to the last activated window for that session.
TMB-2908   Import Table Data may cause Toad to stop responding when importing from Access file (.mdb) when LOB columns are involved.
TMB-2935 link Refreshing the Schema Browser will refresh the window twice when more than one Schema Browser window is open.
TMB-2989   When exporting Table DDL with the "All LOB Parameters" option enabled, the RETENTION parameter is omitted from the DDL if it is set to the default value.
TMB-2996 link Automation Designer, Actionable Query action, converts PL/SQL to uppercase.
TMB-2997   Generate Schema Script places INDEX DDL before corresponding TABLE DDL when the "File will be used for HTML schema doc generation" option is enabled (Output | Snapshot Files).
TMB-3012 link Alter Credential does not allow for the scheduler credential password to be changed.
TMB-3013 link Export DDL generates an incorrect script for users having IDENTIFIED BY VALUES clause with a password containing a space.
TMB-3015   The Data Grid Popup Editor throws an Access Violation exception when it's open and data is deleted from the grid.
TMB-3020   In the Editor, executing an anonymous block utilizing DBMS_SQL.RETURN_RESULT() does not return a result. "Execute/compile statement at caret (F9)" and "Execute as script (F5)" are both affected.
TMB-3067   When viewing a tablespace in the Schema Browser the status is not reported properly in some cases. Also, setting an offline tablespace to online in the Alter Tablespace window does not set the tablespace to online.
TMB-3088 link Maximizing Toad from a minimized state does not restore the active window in some cases.
TMB-3089 link Team Coding does not reflect an object's locked status when it has been locked by an external application.
TMB-3091   Team Coding does not obey the Editor's "Substitution Variable Prompting" option when differences are found between the VCS and database versions of the source code.
TMB-3105   Compare Data throws ORA-01446 when comparing complex views.
TMB-3107 link Session Browser shows duplicate parallel slaves in some cases.
TMB-3132   Auto Optimize SQL window throws an ORA-01005 exception when connected as a globally authenticated user.
TMB-3143 link Export Dataset quotes null values when the "Double quote strings" and "Single quote numbers" options are used with the Delimited Text output format.
TMB-3144 link Toad does not remember the window usage order, i.e. closing a window does not activate the next, most recently used window.
TMB-3194 link Poor performance opening large XML files in the Editor.
TMB-3195 link Highlighting of matching braces in the Editor can perform poorly in some cases, especially with large XML that is compacted so that it exists on a single line.
TMB-3213   Toad will throw an exception or crash when trying to select a workspace from the workspace chooser when two or more have the same name.
TMB-3214 link Data Grid Popup Editor does not restore when it is minimized and a grid cell is double-clicked.
TMB-3235 link Export Dataset using the Excel File output format does not respect variables in the "Sheet name," e.g. %ActiveEditorTabCaption%.
TMB-3247   Compare Data performs poorly when comparing LOBs across multiple sessions.
TMB-3266   After loading a saved workspace, the Editor prompts to reload files unnecessarily when the "Prompt for reload on activation if timestamp has changed" option is enabled.
TMB-3286 link Rebuild Multiple Objects window generates invalid SQL when rebuilding LOB Segments for columns of type SDO_GEOMETRY.
TMB-3288 link Generate Data chooses the incorrect column when referencing foreign columns for values in some cases.
TMB-3289 link In Analyze Objects, the final page showing all objects to be analyzed does not adjust the column widths optimally.
TMB-3301 link Compare Data uses the wrong session for one of its queries when comparing data between two different sessions.
TMB-3308 link Team Coding Team Projects does not allow for escaping wildcard characters (_, %, ?, *) when specifying include/exclude object type filters.
TMB-3310 link Session Browser throws List Index Out of Bounds exception when activating the Explain Plan tab when the "Fetch details" checkbox is in the unchecked state.
TMB-3315   Switching the active workspace causes the Editor to throw an Access Violation exception in some cases.
TMB-3364 link Team Coding adds collation options to all string column and table DDL.
TMB-3375   Connections to Team Coding controlled databases are slow with a large number of controlled objects.
TMB-3377   The "SQL area" data series shown in the Database Monitor, Miss Ratios graph is ambiguous.
TMB-3379 link Workspaces do not support Describe windows.
TMB-3381 link Drag/drop tabs in the Editor to reorder them causes the Navigator panel to go blank.
TMB-3384 link In the Data Grid, double clicking a cell containing nested table data shows the nested data on the first invocation of the dialog, but not on subsequent invocations.
TMB-3393 link Test Connection (Reconnect) does not allow for entering an updated password when it has been changed externally, setting a new password when it has expired, or unlocking an account that has been locked externally.
TMB-3402   Alter Job produces invalid SQL when changing the "Subsequent Executions" value in some cases.
TMB-3430 link Generate Schema Script lacks option to create filenames in lowercase.
TMB-3435 link There is no way to see a view's invisible columns when browsing the columns or the data of a view from the Schema Browser.
TMB-3447 link Data Grids resulting from "Execute Script (F5)" in the Editor are obscured by a large tooltip/hint showing the SQL that produced the data.
TMB-3448   Code Analysis produces incorrect CRUD matrix for MERGE statements.
TMB-3450   Toad cannot be shared as an application/window during a Microsoft Teams call.
TMB-3464 link Session Browser shows duplicate parallel slaves in some cases.
TMB-3468 link DB Health Check produces script containing duplicate indexes having the same name when the "List foreign keys with no matching index on child table" check is enabled in some cases.
TMB-3471 link DB Health Check produces blank output when using the check(s) involving the FILESYSTEMIO_OPTIONS parameter in some cases.
TMB-3472 link HTML Database Doc Generator is missing some fields from the V$DATABASE table in the report output.
TMB-3477   Support Bundle lists a defunct module, QP5CA.dll.
TMB-3493   Shortcut keystrokes are not handled properly when Citrix Workspace App is installed with the "App Protection" option enabled during its installation.
TMB-3537   Toad 64-bit on Windows 10 and Windows Server 2016 cannot make database connections when Dynatrace application monitoring software is installed.
TMB-3545 link Export Dataset does not detect schema or table name properly when the "Cast XMLTYPE to CLOB" option is set to XMLSerialize on the "Data Grids | Data" page in Options.
TMB-3549 link Generate Schema Script includes compression options for tables in the output script when the "Compression" option is set to "Never" (Options | Storage | Compression) and when any tablespaces are included (Extract | Object Types).
TMB-3557 link Redo Log Manager gives incorrect group membership recommendation when the members reside on high redundancy disk groups.
TMB-3559 link Describe window can throw an Access Violation exception in some race conditions.
TMB-3560 link In the Data Grid, double clicking a cell containing cursor data shows the data on the first invocation of the dialog, but not on subsequent invocations.
TMB-3576 link Export Dataset erroneously includes identity columns when the Insert Statements output format is used.
TMB-3594 link When the Editor has focus with an unmodified tab active and SQL Recall is also visible, Save (Ctrl+S) will invoke the SQL Recall's export functionality.
TMB-3596 link Export DDL and the Tables Script tab in the Schema Browser includes the schema name in sequence references even when the option to include schema name is set to not include.
TMB-3611 link Schema Browser shows incorrect tablespace percentage used on RAC container databases in some cases.
TMB-3617 link When Toad cannot locate sqlplus.exe there is no indication of a problem when attempting to send a script from Toad to SQL*Plus.
TMB-3623   Named SQL recall popup in Editor adds unnecessary scroll bars causing text to not be shown completely.

Toad for Oracle 13.3

The following list of resolved issues includes issues received from the Toad for Oracle forum and Toad Beta users.

Issue ID Link to Forum Post Resolved Issue
TMB-2464 link Painting issues for unpinned (autohide) dock panels upon startup
TMB-2454 link Resource leaks in script execution status dialog
TMB-2431 link Incorrect recommendation that object name must be double quoted in select create (or alter) object windows
TMB-2430 link Database Health Check fails to run via command line for all connections if only one has a wrong password specified
TMB-2413   Changes to a Code Analysis Rule Set are not saved when saving to previously exported Rule Set file
TMB-2408 link No Explain Plan results in some cases when the Explain Plan table exists in multiple schemas
TMB-2393   "Invalid Oracle Home" message shown for instant clients installed to a folder named "bin"
TMB-2354 link Sequence last cache value is incorrectly reporting the maximum value
TMB-2340 link Error encountered when publishing Java class containing forward slash in its name to PL/SQL
TMB-2299 link Cannot copy individual cell values from the Partitioning tab when viewing a table
TMB-2297   Incorrect DDL generated for table having foreign key referencing a view
TMB-2272 link Cannot edit saved direct connection so that it uses Service Name or SID
TMB-2271 link Incorrect font used for some columns when viewing table data in grid
TMB-2260   Export Dataset data masking does not work in some cases
TMB-2256 link Export Dataset parses SQL file incorrectly in some cases
TMB-2250   ORA-00900 when using the Data Masking option with SQL Text dataset in the Export Dataset window and action
TMB-2249   Copy/paste a block selection containing multibyte characters causes exception when pasting
TMB-2245 link Code navigator when describing a package does not update properly
TMB-2243 link Export Dataset, Excel File format, exports the date 1-1-1900 as a string instead of a date
TMB-2241 link Control alignment/position issues when resizing Session Browser
TMB-2238   Contexts, Dimensions, and Policies are not shown in the Schema Browser when connected to a database that does not support Java, e.g. Oracle XE
TMB-2226 link Data Grid is slow to load for queries having many columns in the result set when Sensitive Data Protection Awareness is enabled
TMB-2225   Editor, Toggle Full Screen Grid (Shift+F2) paints poorly and is non-functional in some cases
TMB-2212 link Export Dataset, Merge Statements, incorrect SQL generated when table primary key consists of all columns
TMB-2201   Administer Tablespace window problems (duplicate rows, privilege exception) when connected to Oracle 12.1 container database
TMB-2192   Cannot edit data in grids for index-organized tables
TMB-2153   The "OK" button does not enable when altering a tablespace and changing the maximum size value for a datafile
TMB-2146   Auto-connect not working when more than one connection is set to connect automatically upon Toad startup
TMB-2057 link Compare Schemas incorrectly flags DEFAULT_COLLATION as a difference and produces SQL error on target database in some cases
TMB-2034 link Window bar buttons do not update connection colors properly
TMB-2030 link Query results take too long to become available
TMB-2009   Database Probe hangs on Oracle 11g Release 2
TMB-1973 link Data Grid is read-only when executing SELECT from table having XMLTYPE column despite ROWID being returned
TMB-1970   Code Analysis results in JSON format specifies wrong object owner in some cases
TMB-1948 link Analyze Objects window opens to the wrong connection in some cases
TMB-1918 link Export Dataset incorrectly excludes XMLTYPE columns when the option to exclude virtual columns is enabled
TMB-1872   Creating an Oracle 18c or 19c pluggable database fails if the container database is non-Exadata
TMB-1849 link Access Violation generating Explain Plan
TMB-1818 link Duplicate Row in the data grid will cause Toad to stop responding if followed a Find (Ctrl+F)
TMB-1808 link Rebuild Table changes INTEGER to NUMBER
TMB-1799 link SELECT * FROM TABLE(dbms_xplan.display_cursor) showing unexpected result
TMB-1745 link Compare Files vertical scrolling is too aggressive when the scrollbar is clicked
TMB-1704   "Data type not supported" error when viewing cursor output containing TIMESTAMP or INTERVAL fields
TMB-1624 link Compare Schemas uses DBMS_REDEFINITION to sync tables at times when it shouldn't
TMB-1609   Sending PL/SQL from the Set Parameters window to Toad Script Runner for execution passes SQL that is incomplete resulting in error
TMB-1604 link Explain Plan results in "ORA-01775: looping chain of synonyms" error
TMB-1587 link Windows high contrast option is not obeyed in some windows
TMB-1552   "No mapping for the Unicode character exists in the target multi-byte code page" exception upon Toad startup/shutdown

Toad for Oracle 13.2

The following list of resolved issues includes issues received from the Toad for Oracle forum and Toad Beta users.

Issue ID Link to Forum Post Resolved Issue
TOR-822   Generated block produces variable names exceeding 30 chars
TOR-1176   Can't use Korean font
TOR-1263 link Breakpoint positions are lost when formatting
TOR-1831 link Impossible to CTRL+Click on package name
TOR-2105   Toad 12.12 menu font size does not change with Windows Control Panel display setting at 125%
TOR-2249 link SQL using ANSI join within PL/SQL doesn't execute when selected
TOR-2254   The Script Tab not showing NULL values
TOR-2603   overloaded procedure always selects the first instance when executing from the Schema Browser
TOR-2617   Default schema does not work in Editor as it used to.
TOR-2647   SVN: object fails if the comment matches the VCS Project name
TOR-2661   Rule 6405 is not triggered
TOR-2671   LIOOB querying tables with nested column types
TOR-2731 link Format Case Only replaces tab with space
TOR-2789   Opening Saved SQL from SQL Recall no longer displaying the name of the Saved SQL
TOR-2853   TSR prompts for password if it contains a space
TOR-2911   Connection colors not changing in windows - requires restarting Toad
TOR-3013   show pdbs command does not work in F5
TOR-3056   " Alt+/" not working for Upper case
TOR-3068   ORA-01017 error occurred when Toad recovers after crashing and reconnects.
TOR-3080   Cannot modify menu shortcut if it conflicts with another command
TOR-3106   Can't type € into the Toad Editor, Schema Browser, Import Filter, stc.
TOR-3114   When closing password prompt for connection, connection window closes
TOR-3128   Error and AV when altering a table when not restricted through Toad Security
TOR-3130   Compare Objects - Ignored Object Names cause false differences
TOR-3149 link Editor not opening correctly in SDI and One/Connection
TOR-3152 link Editor removes unprintable characters
TOR-3161 link Run Proc changing Toad's date format.
TOR-3164   SB Data filtering not working properly for certain tables
TOR-3167   Editor wrongly changing current schema after query when logged in as SYSDBA
TOR-3168   File splitting adds additional tags and open tabs with every save and split
TOR-3186 link Java name not shown on tab caption after compile
TOR-3194   Custom Data Filter in schema browser not working correctly
TOR-3195 link No way to include leading spaces on data import
TOR-3196   F4 Does not work in Current Statement tab
TOR-3214 link ORA-01719 during Schema compare
TOR-3245   Oracle Compatible Version handled incorrectly
TOR-3248 link Unchecking columns still includes them in SQL*Loader Control File
TOR-3250   OS Date settings not correctly detected
TOR-3251   ORA-00922 running tablespace script in Exadata 18c
TOR-3252   Data Generation - Commit Every option not saved in SQL*Loader file
TOR-3261 link CTRL+Insert not working in all grids
TOR-3265   /EXEC comman line parameter non-functional
TOR-3266   Toad's date format changing when windows date format changing
TOR-3280   Script generation queries against V$IM_COLUMN_LEVEL even when "In Memory" option is set to "Never"
TOR-3282   "Display all results in grid" not remembered in Export Dataset
TOR-3283   Auto Optimize won't connect EXTERNAL or Proxy connection
TOR-3285   F9 can stop working in the editor in SDI mode
TOR-3296 link Explain Plan not switching RAC instances in session browser
TOR-3297   Tables skipped if different PK but "Use DB Link" option checked
TOR-3299 link Access Violation with cursor bind variable
TOR-3304   Toad slow to start
TOR-3309   Full snippet is not detected correctly
TOR-3313   Large VARCHAR2 columns (>4000 chars) not copied
TOR-3315   Cntrl+Enter not working correctly when code includes Tabs
TOR-3341   Temp tbs of pluggable does not show while on container
TOR-3343   Missing support for LOW lob compression in GUI
TOR-3351   Spotlight essentials login fails
TOR-3360   Collation clause sometimes appears when not valid
TOR-3371 link Navigator not sorting alphabetically
TOR-3375   Toad Schema Browser access violation when refreshing job details in treeview
TOR-3376 link SQL Recall allowing duplicate statements to stack up
TOR-3384   Auto commit option reinstated
TOR-3387   Script is missing constraint references
TOR-3388 link Import Table Data looking at wrong decimal/thousand separator settings
TOR-3415 link Ctrl+Right does not stop on period
TOR-3433 link Fetch can't be cancelled on "group by"
TOR-3439 link DBMS Output polling not working
TOR-3448 link SB LHS and RHS can get out of sync
TOR-3452   Ctrl+Del behavior differs from Toad 12.7 and earlier
TOR-3453 link Editor dock layout is not remembered
TOR-3454   Can't always choose target table for export
TOR-3456   Access Violation when closing tab
TOR-3457   F5: Invalid data for a node of type 'CDATA' when running a query against dba_hist_sql_plan
TOR-3519   Error when trying to get index size from LHS Indexes
TOR-3557   Code Analysis messages window not being shown when no violations exist and manually launched
TOR-3587   SQLLoader can't run control files that specify datafile w/o path
TOR-3564   Script generation of Unified Audit Policies throws exception in Oracle 19c
TOR-3600 link Grid Find Dialog difficult to select rows
TOR-3602 link Error message is corrupr
TOR-3610   Use ALTER instead of CREATE OR REPLACE when possible with TYPES
TOR-3615 link Can't get past first nested object in grid popup editors
TOR-3618   DESC command is reporting wrong column size
TOR-3648 link Trigger Scripts: Schema name not getting added/removed in FOLLOWS
TOR-3701 link Next run date calculation sometimes showing wrong timestamp
TOR-3784 link Negative values appearing in Wait Event chart
TOR-3796   ORA-00942 in Schema Browser with Oracle Cloud ATP and SELECT ANY DICTIONARY privilege
TOR-3853 link Import Table Data GUI problem importing from multi-sheet excel file
TOR-3863 link Excessive white space at bottom of grid with vertically oriented monitor
TOR-3929 link File Compare/Merge window cuts off underscores when font size is increased
TOR-3970 link Object Type list is empty when compare single object is launched from DESC window
TOR-4013   RETENTION clause wrong in scripts with securefille LOBs.

Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist in this release line at the time of the current release.

General known issues

Known Issue Issue ID
Toad's help cannot be opened from an installation path that contains Unicode characters. 72966

If you check "Indexes" on the Scripts tab for snapshots, then the primary key for the snapshot will be included in the script, even though the CREATE MATERIALIZED VIEW statement implicitly creates this primary key.

Toad currently does not differentiate between indexes created explicitly on the snapshot and indexes created automatically when the snapshot is created.

Workaround: If you are running the generated script to recreate the snapshot, then you can simply ignore the error that occurs when the script tries to recreate the primary key index for the snapshot. If you do not normally create indexes on snapshots, then you can uncheck "Indexes" when generating the snapshot script.

N/A

If you use 11g Oracle ODP.NET client or any other client that does not have the oci.dll in the BIN directory, Toad has the following problems:

  1. Client shows as invalid
  2. Client version is not detected
  3. As a result of #2, columns of the following datatypes are not shown in the Schema Browser table data: CLOB, BLOB, NCLOB, XMLTYPE, TIMESTAMP, INTERVAL, BINARY_DOUBLE, and BINARY_FLOAT
N/A

Debugger

If there is an exception during debugging on a 10Gr2 or greater database, REFCURSOR output and DBMS output will not be available when debugging is completed. This is due to the target session not being available.

Workaround: To see REFCURSOR output and DBMS output, execute the procedure without the debugger.

N/A

Connections

While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly, such as Toad Script Runner (TSR).

N/A

Schema Browser

Sometimes after pressing "Compile invalid objects", you may get ORA-20000, ORA-06512, or ORA-06512 errors. This could mean that you do not have the privileges to compile the object, but it also happens when the schema contains a package body that does not have an associated spec.

Workaround: Look in the schema that you are trying to compile to see whether there are any orphan package bodies. If it is your own schema, then do:select * from user_objects o1 where object_type = ''PACKAGE BODY'' and not exists (select ''x'' from user_objects o2 where o2.object_name = o1.object_name and o2.object_type = ''PACKAGE'') Then drop any orphan package bodies that are found.

N/A

Virtualization

An access violation error may display when you close Toad in a Citrix XenApp environment.

76354

Import/Export

Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause.

59228

Data Modeler:

  • Generation of HTML reports of large diagrams may fail during generation of an image of the ER Diagram.
  • Comparison of large models may consume too much memory.
N/A

Proxy server known issues

Known Issue Issue ID

Toad does not support Proxy Automatic Configuration (PAC) scripts; however, Toad does allow you to specify Quest-specific proxy settings to work around this limitation. By default Toad will use non-PAC proxy settings configured within Windows automatically.


Apply settings system-wide:


HKEY_LOCAL_MACHINE\Software\Quest Software\Internet Settings:

  • ProxyEnable (DWORD): 1 = enable proxy override at this level, 0 = don't enable proxy override at this level
  • ProxyServer (string): semicolon-delimited "<protocol>=<server>:<port>" entries
    • For a shared proxy server across multiple protocols:
      • a single "<server>:<port>" entry is all that's needed (ex: "127.0.0.1:8888")
    • For individual proxy servers by protocol, specify multiple entries:
      • ex: "https=127.0.0.1:8888;http=127.0.0.1:8080;ftp=127.0.0.1:6300"

For 32-bit applications on a 64-bit machine:

  • Key: HKEY_LOCAL_MACHINE\Software\WOW6432Node\Quest Software\Internet Settings:

Apply settings to your own account:


HKEY_CURRENT_USER\Software\Quest Software\Internet Settings:

  • Same keys as above

Notes for use:

  1. Override proxy settings will only be included if the corresponding ProxyEnable value is set to "1". Otherwise, it's ignored.
  2. HKLM (system-wide) server settings will override Windows settings.
  3. HKCU (local) server settings will override HKLM and Windows settings.
  4. Users can also edit both the system proxy settings (existing in Toad 14.0) and now their user-specific proxy settings (from HKCU) within Toad's Proxy Settings dialog (View | Options | Online); however, system-wide settings (from HKLM) will not be editable inside of Toad since they're more for administrators in silent installs or system-wide configs.
72966

Data Grids known issues

Known Issue Issue ID

You may receive an "ORA-00902 invalid datatype" error when editing an object, nested table, or varray data if you have redefined the data type for that data during the current session.

Workaround: If you redefine an object type, nested table, or varray and then need to edit data in a table based on that type, end your current connection and begin a new one.

N/A

Full table data is not displaying in the live data grid (results from F9) if the data contains "zero" characers (ACII 0). In this case, all data after the zero character will not show in the grid.

Workaround: Double click on the data cell in the data grid to view full contents of data in a popup editor.

 

Code Analysis known issues

Known Issue Issue ID
Saving results to a database: When dealing with nested procedures, Code Analysis can only insert run data from procs one level deep. N/A

Saving PL/SQL results to a database may fail or save invalid data to the database for invalid PL/SQL objects.

Workaround: To ensure PL/SQL results are saved to the database correctly, verify the validity of all objects before running Code Analysis.

N/A

Editor known issues

Known Issue Issue ID

Toad errors when you query on a field of Oracle collection types.

Workaround: Execute using SQL*Plus.

64373

When spooling to an unpinned output window, the window becomes unresponsive and errors are given when Toad is closed ("Canvas does not allow drawing").

Workaround: Keep the output window pinned.

68523

If you use a non fixed-width font, the results are misaligned in the of Script Output tab in Editor after executing a SQL script.

Workaround: Go to Options | Scripts and select a fixed-width font for script output.

62234

Session Browser known issues

Known Issue Issue ID
The Program name in the Session Browser may be blank or may be the full path to the executable instead of just the executable name. This depends on the Oracle client, not on Toad. N/A

In RAC databases, version 10.1.0.3 (and possibly other 10.1 versions), the query used to populate the "Current Statement" in the Session Browser fails with the following error: Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance <instance name> ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments.

Workaround: Clear the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary.

N/A

Team Coding known issues

Known Issue Issue ID

Creating a new revision or attempting to force a check-in to Visual Studio Team Services may result in a "404: Not Found" error. The current version of Team Foundation Server used by Visual Studio Team Services compares the source being uploaded with the source already in the repository. If the source has not changed, it may incorrectly return an error rather than allowing the forced revision. This appears to be a Microsoft issue. As a result, these two commands may fail.

N/A

When using the Team Foundation Server internal client and Team Foundation Server 2012 or 2013 alternate Team Project Collections, workspaces created outside of Toad are not visible from within Toad. A workspace may be created from Toad by clicking the ‘New’ button during the Team Foundation Server log in.

This is not an issue when using the Team Foundation Server external client.

114334
Team Coding is disabled for mixed-case object names. N/A

With CVS, Toad may fail to retrieve the list of projects for you to select from in the CVS browser or in the Code Control Groups configuration.

Workaround: See "Missing CVS\Entries File Error" in the online help.

N/A
Team Coding and Clearcase: Dynamic Views are not supported via SCC interface. Snapshot Views must be used instead. (Rational case ID v0830629, Rational Defect # CMBU00053934) N/A

Unicode known issues

Known Issue Issue ID

The following features in Toad do not support Unicode:

  • ASM Manager
  • Export File Browser
  • Hex Editor

In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser.

N/A

Editor options to highlight object names may not work for object names that contain Unicode characters.

N/A
Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names. N/A
XML (Plain) format creates bad XML if Unicode string values and Unicode column names are exported through Export Dataset. N/A

Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean).

63221
In Team Coding, objects with Unicode contents are supported, objects with Unicode names are not. Supported Version Control Providers do not support Unicode names. N/A

The OCI option ORA_NCHAR_LITERAL_REPLACE affects the NCHAR String Literal Replacement behavior when connected to non-Unicode databases. The option can be enabled or disabled. See the "Enable ORA_NCHAR_LITERAL_REPLACE" option (View | Options | Oracle | General). The option has adverse behavior regardless of its value.

  • Enabled - ORA-01756 error when executing SQL using the Q-quote operator where the end delimiter appears within the string literal and is followed by a single quote that is also part of the string literal. The single quote does not have to immediately follow the delimiter.
  • Disabled - NCHAR string literal corruption when connected to non-Unicode database.

N/A

High DPI known issues

Known Issue Issue ID

Toolbars

(Affects Windows Server 2019 only)

Toolbar button images may disappear when you mouse over them if the "High DPI scaling override" option is set to "System (Enhanced)" in the Windows file properties dialog for Toad.exe

N/A

Third-party known issues

Known Issue Issue ID

Help

(Affects the 64-bit version of Toad only)

If IE9 is installed, clicking a link in the Help file may crash Toad 64-bit, even if IE9 is not the default browser.

Workaround: Users who have IE9 installed can open Help from outside of Toad.

N/A

System Requirements

This section contains the hardware, software, and privileges required to run Toad for Oracle, as well as the database and virtual environments that Toad for Oracle supports.

Hardware requirements

Requirement

Details

Processor

1 GHz processor

Memory

  • 1 GB RAM - Toad for Oracle 32 bit
  • 2 GB RAM - Toad for Oracle 64 bit

Note: The memory required may vary based on the following: 

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard disk space

  • 120 MB - Toad for Oracle 32 bit
  • 150 MB - Toad for Oracle 64 bit

Operating system

  • Windows 8.1
  • Windows 10
  • Windows Server 2012 R2 - 2 CPU required
  • Windows Server 2016
  • Windows Server 2019

Database requirements

Requirement

Details

Database client

An Oracle client must be installed and configured on the system where you are running Toad. The following are supported:

  • Oracle Client or Instant Client 10.2.0.5
  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3
  • Oracle Client or Instant Client 12c Release 1 and 2
  • Oracle Client or Instant Client 18c
  • Oracle Client or Instant Client 19c

Note: You must use the 32-bit version of Toad with the 32-bit Oracle client, and the 64-bit version of Toad with the 64-bit Oracle client.

Database server

Oracle versions:

  • 10g Release 2
  • 11g Release 1 and 2
  • 12c Release 1 and 2
  • 18c
  • 19c

Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

Cloud database service

Oracle Database as a Service on Amazon EC2 and Oracle Cloud

Network

  • Internet Protocol Version 6 (IPv6) is being adopted by the US Federal Government and industries around the world. In its most basic format, the new protocol uses 128-bit addresses instead of 32-bit addresses, which are used by the current IPv4 to route packets over the Internet. Toad for Oracle features, such as FTP, access the Internet through third-party vendors that are IPv6 compliant, such as /nSoftware's IP*Works. For access to Web sites by way of the Toad Online window, Toad simply invokes the user-defined or default Web browser.
  • Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Quest Auto Update requires internet access and must be able to reach the cloud service at https://autoupdate.toadworld.com.

Additional requirements

Requirement

Details

Additional Software

  • Microsoft Internet Explorer 6.0 or later (to view video from the Jump list within Toad, and to view the product documentation in HTML format).
  • Microsoft Office 2016 and recent earlier releases are supported for Word and Excel output.
  • Adobe Acrobat Reader 7.0 or later (to view the product documentation in PDF format).
  • Microsoft .NET Framework 4.0 to support the Toad for Oracle Editions Installer.

Virtualization support

Type

Details

Application virtualization

Citrix® XenApp

Desktop virtualization (VDI)

vWorkspace™ 7.0 has been tested.

Server virtualization

Oracle VM 3.1 has been tested.

VMware ESX Server 3.5, 4.0, and 5.5 have been tested.

Note: Toad may work in virtualization environments other than the ones listed.

Windows Privileges

In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.

Operating System

Requirements

Windows 8.1 and 10

Windows Server 2012 R2, 2016, and 2019

  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Home directories that you use for your connections

Note: Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Installation requires administrator privileges on all supported operating systems.

Note: Other functionality in Toad may require additional privileges.

Product Licensing

Legacy Toad for Oracle with offline license keys

To activate a trial

  1. Go to the trial download web page: https://www.quest.com/products/toad-for-oracle/software-downloads.aspx, accessed through the product page.
  2. Select the Toad for Oracle Edition that you want to try.
  3. Log in to your account or register.
  4. Accept the license terms.
  5. Download the trial file.

To activate a purchased commercial license

  1. Go to the Quest Support website: https://support.quest.com/
  2. Type the name of the product that you want to activate in the Enter your product to find support field.
  3. Select Download New Releases.
  4. Download the installer file.

Notes:

  • License keys compatible with Toad for Oracle 9.7 and earlier versions are no longer supported.
  • Only the newer 48-character license keys are supported.
  • If you have an older license type, the Editions installer points you to the license web page where you can update it.
  • Toad supports cumulative licensing. You can add multiple licenses, including those for add-ons like Sensitive Data Protection, to Toad. Toad will use the licenses providing the highest degree of features.

Toad for Oracle Subscription with online licensing

Toad for Oracle Subscription requires you to sign in with your Quest.com account. Licenses are tied to your account giving you the flexibility to use Toad from multiple computers without having to move your license.

Sign in with existing Quest.com account

  1. Enter your account email address and password when prompted
  2. If you already have a Toad for Oracle Subscription license, no further action is needed
  3. If you do not have a Toad for Oracle Subscription license, see Activating a new license below

Create a new Quest.com account

  1. Select Sign up for a new account
  2. Enter your account details and select Sign Up
  3. A confirmation email is sent containing a verification code
  4. Enter the code from the email and select Verify

    NOTES:

    • It may take a few minutes for the verification email to arrive

    • Check your spam/junk folders for the email sent from supportadmin@quest.com if you do not receive it

    • For additional assistance, please contact Quest support

Activating a new license

  1. Toad for Oracle Subscription automatically provides a fully functioning, 30-day Trial license
  2. To purchase a new license, click Buy Now from Toad's title bar
  3. After completing your transaction, restart Toad and your license is automatically detected
  4. To manage licenses, select Account Settings beneath your account shown at the top-right of Toad

    NOTE: You can view your licenses from within Toad by selecting Help | Licensing

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación