サポートと今すぐチャット
サポートとのチャット

Toad for Oracle 2025 R3 - Release Notes

Release Notes

 

Toad® for Oracle 2025 R3

Release Notes

Revised 11/7/2025

 

New Features and Enhancements
Resolved Issues
Known Issues
System Requirements
Product Licensing
Getting Started with Toad
Globalization
Third-Party Notices
About Us
Copyright

About Toad for Oracle

Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:

  • Understand your database environment through visual representations
  • Meet deadlines easily through automation and smooth workflows
  • Perform essential development and administration tasks from a single tool
  • Deploy high-quality applications that meet user requirements; perform predictably and reliably in production
  • Validate database code to ensure the best-possible performance and adherence to best-practice standards
  • Manage and share projects, templates, scripts, and more with ease

The Toad for Oracle solutions are built for you, by you. Nearly two decades of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over two million, Toad for Oracle continues to be the "de facto" standard tool for database development and administration.

Toad for Oracle resources

Toad World is a unique and valuable resource available to all Toad users. Toad World provides forums, blogs, videos, product information, Beta releases (when available), and Trial downloads for Toad products. Visit Toad World at: https://www.toadworld.com.

Two of the most-often used features of Toad World are the Forums and the Idea Pond.

  • On the Idea Pond page, you can submit your ideas to improve Toad and vote for or comment on other ideas. The Toad team takes your suggestions seriously, and you may even hear back from one of our developers on the topic. We encourage all Toad users—from new to experienced—to let us know how we can improve Toad.
  • On the Forum page, you can ask a question or start a discussion and view all other forums within the Toad community.

The Toad World blog pages feature a broad range of information, including topics of interest to our industry, as well as instructions from team members on how to use the latest Toad features.

The Toad for Oracle web-based training is a perfect accompaniment to your product license. This free training walks you through major product features and explains how to perform frequent tasks. You’ll also see how to utilize time-saving automation functionality. You’ll receive a certificate of completion for each course once you pass the accompanying test.

About this release

Toad for Oracle2025 R3 is a minor release, with enhanced features and functionality.

Toad for Oracle 2025 R3 includes component and requirement upgrades. These upgrades address security vulnerabilities previously identified in the third party component.

About Toad® for Oracle®Editions

Toad for Oracle Edition features:

  • All of the great, award-winning Toad features you have grown to love
  • Access to our world-class support team, Knowledge Base, how-to videos and more
  • Quest Auto Update keeping you on the latest version
  • Online License Management making it easy to assign licenses to individuals, keep track of individual usage, manage organizations, and reassign unused or under-used licenses as needed to ensure license compliance
  • Automatic renewal of Subscription licenses ensuring that Toad for Oracle will be continuously available to users
  • Invitations to training events like our Ask Toad and Toad Training Tuesdays series

Each Toad for Oracle Edition is packaged with additional Quest products to expand your experience.

The following products may be part of your Toad for Oracle Edition:

The following Toad for Oracle Editions are available:

Edition

Licensed

Toad for Oracle Base Edition

Toad® for Oracle®

Toad for Oracle Professional Edition

Toad® for Oracle® Professional

Toad for Oracle Professional DB Admin Edition

Everything in Toad® for Oracle® Professional

DB Admin Module Add-on

Sensitive Data Protection Add-on

Toad for Oracle Xpert Plus Edition

Everything in Toad® for Oracle® Professional DB Admin Edition

SQL Optimizer for Oracle®

Toad for Oracle Developer Plus Edition

Everything in Toad® for Oracle® Xpert Plus

Code Tester for Oracle®

Benchmark Factory® for Databases - Oracle Edition with 100 virtual users

Toad for Oracle DBA Plus with erwin Edition

Everything in Toad® for Oracle® Developer Plus

Benchmark Factory® for Databases - Oracle Edition with 500 virtual users

Spotlight on Oracle®

erwin Data Modeler Lite for Oracle®

Toad for Oracle DBA RAC Plus with erwin Edition

Everything in Toad® for Oracle® DBA Plus with erwin

Spotlight on Oracle® with RAC Option

Toad for Oracle DBA Exadata Plus with erwin Edition

Everything in Toad® for Oracle® DBA RAC Plus with erwin – Includes Exadata

Spotlight on Oracle® with RAC and Exadata Options

Toad for Oracle DBA Plus

Everything in Toad® for Oracle® Developer Plus

Benchmark Factory® for Databases - Oracle Edition with 500 virtual users

Spotlight on Oracle®

Toad Data Modeler®

Toad for Oracle DBA RAC Plus

Everything in Toad® for Oracle® DBA Plus

