Release Notes

Toad^® for Oracle 2025 R2

Release Notes

Revised 5/13/2025

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 R2 is a minor release, with enhanced features and functionality.

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

About Toad^® for Oracle^®Editions

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

Toad for Oracle Subscription

Toad for Oracle is now available with subscription licensing. The benefits of subscription include:

• 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 ensuring that Toad for Oracle Subscription will be continuously available to users
• Invitations to training events like our Ask Toad and Toad Training Tuesdays series

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

• Toad for Oracle
• Benchmark Factory for Databases
• Code Tester for Oracle
• Spotlight on Oracle
• SQL Optimizer for Oracle
• erwin Data Modeler Lite for Oracle
• Toad Data Modeler

Note: 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.

The following Toad for Oracle Subscription Editions are available:

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

Toad for Oracle non-Subscription

Toad for Oracle non-Subscription uses offline term and perpetual licensing. This is Toad for Oracle's legacy licensing model.

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

• Toad for Oracle
• Benchmark Factory for Databases
• Code Tester for Oracle
• Spotlight on Oracle
• SQL Optimizer for Oracle
• erwin Data Modeler Lite for Oracle
• Toad Data Modeler

The following Toad for Oracle non-Subscription Editions are available:

Note: The DB Admin Module can be added to any Toad Edition. Spotlight on Oracle® includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard.

Toad for Oracle on Mac

Toad for Oracle is now available for Mac using a new license specific for macOS. 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
• Auto Update is unavailable in the Subscription version
• 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 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.
• 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; only one of these folders will exist depending on your version of Toad:
    • ~/Library/Application Support/Toad for Oracle/TnsAdmin
    • ~/Library/Application Support/Toad for Oracle Subscription/TnsAdmin

The following Toad for Oracle on Mac Editions are available:

Install

1. Download the Toad for Oracle on Mac zip file
2. Double-click the zip file; macOS will automatically extract it to the current folder
3. Optionally copy the app folder to the Applications folder; macOS will prompt you to do so upon first run if run from any other location

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/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 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.

Enhancements from Idea Pond

Discontinued Features

Knowledge Xpert. Knowledge Xpert is no longer available on Toad World. Beginning with release 13.1, Toad components no longer reference the online Knowledge Xpert.

Ask a Question. The Go to Toad World and Ask a Question commands on the Toad World toolbar have been replaced. To ask a question, click the Forums toolbar button to go directly to the forum. To go to Toad World, click the Forums or the Browse Blogs toolbar buttons. You can also use the Help menu: Help | Toad World | Forums. This change is found in Toad for Oracle 13.1 or later.

Integration with Toad Intelligence Central. Beginning with Toad for Oracle 13.1, Toad no longer provides integration with Toad Intelligence Central. The Toad Intelligence Central window is not available and you cannot publish scripts, files, Code Analysis results, and other resources to a Toad Intelligence Central server using Toad for Oracle. You cannot connect to Toad Intelligence Central through Toad for Oracle.