Toad for Oracle 2024 R2 Beta

We are pleased to announce the Toad for Oracle 2024 R2 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.

Instructions for joining the Beta program:

  • Read the Beta Agreement. Downloading the Toad Beta constitutes usage agreement.

  • Install Toad for Oracle version 17.1 for Windows (Non-subscription) and run it at least once. Do not uninstall 17.1 before installing the beta. The beta does not work without the most recent GA version also installed.

  • IMPORTANT: Do not install Toad Beta into your commercial Toad folder. Just accept the default folders when installing the beta.

  • The beta change log is 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 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, and Oracle Wallet connections.
    • Can connect to every database version since 7.3!
  • Cons of no-client option:
    • Not supported: tracing/logging, proxy connections.
    • 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 in any way.

The beta change log is below


Toad Beta Change Log

Toad Beta, Released 10-May-2024

Bug Fixes

  • Automation Designer: Export Dataset actions erroneously throwing "Parameters out of sync" message Link
  • Editor: Grid not allowing edits if OCI Array Buffer Size set to Manual. Link
  • Main Form: Size/Position not always restored correctly Link
  • Session Browser: RHS refresh delay is annoying Link


  • Editor: Added ability to fold all regions at any level Link
  • Editor: Added some "copy to clipboard" options for Explain Plan Link
  • Oracle 23ai: Added support for Logical Partition Tracking. Note, this requires the READ privilege on the table SYS.TABLOGICPART$. Hopefully Oracle will give us some standard USER/ALL/DBA views for this data soon.
  • Oracle 23ai: Added ability to open pluggable databases in Hybrid Read Only mode
  • Oracle 23ai: Added support for hybrid partitioned tables with interval and auto list partitioning
  • Oracle 23ai: Added ability to rename LOBs w/o moving them
  • Oracle 23ai: Added support for concurrent refreshes in MVs
  • utPLSQL: Version now supported

Toad Beta, Released 3-June-2024

Bug Fixes

  • Alter Unified Audit Policy: "Disable" not working
  • Add/Edit Login: TNS dropdown not loaded unless TNS_ADMIN specified
  • Blob Viewer: Viewing PNG data as PDF caused Toad to freeze
  • Compare Databases: Revoke Role above the comment for that role
  • Export DDL: Not Null constraints missing from script for object tables
  • Misc Internal SQL: Not always using SYS. with data dictionary view names
  • Schema Browser: SQL error when listing DOMAINS


  • Compare Databases: Added preview panel
  • Manage User Settings: Added ability to restore individual settings from backup
  • Oracle 23ai: Added support for read only users
  • Oracle 23ai: Added support for enable/disable dictionary protection
  • Oracle 23ai: Added support for individual columns in Unified Audit Policies
  • Oracle 23ai: Added support for VECTOR datatypes
  • Oracle 23ai: Added support for VECTOR indexes
  • Oracle 23ai: Added support for staging tables
  • Schema Browser: Added option to adjust node heights
  • Team Coding: Added "Locked by" field in SB RHS and Editor
  • Team Coding: Added option to use OS User or login schema as lock user

Toad Beta Released 28-May-2024
Bug Fixes

  • Error on startup if color themes enabled

Toad Beta Released 28-May-2024
Bug Fixes

  • Code Analysis: Access violation if window closed too quickly
  • Editor: Errors thrown if attempting to step into Java Source while debugging with JDWP
  • Export DDL: private synonyms excluded when getting script for multiple users
  • Export DDL: Object Table Substitution clause left out of table scripts
  • Schema Browser: SQL error when clicking system tablespace
  • Session Browser: Blinks on refresh
  • Workspaces: Describe Objects window focused after loading workspace


  • New version numbering system: Year.Release.Build.Internal
  • Database Compare: Added preview panel for differences
  • Manage User Settings: Added ability to recover specific items from backup
  • Schema Browser: Added icons to indicate Unified Audit Policy enablement
  • Schema Browser: Added ability to enable/disable Unified Audit Policies
  • Single Record View: Table name is now displayed when launched from Editor

The change log for Toad version 17.1 is here