Spotlight on Oracle® with RAC Option

Toad for Oracle DBA Exadata Plus

Everything in Toad® for Oracle® DBA RAC Plus – Includes Exadata

Spotlight on Oracle® with RAC and Exadata Options

Note: All editions are available in an 'AI Enabled' version, which includes everything in the standard edition plus the AI Explain feature to assist with code comprehension. Read more about AI Explain at Toad World.

Note: Spotlight on Oracle® includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard.

Note: Ancillary products are not available for all platforms.

Toad for Oracle on Mac

Toad for Oracle is available for Mac. Click here to download the free trial.

It includes the great, award-winning Toad features you have grown to love with a few limitations:

  • There is no installer so setting Toad to be read-only or disable internet access using command-line arguments during installation is not possible
  • Scheduling tasks and Utilities | Task Scheduler are unavailable
  • Quest Auto Update is unavailable
  • The edition includes Toad for Oracle; additional Quest products are not included
  • Team Coding does not support VCS integration
  • Excel Instance and Microsoft Access formats for Export/Import features are unsupported
  • Only executables bundled with Toad may be launched (e.g. Toad Script Runner); other external applications and Utilities | External Tools are unsupported
  • Font choosers may appear to duplicate fonts due to truncation; Courier New, Courier New Baltic, and Courier New Greek, for example, may all show as Courier New
  • Toad for Oracle on Mac includes Oracle Instant Client versions 19c and 23c, which cannot be modified or replaced. The Oracle Client provides additional features, such as Kerberos authentication. By default, the application uses a clientless connection method, but you can optionally switch to using the Oracle Client for database connections.
  • Connections
    • Direct connect works as usual
    • TNS and LDAP connections work as usual provided the network configuration files (e.g. tnsnames.ora, ldap.ora, and sqlnet.ora) are found on disk in either of these folders:
      • $TNS_ADMIN
      • $ORACLE_HOME/network/admin
    • If TNS_ADMIN and ORACLE_HOME are not defined environment variables you may place the network configuration files in a special folder created by Toad upon first launch for this purpose:
      • ~/Library/Application Support/Quest Software/TnsAdmin

Install

  1. Download the Toad for Oracle on Mac package installer
  2. Double-click the package installer to install

Uninstall

  1. Quit Toad for Oracle
  2. Move the app folder to Trash
  3. Removing the app does not remove Toad for Oracle's configuration files; delete ~/Library/Application Support/Quest Software/Toad for Oracle for complete removal

For more information about the products in your Toad for Oracle Edition and the minimum system requirements for running these products, see the Toad for Oracle Editions release notes at: https://support.quest.com/technical-documents

New Features and Enhancements

Toad for Oracle 2025 R3

Installer

  • A single installer supports all editions. Toad for Oracle can handle all license types without requiring separate installers for online subscription or offline licenses.

Licensing

  • Subscription licenses can be activated directly on your device for offline use.

High DPI and Icons

  • Full support for High DPI displays.
  • New SVG-based icons improve clarity and refresh the interface design.

AI Code with GitHub Copilot

Performance Improvements

  • Faster application startup.
  • Improved responsiveness when switching between maximized windows.
  • Significant performance gains in Export DDL, Generate Schema Script, and Compare Schemas when extracting DDL for many objects.
  • Export Dataset window opens faster in certain cases.
  • Jump Search results are displayed more quickly.

Connections and Login Window

  • The Change Session button includes sorting options.
  • The Change Session button includes a menu of recently used connections.
  • The Connect as property is available for color suggestion rules.
  • The Security column in the Login window displays SSH, TCPS, or Native values.
  • A new Auto-select last connection option has been added to the Login window. When disabled, grouped connections appear collapsed when the window opens.
  • The Login window displays a warning when multiple tnsnames.ora files are found in the search paths.

Workspaces

  • Added a Close Editor without prompts option when loading a workspace.
  • Added a Show confirmation dialog option when loading a workspace.
  • Workspace-related options have been moved to a secondary dialog.

Connections Toolbar

  • Improved visibility with higher contrast for the active button.
  • Buttons for encrypted or SSH connections display a lock icon.

Windows Toolbar

  • Improved visibility with higher contrast for the active button.

Toolbars

  • Added filtering to the Customize dialog on the Commands tab.

Schema Browser

  • Lock Date and Expiry Date timestamps are displayed for users in the right-side overview grid.
  • New options allow configuring tab styles (Tabs, Buttons, or Flat Buttons).
  • SYS views are shown for databases that are mounted but not opened.
  • Favorites tab supports custom sorting by dragging objects when the tree is not sorted by a column.
  • Objects can be dragged from other windows (e.g., Object Search or Schema Browser) into the Favorites tab.
  • The Users | Roles tab includes filtering capabilities.
  • The Unified Audit Policy | Enablement tab shows success and failure status.

