Toad for Oracle 2025 R3 Beta

Toad for Oracle - Beta
1

We are pleased to announce the Toad for Oracle 2025 R3 beta

We encourage you to participate in the beta program to help us deliver a high quality product. This is your opportunity to participate in the development, direction, and testing of Toad for Oracle. By becoming a beta tester you will have direct access to the development team and product management via the Toad World forum.

How to join the Beta program:

  1. Read the Beta Agreement. Downloading the Toad Beta constitutes usage agreement.
  2. Install Toad for Oracle version 25.2 for Windows (Non-subscription) first.
    a. This must be a licensed, non-trial version
    b. Run version 25.2 at least once before running the beta.
    c. Leave 25.2 installed. The beta does not replace it.
  3. Download and install the beta (links below)

Which version?

If you have a 32-bit Oracle client currently installed in a 32-bit or 64-bit environment:

If you have a 64-bit Oracle client currently installed in a 64-bit environment:

Beta Expiration

Each beta expires after 4 weeks, but new versions with later expiration dates are released often, typically on Mondays. An indicator will appear on Toad's status bar when a new version is available. Click it to download and install the update (No need to remove the old beta first, just install the new one on top of it). It's very easy. In this way you can continue to use the beta until the next version of Toad is officially released.

We encourage you to stay up-to-date with the most recent beta version, and do not hesitate to post suggestions or problem reports to this forum. The development team reads every post and typically responds very quickly.

A Note about Oracle Clients:

  • 12cR2 and 18c are the recommended client versions.
  • 19c and 21c clients will work, but they leak memory with LOBs, and sometimes hang when cancelling queries against 11gR2 servers. The memory leak is not terribly severe, but something to be aware of. You can just restart Toad if/when you need to reclaim the leaked memory.
  • 12cR1 and older clients don't handle XMLTYPE natively.

Toad's no-client option

  • Uncheck the "Use Oracle Client" box on the login window to connect to the database without an Oracle client.
  • Pros of no-client option:
    • No setup required
    • It is a bit faster than using a client.
    • Supported: LDAP, TNSNames.ora, TNS_ADMIN environment variable, Oracle Encryption and Data Integrity, Spool SQL, SSH, TCPS, IPV6, External authentication, and Oracle Wallet connections.
    • Can connect to every database version since 7.3!
    • Can connect to very old and very new database versions at the same time.
  • Cons of no-client option:
    • Not supported: Oracle client style tracing/logging, proxy connections, Kerberos
    • If you don't have an Oracle client installed, of course you won't have their tools like SQL*Plus, DataPump, Import/Export, but if you have a client installed Toad can still use these tools, even if you run Toad in no-client mode.

What is this sorcery that Toad can connect to the Database without an Oracle client?

  • The Oracle client is just DLLs (and some other files) produced by Oracle that know how to connect to the database. Toad now contains code that can achieve the same thing. We did not compile Oracle DLLs inside of Toad, or package them together in any way.

The beta change log is below

9 Likes
36

Toad Beta Change Log

Toad Beta 25.3.2257-6985, Released 15-Sep-2025
Bug Fixes

  • Manage User Settings - handle incorrect import files more gracefully
  • Pinned Code - refresh button does nothing

Enhancements

  • Object Search - clear grid filter when when opens
  • Schema Browser - add Lock_date and Expiry_date to user display
  • Session Browser - indicate blocked/blocking sessions with lock icons
  • Session Browser - Add Module, Action, and Client_Info to "Limit" filter

Toad Beta 25.3.249.6951, Released 9-Sep-2025
Bug Fixes

  • Compare Data: Lost connection not handled gracefully
  • Editor: Edit area not filling the tab after "open file"
  • Editor: Script Output not filling the tab
  • Schema Browser: Occasional "Invalid pointer operation" error after working with packages, then refreshing all objects
  • Schema Browser: Wrong icon for Rollback in views and materialized views
  • Schema Browser: Missing icons in LHS-Right-click "Add" and "Create" submenus
  • Session Browser: Occasional access violation if closed in the middle of a refresh
  • Toad Startup: Occasional "file in use" errors if multiple Toads started at nearly the same time

Toad Beta 25.3.232.6895, Released 2-Sep-2025
Bug Fixes

  • Misc High DPI and SVG fixes
  • Internal Script Dialog: Dialog was staying on top of other apps
  • Toolbars: Connection and Window bar "grab handles" not visible after lock/unlock toolbars.

Enhancements

  • QSR: High DPI and SVG are now enabled (unless high dpi disabled in Toad)
  • Login Window: Now warns when you have multiple tnsnames.ora files (for example, one in the folder with Toad.exe and another in TNS_ADMIN folder)

Toad Beta 25.3.211.6831, Released 25-Aug-2025
Bug Fixes

  • Misc High DPI and SVG fixes

Enhancements

  • Workspaces: Options moved into a dialog (you may need to reset toolbars to see this)
  • Workspaces: Added an option to skip the confirmation prompt when loading a workspace

Toad Beta 25.3.203.6805, Released 18-Aug-2025
Bug Fixes

  • Object Search - SQL error when schema not selected
  • Automation Designer - script output timing was wrong
  • Misc SVG and High DPI bugs fixed

Enhancements

  • Workspaces - added "close editors without prompts" option when loading a workspace

