Toad for Oracle 2026 R2 Beta

Toad for Oracle - Beta
1

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

How to join the Beta program:

  1. Read the Beta Agreement. Downloading the Toad Beta constitutes usage agreement.
  2. Install Toad for Oracle version 26 R1 for Windows first.
    a. This must be a licensed, non-trial version
    b. Run version 26.1 at least once before running the beta.
    c. Leave 26.1 installed. The beta does not replace it.
  3. Download and install the beta (links below)
  4. Please post suggestions or problem reports to this forum. The development team reads every post and typically responds very quickly.

Which version?

If you use a 32-bit Oracle client:

If you use a 64 bit Oracle client (or no Oracle Client at all):

Expiration and Release Schedule

  • Each beta expires after 4 weeks
  • New betas 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).
  • Stay up to date with the latest beta and you'll be able to use it until the next version of Toad is officially released.

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.
  • Some newer (19/21) client/server combinations throw ORA-03120 when querying XMLTYPE in Toad. Details and workarounds here.

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.
    • No issues with XMLTYPE
    • 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

36

Toad Beta Change Log

The 2026 R2 Beta cycle is complete and Toad version 2026 R2 is planned to be released on July 28th. We thank you for your inputs.

The change log since 2026 R1 is below.

Bug Fixes

  • AI: Occasional access violation after using CoPilot
  • Alter Table: Access violation if 'X' button clicked while window still loading
  • Alter Tablespace
    • Text cut off in "offline" dialog
    • Access violation if "Add datafile" clicked while window opening
  • Audit Objects: Privileges dialog incorrectly appears after lost connection
  • Code Analysis: Object install dialog shows incorrect connect string in no-client mode
  • Compare Databases: Recompare causes access violation on shutdown
  • Compare Multiple Tables
    • Access violation if target DB not connected when window is opened
    • DB Links requiring double-quotes caused errors
    • LOBs not skipped when using DB Link if option to skip unsupported columns is selected
  • Compare Schemas
    • "List index out of bounds" error when previewing diff details
    • Recompare causes access violation on shutdown
  • Connection Bar: Occasional access violation on right-click
  • Connection Dropdowns: Selection allowed if connection cannot be made
  • Connections
    • "Cannot Create File" error when connecting direct mode with an Oracle client and using a wallet
    • "One/Toad" window setting caused connection to change when opening an already-open window
    • Lost connection not handled well in SB-Tables-RHS data and stats tabs, and also export dataset
  • Create/Alter Profile: Incorrect terminology was used in the GUI
  • Customize Toolbars Dialog
    • GUI space wasted for unused "Description" section
    • Last item on "commands" tab not selected when clicked
  • Dark Mode
    • AI Explain not displayed correctly in dark mode
    • Background color of Tablespace map didn't follow color scheme
    • Colors not consistent in various kinds of edit controls
    • Occasional access violation in schema dropdown
  • Data Compare: SQL error when comparing LOBs on 10g
  • Data Grids
    • Multiple "Fetch all rows" confirmation prompts when filtering
    • Numbers sorted as alpha in memory sorting mode
  • Debugger: Running SQL and showing unnecessary mouseover hints for text elements which are not variables
  • Describe Package CTRL+Click package name access violation
  • Editor
    • "Invalid pointer operation" after F9 with multiple statements selected
    • Bind variable dialog gives "Failed to set calendar date or time" when Windows date format is set to Turkish
    • Code Insight and Code Snippet popups sizing problems on first display when color themes enabled
    • Dark mode not painting tabs dark for ExtraFlat, UltraFlat and Office11 tab style
    • Desktop toolbar gets larger over time
    • Icons for "Increase/Decrease Indent" buttons were reversed
    • Occasional access violation when opening window or changing tabs
    • Random code insight access violation fixed
  • Explain Plan: Create/Find table dialog staying on top of other apps
  • Export Dataset: Fixed Field widths does not consider column name width for NUMBER datatype columns
  • Export DDL: Slow SQL in some cases when extracting DDL for a single table
  • Generate Schema Script: Scheduler objects not loading after parent node toggled
  • High DPI: Threaded query activity indicator did not scale
  • Internal Logging: Debug log file only contains last 4 messages
  • Licensing: Exception needlessly raised on network timeout when restoring online status
  • Log Miner: V$_ARCHIVE_LOG rows without filename were wrongly provided as choices
  • Log Switch Frequency Map: Color settings not always used
  • LogMiner: Selecting of files sometimes returned blanks
  • Misc Controls: Missing the blue "focused" indicator
  • Options:
    • Refresh Schema Browser options always show as unchecked
    • Schema Browser refresh options not reflecting actual value
  • Project Manager: Quick filter did not support cut/copy/paste
  • Rebuild Tables: LOB storage clause not removed when changing column datatype from CLOB to VARCHAR2
  • Schema Browser
    • "Rename View" button enablement wrong when logged in as SYSDBA
    • Access violation during DPI change
    • Filter/Sort dialog producing invalid SQL for NVARCHAR2 columns
    • Incorrect units in Freespace tab for temporary tablespaces
    • Occasional access violation after dropping objects in treeview mode
    • RHS Constraints tab not showing constraint text after grid reset
  • Schema Compare: Column datatype not compared in materialized views
  • Schema DropDowns:
    • Dropdown box slightly misaligned
    • Toad lost focus when dropdown appears
    • Should pop up instead of down when close to bottom edge of display
  • Session Browser
    • Not closing immediately after Locks tab used
    • Access violation when manually resizing columns by right-click after making them not visible.
    • Inst ID info missing from Lock Details column in RAC
    • Last_Call column shows current time for all rows
    • Loads slowly when there are thousands of sessions to display
    • Parallel query nodes were expanded by default
    • Parallel RAC sessions not displayed as child nodes
  • Sign in: Occasional Browser timeout error
  • Single Object Compare: Sync Script not enabled in Toad XPert edition
  • SQL Recall: Status bar font scaled incorrectly
  • Startup
    • Error when running multiple copies of Toad under CyberArk
    • Occasional "system error 87"
  • Team Coding: Access violation when breaking locks if VCS not configured
  • TNSNames Editor: Does not handle files with errors as well as 25.3 and prior. Some TNSNames entries are missing, and errors not displayed on Syntax Check
  • Toad on Mac: High DPI and SVG not displayed will with Toad color themes enabled
  • UTPLSQL: Slow refresh of annotation cache causing Toad DDL script creation to be slow
  • Workspaces
    • List Index Out of Bounds error if workspace dropdown clicked while file is locked
    • Package code becoming doubled when file has split tags