Session Browser

  • Added icons to identify blocking and blocked sessions.
  • A new Show SQL button is available in the Kill Sessions, Disconnect Sessions, and Start Trace dialogs.
  • The Limit filter includes Module, Action, and Client Info fields.

ADDM/AWR Reports

  • Added an option to query CDB views. When disabled, DBA views are used instead.

HTML Database Doc Generator

  • Updated visual design.

Datagrids

  • The total number of selected rows is displayed when multiple rows are selected.

Export DDL

  • Updated visual design.
  • Added Another Schema as a destination option.

Object Search

  • The grid filter is cleared each time the window opens.

Spool SQL

  • Added an option to include OCI Describe statements (enabled by default).

Toad for Oracle 2025 R2

AI Code with GitHub Copilot Preview

  • Toad for Oracle Subscription now supports GitHub Copilot with an AI-enabled license.
  • License administrators must enable the AI Code feature for the license and for each user who needs access.
  • Requires GitHub Copilot account.
  • Read more about AI Code at Toad World.

Toolbars

The default toolbar layout has been streamlined to reduce complexity and highlight the most commonly used features.

Toad for Oracle on Mac

Now includes Oracle Instant Client 23.7 in addition to 19.3.

Accessibility

  • Improved screen reader support in:
    • Export Dataset
    • Export DDL
    • Various Editor popup assistants
    • Login and Add/Edit Login Record dialogs
    • Buttons labeled with "..."

Connections

  • Error dialogs now display connection details.
  • You can now specify wallet location and SSLServerDNMatch for Direct connections.
  • The "Containers" submenu in the Connection Bar's context menu is now sorted alphabetically.
  • The main "Test Connections" toolbar button opens a dialog to select sessions for test/reconnect.
  • Connection colors can be overridden when a specific role is enabled for the session.
  • Support added for importing SQL Developer connections.

Schema Browser

  • Proxy users can now be displayed bidirectionally.
  • Drop object dialogs now show the schema name if it differs from the login schema.
  • Quick filters now search favorite folder names.
  • New option added to select BLOB/CLOB columns to avoid loading large data via database links. See Toad Options | Schema Browser | Data Tab | Select BLOB/CLOB columns
  • Improved usage of GDI and User Object resources.

Editor

  • Dock layout performance has been improved by creating UI controls only when needed.
  • Options added to show deleted and externally modified files with strikethrough and italic text, respectively, in the tab caption (enabled by default). See Toad Options | Editor | Display.

Data Grids

Added a "Copy Column Names" option to the context menu.

Describe Window

You can now save the object list without including schema or connection details.

Automation Designer

  • Connection errors are now included in the log output.
  • The search feature (Ctrl+F) now searches within action property values.
  • Added a "Get command line" option to the context menu to generate the command for running the action.

User Interface

  • Updated visual appearance for:
    • Data Pump Export
    • Data Pump Import
    • Export DDL
  • Directional buttons (Up, Down, Left, Right) are now used consistently across the interface to move items.

Team Coding

New "Show popup on error" option in Team Coding Configuration shows VCS errors in a message box (enabled by default). When disabled, errors appear only in the log.

Export File Browser

Added the ability to export all tables to CSV.

DBMS Output

Added a "Use CLOBs" option (enabled by default). When disabled, VARCHAR2 is used.

Oracle Tuning Advisor

A new "Send to" button lets you send SQL to the Editor, Toad Script Runner, SQL*Plus, or the "Show SQL" window.

Object Compare

New feature added to convert column datatypes using DBMS_REDEFINITION.

Trace File Browser

  • Local trace files can now be purged.
  • File loading operations can now be canceled.

Object Search

The search text box is now focused when the window opens.

Compare Data

Added "Query" to the list of object types, allowing SQL to be used as a source or target.

FTP

New option added to the Remote System context menu to convert UTC timestamps to the local time zone (enabled by default).

Space Manager

Added the ability to specify grantees during setup.

Triggers

Script generation is now more efficient in the Export DDL, Compare Schemas, and Generate Schema Script windows.

Tablespaces

The Tablespaces administration window now includes a column for BigFile information.

Documentation

All local documentation, except Toad.chm, has been removed. Documentation is now available at https://support.quest.com/toad-for-oracle/technical-documents. In-product links will redirect to this site.

Toad for Oracle 2025 R1