Toad Beta 25.3.184.6743, Released 11-Aug-2025
Bug Fixes

  • Compare Schemas: Preview panel not behaving in high DPI
  • Editor: Timing of SQL Execution included too much overhead and differed from same timing in Spool SQL
  • Misc SVG and High DPI bugs fixed

Enhancements

  • Spool SQL: "OCI Describe" is now optional
  • Object Search: Object types are now displayed in mixed case
  • Team Coding: Object types are now displayed in mixed case

Toad Beta 25.3.163.6676, Released 4-Aug-2025
Bug Fixes

  • Data Compare: False diffs found if NLS_SORT differs
  • Options: Multiple "Alter Session" commands accepted but only one run
  • SQL*Loader: Connection failed if password contained '@' character
  • Team Coding: Set Define Off option not working

Enhancements

  • Icons: Most of Toad's icons have been updated to SVG from bitmap to SVG. This allows them to be resized on scaled displays without pixelation. The old icons are still available but SVG and High DPI are now enabled by default. If you previously turned off high DPI support, please re-enable it under Options -> General. SVG icons will look sharp only when High DPI is also enabled. If you notice any icons which don't look great, please let us know

Toad Beta 25.3.130.6573, Released 14-July-2025
Bug Fixes

  • Database Probe: SQL error on Oracle 23ai
  • Editor: Execute via SQL Plus didn't follow relative paths
  • Export Dataset: Quoting options can't be changed
  • Team Coding: Config dialog missing Cancel/OK/Apply buttons

Enhancements

  • Explain Plan: Icons updated to SVG

Toad Beta 25.3.113.6510, Released 7-July-2025
Bug Fixes

  • Editor: Access violation when running explain plan
  • Editor: AI Explain throws exception after unpinned and new tab opened

Toad Beta 25.3.106.6482, Released 30-June-2025
Bug Fixes

  • Editor: An "Unspecified error" exception is shown when changing the active Editor tab.
  • Schema Compare: False trigger diffs when comparing old to new database versions
  • AI: Access violation after license dialog is shown

Enhancements

  • AWR Reports: Added option to choose between DBA and CDB views
  • Support Bundle: Added support for Windows Server 2025

Toad Beta 25.3.92.6435, Released 23-June-2025
Bug Fixes

  • Editor: AI Explain panel throws error if JavaScript disabled
  • Export Dataset: "Autodetect schema and table" acts like it's checked even if unchecked
  • Export Dataset: Invalid characters not removed from sheet name when exporting to Excel
  • Execute procedure: Cursor output dialog staying on top of all other dialogs and apps
  • Schema Browser: Ellipsis button missing in FK-lookup button on data tab
  • Schema Browser: Access violation after changing display filter on SB-Tables-Partitions

Enhancements

  • High-DPI support is now enabled by default.
  • Schema Browser: Filtering added to Users/Roles RHS
  • Toolbars - Filtering added to the customization dialog

Toad Beta 25.3.75.6376, Released 16-June-2025
Bug Fixes

  • Connections: Set Container command not running in newly created data grid sessions

Enhancements

  • Connections: Lock icon now appears on connection bar button if connection is encrypted or connected via SSH configured within Toad
  • Connections: Login window grid now shows SSH, TCPS, or Native in the "Security" column
  • Database HTML Doc Generator: Updated look
  • Connections: "Change Session" button dropdown items can now be sorted
  • Export DDL: "Another Schema" added as a new destination option

Toad Beta 25.3.55.6305, Released 9-June-2025
Bug Fixes

  • Dark Mode: Grid color changes after options opened
  • Dark Mode: Encryption message in login window difficult to read because of dark text on dark background
  • Dark Mode: SSH button on login window missing its icon
  • Editor: Bookmarks disappear after changing drawing style
  • Editor: Leading comments move far to the right when formatting a text selection
  • Export DDL: When extracting constraints to individual object files, 2 files for FK constraints were created
  • Export Utility Wizard: Hint added to "Query" tab
  • Generate Schema Script: Access violation when double-clicking on node expansion icon in results
  • TK Prof Wizard: Step labels not clickable

Enhancements

  • High DPI Support: We are in the process of updating Toad to fully support high DPI displays, with scaling set to anything higher than 100%. Mostly, it works great, but a few painting/scaling issues still exist. You can enable it at Options -> General.
  • SVG Icons: Along with high DPI support, we are in the process of updating all of our icons from bitmap to SVG. This will allow them to look crisp and sharp at any scaling. Not all icons are converted yet. We are about 75% done. You can enable this at options -> General.
  • Connections: "Connect as" added to color suggestion rules
  • Connections: Connection Dropdowns (as in Export DDL, Single Object Compare and other places) now contain a "recent" section
  • Export DDL: Look/feel updated
  • Export DDL, Generate Schema Script, Compare Schemas: These are now much faster when extracting DDL for thousands of objects
  • Schema Browser, Object Palette: Now able to display SYS views for databases which are mounted but not opened
  • Schema Browser: Favorites can now be drug in more easily. Also drag/drop to rearrange objects is now supported
  • Schema Browser: Unified Audit Policy "Enablement" tab now displays success/failure
  • Session Browser: Kill/Disconnect/Start Trace options now have a "Show SQL" button
  • Toad is now more responsive when switching from one maximized window to another

The change log for Toad version 25.2 is here

5 Likes