Enhancements

  • AI: Added "Toad Chat" window
  • Accessibility: Improved screen reader support in many windows in Toad. This is a work in progress that will continue until complete.
  • Automation Designer: Execute Script action - added note about Oracle session
  • Compare Multiple Tables: Provide a script to create ACL if needed to use DB Link
  • Connections: Added "Bypass save prompts" in close connection confirmation dialog (when you hold down SHIFT and choose "close connection"). Checking this is similar to what happens with fast shutdown. We just close the connection as quickly as possible and don't prompt to save your work
  • Data Grids: New Search/Filter Panel - searches every row and column. Disabled by default. Choose Right-Click -> Appearance to show it
  • Database Links: Added support for Credential objects
  • Debugger: Make mouseover hints optional and make delay period configurable
  • Editor:
    • Added "Next Edit" copilot suggestions
    • Editor: Improved active tab contrast in several dark modes
  • Explain Plan: Added option to use Oracle's built in plan table by default, and use Toad's plan table only if Oracle's isn't found
  • Generate Schema Script:
    • Added debug logging messages
    • Improved the SQL for table columns when a filter is in use
  • Log Miner:
    • Add ability to browse Oracle directory for files to mine
    • Miner: Add ability to paste in names of files to mine
    • Minor GUI improvements
  • Main Menu: Font style/size is now configurable in Options -> Toolbars/Menus
  • Misc: Edge Browser now used internally instead of Internet Explorer
  • Options: Added option to control incremental filtering options (on/off, partial match, highlighting) on object name dropdowns
  • Schema Browser:
    • Profiles: Added Resource Type to RHS Info tab
    • DDL scripts now created faster
    • Display PASSWORD_CHANGE_DATE field for users
    • Remember last used quick filter type (Wildcard/Regex)
    • Tablespaces: SHIFT+Delete now checks options in drop tablespace dialog
  • Session Browser: Added options for default expansion state
  • TNSNames Editor: Now identifies duplicate entries when you click "Syntax Check"
  • View Scripts: Get View source from TEXT_VC if possible when DBA_VIEWS.TEXT is null
  • Window captions: Add just "Database" as a caption text option

The change log for Toad version 26.1 is here