New Windows and Mac Licensing

One license, endless possibilities! Now enjoy seamless support for both Windows and macOS with a single, unified license key.

Note: Requires the purchase of new Win+Mac combo license.

Toad for Oracle on Mac

Toad for Oracle on Mac includes Oracle Instant Client version 19c, which cannot be modified or replaced. The Oracle Client provides additional features, such as Kerberos authentication. By default, the application uses a clientless connection method, but you can optionally switch to using the Oracle Client for database connections.

Toad for Oracle 2024 R2

Product Version

Toad for Oracle now uses a product version corresponding to the year of release, e.g 2024 R2 for the second release in 2024.

Toad for Oracle Subscription Editions

All Subscription Editions are available in an 'AI Enabled' version, which includes everything in the standard edition plus the AI Explain feature to assist with code comprehension. Read more about AI Explain at Toad World.

Oracle 23ai Support

  • SQL Firewall (Database menu | Administer | SQL Firewall) Note: Requires DB Admin module
  • Tablespace Shrink
  • Logical Partition Tracking
  • Open pluggable databases in hybrid read-only mode
  • Hybrid partitioned tables with interval and auto list partitioning
  • Rename LOBs without moving them
  • Concurrent refreshes in materialized views
  • Read-only users
  • Enable/disable dictionary protection
  • Individual columns in Unified Audit Policies
  • VECTOR datatypes
  • VECTOR indexes
  • Staging tables
  • Create Tablespace window defaults to 'bigfile'

Accessibility

  • Improved keyboard navigation in Toad Options.
  • Data Grid context menu activates with F10.
  • Editor caret width is configurable (Toad Options | Editor | Display).
  • Editor shortcut to toggle focus between dock panel and edit area (F6) is now customizable (Toad Options | Toolbars/Menus | Shortcuts).
  • A new 'Focus Toolbars' feature has been added to the Window menu, enabling you to highlight and interact with a specific toolbar. You can navigate through toolbar buttons using the TAB key and activate them with ENTER. This feature can also be accessed via the customizable shortcut Ctrl+` (Toad Options | Toolbars/Menus | Shortcuts).
  • A 'Docked Panels' feature has been added to the Window menu, allowing you to highlight a specific docked panel.
  • Improved keyboard navigation in the 'Add Multiple Logins' and 'Edit Login' windows available from the database login window.

Schema Browser

  • The roles filter now includes an option to exclude roles managed by Oracle.
  • The 'Drop Index' confirmation dialog includes an option to drop any constraints that would otherwise prevent the index from being dropped, avoiding the ORA-02429 error. If selected, both the constraint and the index will be dropped.
  • Custom queries and filters can be saved globally for a specific table name (Toad Options | Schema Browser | Data).
  • The 'Data' tab filter utilizes the date format set in the options (Toad Options | Data Grids | Data).
  • The base and log tables for Materialized View Logs are displayed on the 'Info' tab.
  • Introduced the option to enable or disable Unified Audit Policies.
  • Introduced icons to indicate whether Unified Audit Policies are enabled.

Editor

  • Advanced options have been added to control editor rendering, enhancing appearance on high-DPI displays (Toad Options | Editor | Behavior).
  • Shift + Right-clicking on a database object name displays the Schema Browser context menu.
  • An option has been added to collapse all regions at any level when using 'Fold All' (Toad Options | Editor | Behavior).
  • Single Record View displays the table name.

Connections

  • An option has been added to disconnect after a specified period of inactivity (Toad Options | Oracle | Connections).
  • A connection timeout option has been added to abandon slow connection attempts (Toad Options | Oracle | Connections). Applies to clientless connections only.

Data Grids

  • Improved appearance on high-DPI displays.
  • Rearranged the context menu to make the most frequently used feature easier to access.

Describe Window

  • Introduced a refresh button.

SGA Trace/Optimization

  • Renamed to 'Shared Pool Browser.'
  • Individual statements can be purged from the shared pool.

Connection Colors

  • Introduced a 'Suggest' feature to recommend a color based on user-defined rules.

Session Browser

  • Introduced 'Styles' to the context menu of the 'Sessions' tab grid.

Font Dialog

  • The font chooser dialog can be filtered and will retain your recent selections.

Create Constraint

  • A warning is displayed if you are about to create a circular foreign key constraint.

Automation Designer

  • Enhanced the placement of actions when double-clicking in the palette.

Code Insight

  • An option has been added to filter by 'Contains text' or 'Starts with text' (Toad Options | Editor | Code Assist).

DB Health Scan

  • Informational and statistical items no longer contribute to the pass/fail status.
  • Failures are now reported as the count of failed checks instead of the total number of failures.

Compare Schemas

  • 'ALTER TYPE' is utilized, when feasible, to synchronize types and prevent errors associated with 'CREATE OR REPLACE TYPE' when dependencies are present.

Compare Databases

  • Introduced a preview panel.

Manage User Settings

  • Introduced the ability to restore individual settings from backup.

Workspaces

  • Introduced a 'Cancel' button to halt workspace loading.

Master-Detail Browser

  • Added "Current Schema" option to make configuration files portable across different schemas with the same tables.

Project Manager

  • A filter has been added to refine nodes.

Explain Plan

  • Additional 'Copy to Clipboard' actions have been added to copy content as an image or XML.

Team Coding

  • Introduced a 'Locked By' field in both the Schema Browser and the Editor.
  • Introduced an option to designate either the operating system username or the database login username as the lock user.

utPLSQL

  • Introduced support for utPLSQL 3.14.

 

Resolved Issues

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

Toad for Oracle 2025 R3

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
TOR-8677 link

Editor: The bookmark margin is hidden after changing the Editor's Drawing Style option.

TOR-9129 link

Datagrid: Grouped values shown in scientific notation

TOR-9333 link

Export DDL: Can't specify sequence options when exporting tables

TOR-9334  

Export DDL and Generate Schema Script: Export is very slow when thousands of objects are being exported

TOR-9336 link

Data Grids: Color scheme lost after opening options window

TOR-9339 link

Export DDL: Foreign Key constraints create 2 files

TOR-9349 link

Color Schemes: Popup message from Login window's security icon is hard in dark schemes because of poor color contrast

TOR-9350  

Formatter: Leading comments move far to the right when formatting a text selection.

TOR-9380  

Subscription: A "901:id_token is missing..." error occurs on startup after upgrading Toad for Oracle Subscription.

TOR-9382 link

Connections Bar: "Set Container" command does not get passed to background query sessions

TOR-9394 link

Execute Procedure: (CURSOR) popup dialog stays on top of all other windows

TOR-9395 link

Editor: Set Parameters dialog anonymous block has incorrect datatype

TOR-9397 link

Editor: Set Parameters dialog's "Save/restore settings as default" causing incorrect anonymous block code in some cases

TOR-9398  

Editor: An "Access is denied" exception is shown when changing the active Editor tab if JavaScript is disabled.

TOR-9404 link

Editor: File loaded from OneDrive is shown as Externally Modified

TOR-9414 link

Compare Schemas: Trigger validity incorrectly flagged as a difference when comparing database version 12c or newer against pre-12c.

TOR-9416  

Editor: An "Unspecified error" exception is shown when changing the active Editor tab.

TOR-9429 link

Editor: Execute via SQL*Plus doesn't follow relative paths in script

TOR-9449 link

Team Coding: "Set define off" DDL option not working

TOR-9451  

SQL*Loader: Can't connect when called from Toad if password contains '@'

TOR-9455 link

Connections: Multiple "alter session" commands can be configured in options, but only one is run

TOR-9456 link

Data Compare: False differences sometimes shown if source and target databases have different NLS_SORT value

TOR-9470 link

Editor: Query timing inconsistent with Spool SQL output

TOR-9474 link

Automation Designer: Script action shows 45925 days as elapsed time

TOR-9539 link

Export Dataset: SQL error when window opens if exporting from grid with Database Link to non-Oracle database

TOR-9540  

Export DDL: Application Roles not extracted correctly in Oracle version 23ai.

TOR-9548  

Login Window: Grid fails to select last used connection when multiple group levels exist

TOR-9555 link

Export Dataset: Multiple parameters not passed to source SQL file

TOR-9566 link

Automation Designer: Export DDL fails with "Directory does not exist was was not created", even though it creates directory

TOR-9568  

Workspaces: Editor connected to wrong DB after connection failure while loading workspace

TOR-9572 link

Editor: 'dpMessages has no parent window' error sometimes occurs after dragging messages panel to a different location

TOR-9589  

Workspaces: Encoding not restored in Editor tabs with database objects, leading to access violation when Editor auto-backup runs

TOR-9591 link

Single Column Export: Prior output folders and extensions not remembered

TOR-9711 link

Editor: Can't close after connection lost if package checked out in Team Coding

Toad for Oracle 2025 R2

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
TOR-5157 link

Display Scaling: Tooltips/hints shown in the wrong location in a multiple monitor environment with differing resolutions.

TOR-7140 link

Workspaces: When auto-loading a workspace fails, the workspace is saved in its partially loaded state.

TOR-8203 link

Compare Databases: Profile differences are shown incorrectly.

TOR-8530 link

Connections: "Net: error 99" error is shown is a TYPE is modified in between uses within a SELECT.

TOR-8625 link

Workspaces: Editor tab shows that a file is both deleted and modified if it was temporarily unavailable when the workspace was loaded.

TOR-8633 link

Single Record Viewer: Fields are not wide enough to show TIMESTAMP data.

TOR-8665  

Compare Files: When a comparison is shown as a result of a Compare Schemas the Run button's hint is "Reload and recompare files" which is misleading.

TOR-8667 link

New Version Dialog: A date/time conversion error is shown in the new version dialog when a new version of Toad has been released.

TOR-8678 link

Editor: An Access Violation occurs when changing the active session in some cases.

TOR-8693 link

Editor: An Access Violation occurs when opening the Editor when the desktop layout has been customized.

TOR-8694 link

Connections: If a connection fails, Toad attempts to open an HTML document in your default text editor.

TOR-8703 link

Object Palette: The columns panel does not remember its height between showings.

TOR-8741 link

Connections: The Window Bar does not group connections correctly when multiple connections are made to the same user@db.

TOR-8744 link

Instance Manager: Ping fails when a TNS entry uses 'localhost', and the database test does not continue after the ping fails.

TOR-8746 link

Team Coding: The lock status may be incorrect if Toad was previously closed while objects were still checked out.

TOR-8747  

Workspaces: Workspaces fail to load with a "data error" in some environments, e.g. Chinese.

TOR-8850  

Team Coding: An object can be dropped even when Team Coding is configured for Git and the user is not logged in.

TOR-8857  

Connections: A "cannot open file" error occurs in clientless connection mode when WALLET_LOCATION is set to a path enclosed in double quotes.

TOR-8875 link

Editor: The Find Unused Variables feature incorrectly flags used variables in TRIGGER DDL statements.

TOR-8882 link

Team Coding: Differences cannot be merged if the local package spec file contains a synonym statement.

TOR-8889  

Compare Schemas: The "Convert datatypes with DBMS_REDEFINITION" option does not work unless "Add/Reorder columns with DBMS_REDEFINTION" option is also used.

TOR-8892  

Scripts: Toad generates an incorrect script for XML indexes.

TOR-8893  

Compare Schemas: Toad generates an incorrect sync script for XML indexes.

TOR-8895  

Schema Browser: The "Configure" option is missing from the object type right-click menu when all but one type are set to hidden.

TOR-8898 link

Schema Browser: Scheduled run times for scheduler jobs are sorted as strings instead of as dates.

TOR-8904 link

Generate Schema Script: It's not possible to export a subset of constraint types; all constraints must be selected to generate the script.

TOR-8931 link

Script Execution: Newlines in the script output differ from those produced by SQL*Plus in some cases.

TOR-8932 link

Data Grids: If the connection is made in clientless mode, Access Violations occur when entering numeric data that uses a format different from the one configured in Toad Options.

TOR-8968 link

macOS: Access Violation occurs when viewing formatter options in Toad Options, preventing any changes to the settings.

TOR-9002 link

Editor: When the "Set modified flag off after compiling from database" option is enabled, edits made after compiling PL/SQL with errors do not update the tab caption to indicate the text is modified.

TOR-9039 link

DBMS Output: An ORA-03120 error is raised when fetching output in some cases.

TOR-9113 link

Alter Datafile: When setting the size using a decimal value (e.g., 1.5 GB), Toad briefly displays the incorrect unit (e.g., 1.5 MB) after clicking OK.

TOR-9119 link

Team Coding: Reverting a checked-out table to its VCS version silently drops and recreates the table, resulting in unexpected data loss, without warning.

TOR-9124 link

Automation Designer: The Connection Iterator action passes the connection only to its immediate child actions; deeper nested actions use the first connection instead.

TOR-9125  

macOS: On first run, a "Cannot update client files" error, and possibly others, may appear in certain cases.

TOR-9131 link

Connections: An Access Violation occurs when a connection fails and the TNS record is located in a file referenced through an IFILE directive.

TOR-9142 link

Schema Browser: Subpartitions of hash partitions are unsupported in the Script tab and Create/Alter Table windows.

TOR-9157 link

Automation Designer: If a connection fails, an error dialog is displayed but does not include any connection details.

TOR-9173  

Code Insight: Exception declarations are not shown.

TOR-9237  

Connections: Connection to mounted, but not opened database results in errors.

TOR-9307  

Document Recovery: After a crash, Toad displays the Recover Documents window; however, if a second crash occurs, Toad does not prompt to recover documents on the next restart.

TOR-9315 link

Alter Tablespace: When the window opens, the General tab briefly appears before automatically switching to the Files tab.

Toad for Oracle 2024 R2

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
TOR-5153 link

Editor: Wrong desktop is assigned after reordering tabs.

TOR-6187 link

Code Insight: Join conditions based on referential integrity are not shown.

TOR-6446 link

Editor: 'Load object at caret' does not respect the option to load package/type spec and body as a pair.

TOR-7853 link

Connections: "Net: Invalid input arguments" error upon connecting to some databases in clientless mode.

TOR-8187  

Debugger: Stepping into Java Source throws an error.

TOR-8188  

Extract DDL: Table scripts exclude the object_table_substitution clause.

TOR-8194  

Schema Browser: Create user script excludes private synonyms if the script is generated for multiple, selected users.

TOR-8196 link

Compare Schemas: REVOKE ROLE command appears before its comment in the sync script.

TOR-8205  

Session Browser: Refreshing the page results in a brief flicker before the data fully loads.

TOR-8206  

Schema Browser: ORA-01009 error is raised when selecting the SYSTEM tablespace.

TOR-8216 link

Add Login Record: TNS dropdown only populates when TNS_ADMIN environment variable is defined.

TOR-8232  

Schema Browser: Script tab for object table excludes NOT NULL constraints.

TOR-8233 link

Editor: EDIT command generates a read-only grid when the "OCI Array Buffer Size" option is set to "Manual".

TOR-8245 link

Editor: Inline parameter assistance cancels and leaves artifacts when clicking elsewhere in the Editor while the assistance is showing.

TOR-8247 link

Automation Designer: Export Dataset action shows "Parameters are out of sync" message in some cases.

TOR-8299  

Command Line: Running Toad.exe with the "-c" option to make a connection does not work if Toad is running and the "Allow multiple copies of Toad" option is unchecked.

TOR-8303 link

Editor: Filename paths shown as tab hints stop working in some cases.

TOR-8305  

Object Compare: The sync script tab is missing when comparing objects with identical schema and object names across two connections.

TOR-8314  

Connections: An access violation occurs when connecting to a schema having an expired password if no Oracle clients are installed.

TOR-8330 link

Editor: Character and caret misplacement when using Windows scaling other than 100% with some font and size combinations, e.g. Consolas 14 pt and others.

TOR-8331  

Team Coding: Getting the latest revision fails if the character case of the file extension differs between the local and remote files.

TOR-8334  

Database Browser: A "Password not supplied" error occurs when connecting as an externally authenticated user.

TOR-8335  

Toolbars: The Window menu identifies the incorrect window as active in some cases.

TOR-8336  

SQL Recall: Statements dragged to the Editor are missing the statement terminator.

TOR-8337  

Login Window: The LDAP dropdown does not populate after unchecking "Connect using Oracle client".

TOR-8338  

Session Browser: The splitter position is incorrect when using the left/right layout and switching to another window.

TOR-8382  

Database Health Check: An error is shown when the "list segments which can't extend" option is used and there are tablespaces which cannot extend.

TOR-8387  

DBMS Output: Fetching output results in an ORA-02005 error with some clients.

TOR-8390 link

Editor: The EDIT command occasionally triggers an unexpected ORA-00904 error.

TOR-8396 link

Automation Designer: The Export Dataset action fails to replace substitution variables if there are comments or trailing whitespace on lines preceding them.

TOR-8414  

Editor: In some cases Toad hangs when selecting text when the Brace Highlighting option is set to 'Innermost pair in scope'

TOR-8417  

Team Coding: Files with special characters in their filenames are not displayed in the Team Coding Manager's list of VCS files.

TOR-8437 link

macOS: Toad on macOS will not start with some locale settings, e.g. Korean.

TOR-8445 link

Data Grid: Object Editor shows incorrect columns and throws an Access Violation after scrolling in some cases.

TOR-8463  

SFTP: Connecting with a private key that was created with a passphrase results in a "Logon failed 280: Error decoding key: The specified password is not correct" error.

TOR-8477  

Compare Data: A "Cannot insert null" error is thrown in some cases.

TOR-8478  

Schema Browser: An error occurs when expanding Unified Audit Policies in treeview mode.

TOR-8496  

Report Editor: Buttons on the vertical toolbar in the FastReport Editor will disappear after mousing over them on Windows Server.

TOR-8497  

Editor: Selecting text and replacing all occurrences of it using the Find & Replace dialog with the "from cursor" option excludes the selected text.

TOR-8499 link

Export DDL: Table scripts are incorrect with respect to automatic and interval partitions when the "Storage Objects | Partitions" option is set to ALL or DEFAULT/MAXVALUE.

TOR-8521 link

Data Grids: The '...' button to choose a filename is disabled in the Export Dataset dialog when the Output selection is changed from Clipboard to File.

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

Auto Update

The Auto Update feature, which automatically downloads and notifies you of product updates, is not available in the 32-bit edition of Toad for Oracle.

Workaround: Visit the Quest Support Portal to download product updates.

 N/A

Oracle client known issues

Known Issue Issue ID

In some cases, connecting to an 11g database using a 19c or 21c client may result in a hang when cancelling a query or when using Code Insight.

Workaround: Use an 18c or older client when connecting to an affected database.

 N/A

All versions of Oracle client 19c leak memory when working with LOB types. This includes simple SELECT statements against a table containing LOB types.

 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

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

Note: The following known issues occur only when the Application DPI Awareness option is disabled in Toad Options | General. This option is enabled by default.


Changing the default Editor font when Windows high DPI settings are in use, i.e. scaling greater than 100%, may result in negative effects, including:

  • Character misplacement
  • Disproportionate spacing
  • Text selection visualization not aligning with character boundaries
  • Incorrect text edits when modifying text using a block selection

Advanced options for controlling Editor rendering have been introduced in Toad for Oracle 2024 R2 to help alleviate these issues. See the Editor | Behavior page in Toad Options.

  • Drawing technology
    • Controls which drawing API is used to render text and other elements.
    • Default technology makes Toad susceptible to high DPI issues, but it may allow for sharper text on 4k and other Ultra HD (UHD) displays.
    • DirectWrite technology resolves high DPI issues and may allow for sharper text on displays less than 4k, but on 4k/UHD displays text may appear fuzzy.
    • DirectWrite technology must be used to enable font ligatures in supporting fonts, e.g. Fira Code.
  • Buffered draw
    • Controls whether drawing is buffered by first drawing to a bitmap rather than directly to the screen and then copying the bitmap to the screen.
    • Buffered drawing avoids flickering but does take longer.
    • Enabling this option is recommended.
  • Font quality
    • Controls which anti-aliasing method is used to render text.
    • LCD Optimized is recommended based on internal tests on different displays.

If you see high DPI issues and wish to use the Default technology, there are a few workarounds:

  • Enable the Application DPI Awareness option in Toad Options | General.
  • Choose a font that is not susceptible to the issues.
    • The following table lists popular coding fonts and sizes. Combinations that work well are identified by a check mark.
      Size Cascadia Code Consolas Courier New Fira Code JetBrains Mono Source Code Pro
      5 ✓ ✓ ✓ ✓ ✓
      6 ✓ ✓ ✓
      7 ✓ ✓
      8 ✓ ✓
      9 ✓ ✓ ✓ ✓
      10 ✓ ✓ ✓ ✓ ✓
      11 ✓ ✓ ✓ ✓ ✓ ✓
      12 ✓ ✓
      14 ✓
      16 ✓
      18 ✓ ✓ ✓
      20 ✓ ✓ ✓ ✓ ✓
  • Change the high DPI settings for Toad.exe from the Compatibility tab of the file’s properties dialog to override the high DPI scaling behavior and set its value to Application.
    • On some displays this setting causes some UI elements to scale incorrectly and may need to be reverted.
  • Use 100% scaling in Windows.
N/A

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

Toad for Oracle on Mac known issues

Known Issue Issue ID

The "Allow multiple copies of Toad to be loaded" option is nonfunctional.

The option allows multiple copies of Toad to be opened on Windows, but does not work on macOS. The option has been disabled.

Workaround: Review macOS documentation for instructions on how to open a new instance of an app on Mac.

 N/A

The "File | Fast Exit" feature is unavailable.

 N/A

The Quit menu item from Apple's Toad for Oracle menu is nonfunctional if an Editor is open.

 N/A

Editor is slow to open if CAPS lock is enabled.

Workaround: Turn off CAPS lock before opening Editor.

 N/A

Bold text and other UI painting issues after installing Team Coding database objects.

Workaround: Restart Toad.

 N/A

TNSPING is unavailable in the Login window. It is available in Toad for Oracle on Windows.

 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
セルフ・サービス・ツール
ナレッジベース
通知および警告
製品別サポート
ソフトウェアのダウンロード
技術文書
ユーザーフォーラム
ビデオチュートリアル
RSSフィード
お問い合わせ
ライセンスアシスタンス の取得
Technical Support
すべて表示
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択