Toad for Oracle 2026 R3 Beta

Toad for Oracle - Beta
1

We are pleased to announce the Toad for Oracle 2026 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 2026 R2 first.
    a. This must be a licensed, non-trial version
    b. Run version 26.2 at least once before running the beta.
    c. Leave 26.2 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.

Versions

Windows, if you use a 32-bit Oracle client:

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

Mac:

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.
    • XMLTYPE works without errors, but can load query results slowly if there are lots of rows returned. As a workaround, you can uncheck the "Use Native XMLTYPE" option. Details here.
    • 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

Toad Beta 26.3.202.10065, Released 9-Nov-2026

Toad Beta 26.3.194.10042, Released 2-Nov-2026
Bug Fixes

  • Toolbars: Embedded checkboxes scaled wrong in some multi-display environments
  • Licensing: Trial banner displayed when user has commercial key
  • AI: MCP session timing out

Enhancements

  • Chat: Allow rename chat sessions
  • AI: MCP can now use Toad's DB connections

Toad Beta 26.3.184.10003, Released 26-Oct-2026
Bug Fixes

  • Alter Datafile: Calculate Minimum Size wrong if file cannot shrink at all
  • Alter Datafile: Form position wrong
  • Editor: Reload file forgets split choice and prompts again
  • Editor Data Grid -> Report causes access violation
  • Manage User Settings backup: Non-default files excluded for Project Mgr and Database Browser
  • Manage User Settings: Recover from backup not working
  • SQL Tracker: Formatting not working in 64 bit
  • SQL Tracker: Error message on startup for non-English locales
  • SQL Tracker: Not all processes shown in more than 512 total processes on server

Enhancements

  • Editor: Add "whole word only" option for highlighting selected text matches

Toad Beta 26.3.169.9947, Released 19-Oct-2026
Bug Fixes

  • Compare Schemas: NOT NULL constraints showing if schema loaded from snapshot file and constraints option unchecked
  • Compare Schemas: Side-by-side preview panel not always displaying content
  • Create View: "Force" option did not work
  • Object Search: Schema List spaced badly on some displays

Enhancements

  • Compare Schemas: Added option to hide constraint names in side-by-side preview panel
  • Data Grid: Search box now has extended search capabilities. (To enable, right-click -> View -> Search box)
    • Value1 Value2 searches for records that contain Value1 or Value2. Values may belong to different fields.
    • +Value2 requires the specified word to be present. Example: apple +red means the record must contain red and may also match other terms in the expression.
    • -Value2 excludes records that contain the specified Value2. Example: apple -green excludes rows that contain green.
    • % is a wildcard for any number of characters. Example: N%1 can match values that start with N, continue with any sequence of characters, and end with 1.
    • _ is a wildcard for exactly one character. Example: ab_d matches strings where exactly one character appears between ab and d.
  • Editor: Load DB Object window's data grid seach box now visible by default

Toad Beta 26.3.157.9906, Released 12-Oct-2026
Bug Fixes

  • Create Explain Plan Table Dialog - Access violation on ESC
  • Create Unified Audit Policy: Access violation when double-clicking in Advanced Enablement grid to remove last user
  • Data Grid: Edited text in current row discarded on Find Next
  • Data Grid: Errors with unknown time format
  • Data Grid: Find Next places found row near bottom of grid, rather than the middle
    Schema Browser: Occasional List Index Out of Bounds error on SB-Tablespaces-RHS-Objects
  • Schema Browser: Field "SCHEMA" not found in SB-Users-RHS-Schema Privs
  • Session Browser: Access violation if change tabs after using the search box

Toad Beta 26.3.142.9843, Released 5-Oct-2026
Bug Fixes

  • "File in Use" errors on startup of 2nd copy of Toad if 1st started as admin and 2nd non-admin

Enhancements

  • Toad restart no longer needed if proxy configuration changes
  • Toad Chat: Added ability to pin conversation history
  • Support Bundle: Added Date Format info

Toad Beta 26.3.132.9796, Released 28-Sept-2026
Bug Fixes

  • ADDM Report: "Not a valid integer" error when pasting a too-large value for target snapsot
  • Connection Comboboxes: Access violation when selecting by keyboard
  • Data Compare: Form Context wrong when selecting Query as source
  • License dialog: Access violation on clicking the "license agreement" link
  • Misc windows: Access violation on incremental search
  • Options: Thousand/Decimal separator option not painting correctly
  • Single Object Compare: Target Object Name dropdown not always loading
  • Single Object Compare: Running unnecessary SQL when selecting new objects after first comparison
  • Statspack Browser: Access violation after ESC in Modify Settings dialog

Enhancements

  • Editor: On "Save All", save tabs with filenames before tabs which require a prompt for filename
  • Pinned Code: Lower tree now includes triggers and search box
  • Accessibility: Improved screen reader in the following windows
    • Create User Type
    • TC Status Viewer
    • TNS Names Editor
    • DB Probe Add Alert
    • File Compare Options
    • Pinned Packages
    • Toad Advisor

Toad Beta 26.3.105.9664, Released 21-Sept-2026
Bug Fixes

  • Color Comboboxes: Required 2 clicks to use
  • Schema Browser: Resource Plan RHS Access violation
  • Schema Browser: Treeview access violation
  • Export DDL: Access violation when closing
  • Project Manager: Many icons wrong
  • Data grids: Search box icon and text hint not visible in dark mode

Enhancements

  • Accessibility: Improved screen reader in the following windows
    • Generic Listbox dialog (used from many places in Toad)
    • Options -> Data grids -> Visual Styles -> Edit -> Advanced
    • Import Table Data -> Expression Builder
    • Options -> Editor -> Font and Styling -> RHS
    • Editor -> Edit Macros
    • Editor -> Script Output -> Errors tab
    • Editor -> Call stack dock frame
    • Project Manager: connections box and filter edit box
    • Project Manager: pick action dialog (drag/drop a node and it prompts what to do)
    • Import Table Data Expression Builder
    • Main menu - Session -> Schema Browser Filters (LHS of this dialog)
    • Describe -> Open
    • SB-Dimensions-RHS-Info tab
    • SB-Favorites-Add-Select folder dialog
    • Create/alter user->Schema Privs -> Add
    • TNSNames Editor -> Messages box (and filter box)
    • Create/Alter Unified Audit Policy -> RHS listboxes after selecting an "Action" on the left

Toad Beta 26.3.94.9606, Released 14-Sept-2026
Bug Fixes

  • Proxy authentication form: fixed parenting and added error message when form not shown
  • Options-Data Grids-Data: Native XMLTYPE option not remembered
  • Schema: Fixed some SQL errors in old Oracle versions (9i and older)

Enhancements

  • Accessibility - improved screen reader support in start/back/next buttons throughout Toad by using icons instead of less than/greater than characters
  • Accessibility - screen reader support added in the following windows
    • Undo Advisor
    • Export Dataset -> rt-click on "filename" field -> Select Variable -> Add
    • Automation Designer -> Compare Files
    • Automation Designer -> Format Files
    • Code Analysis Metrics History
    • Code Analysis -> turn on the "insert into db" option. Load some objects. Run. The "Run Name" dialog.
    • Options -> Code analysis -> edit rule sets -> Create new rule set
    • Profiler Chart properties
    • Project Manager Local Folder properties dialog
    • Project Manager URL properties dialog
    • SQL Recall Import dialog
    • Schema Browser Edit Query
    • Schema Browser Tablespaces -> Move Datafile (2 dialogs here, one for 12c and newer, one for older than 12c)
    • Schema Browser Window Open/Close dialog
    • Data Grid AnyData popup editor
    • Login window custom fields dialog
    • Java to PLSQL import
    • Browse File by FTP (launched from the TKProf window)
    • Project Manager Select File
    • Create Object Type
    • Task Scheduler - > Task Wizard and Task Properties dialog
    • File Compare (single line comparison)
    • Export Wizard (tablespaces tab)
    • Tablespace Map Restrictions
    • Tablespace Map Segments
    • Service Manager
    • External Tool Auto Add dialog
    • Options -> Network Hosts

Toad Beta 26.3.86.9676, Released 8-Sept-2026
Bug Fixes

  • Connections: Not able to connect using TCPS without an Oracle wallet (this config is used with Oracle autonomous serverless DB)
  • Compare Schemas: Hint on the "Formatting" option wasn't clear
  • Compare Schemas: Multi-schema applied incorrectly if already present when target database is selected
  • Compare Schemas: never completed in multi-schema mode with auto-match and run from Automation designer without GUI
  • Editor: Recover files feature adding extra BOM to files
  • Schema Browser: Expire Account confirmation has wrong caption

Enhancements

  • Connections: "Password expired" dialog now has separate fields for user and database (or host/port/service name)
  • Connections: "Account Locked" dialog now has separate fields for user and database (or host/port/service name)
  • Data Grids: Reorganized Right-click "Appearance" menu
  • Options: "Color Schemes" feature renamed to "Themes"
  • Schema Browser: Improved filtering on RHS Dependencies tabs
  • Schema Browser: Added ability to specify shortcut for "Copy selected column names to clipboard"
  • Toad for Mac: Text files now opened with native text editor

Toad Beta 26.3.72.9499, Released 31-Aug-2026
Bug Fixes

  • Master-Detail Browser: Column names not quoted in filter/sort dialog
  • Master-Detail Browser: "Sort ASC by...." gives list index out of bounds for quoted columns
  • Code Snippets: CTRL+C not working correctly
  • Editor: Find dialog reverting to prior value after ESC
  • Database Probe: Access violation with RAC

Enhancements

  • Accessibility: Screen reader support added in the following windows
    • Team Coding Config - Code Analysis options
    • Team Coding installer
    • Team Coding Git Login
    • Team Coding SVN Login
    • SQL Firewall
    • Task Scheduler
    • Editor - Watch Properties
    • Explain Plan
    • Explain Plan Compare
    • Export File Browser
    • FTP
    • TKProf - open file with FTP
    • Schema Browser custom query editor
    • Create/Alter Unified Audit Policy misc dialogs
    • Create/Alter User misc dialogs
    • Schema Browser misc dialogs
    • QSR

Toad Beta 26.3.63.9463, Released 24-Aug-2026
Enhancements

  • Connections: Password dialog shows Host/Port/Service name for direct connections and auto-resizes to fit the longest text
  • "Set Parameters" dialog: Now has icons for subprocedure type, incudes overload numbers, and can be sorted by clicking column header
  • TNSPing: SQL*Plus, if version 23 or newer, is can now be used instead for TNSPING purposes if TNSPing is not present (which it is not in an instant client)
  • Accessibility: Screen reader support added in the following windows
    • Code Analysis rule builder dialog
    • Code Road Map misc dialogs
    • Data Duplicates
    • Editor - Breakpoint properties dialog
    • Editor - Evaluate Watch dialog
    • Editor/Schema Browser - Set Parameters dialog
    • ER Diagram - misc dialogs
    • External Tools Properties Dialog
    • JDWP: Database Connection, Host, Breakpoint dialogs
    • Job "What to Execute" dialog
    • Options -> Sensitive Data Search Rules
    • Password dialog
    • Project Manager Config
    • Query Builder - misc dialogs
    • Save Desktop/Workspace dialog
    • Select Variable Dialog

Toad Beta 26.3.47.9387, Released 17-Aug-2026
Bug Fixes

  • Editor: Can't debug against Oracle autonomous serverless databases
  • Explain Plan: Toad crashed for some users

Enhancements

  • Beta is now available for Toad on Mac
  • Accessibility: Added screen reader support in the following windows:
    • NLS Parameters (when connected to RAC - the "Instance" tab has a combobox)
    • Object Palette
    • Options -> Oracle -> General -> DBMS Output -> Font
    • Options -> Online/AI -> Proxy Settings
    • Options -> Online/AI -> Proxy Settings -> Auth settings
    • Proxy Login Dialog
    • Schema Browser -> Tablespaces -> RHS -> Objects -> Rebuild Selected Objects
    • Editor File Recovery Dialog -> Recovery Options Dialog
    • Redo Log Manager -> Add Log Group dialog
    • Reports Manager -> Import dialog
    • Script Manager -> Add Script dialog
    • Script Manager -> Edit Script dialog
    • Find in Files/Editors
    • Shared Pool Browser
    • StatsPack/AWR Browsers (including the "new chart" dialog)
    • Automation Designer -> Bulk edit action properties
    • Estimate Table/Index Size -> Click the pencil icon to edit
    • Export Wizard
    • Options -> Data Grids -> Visual -> (rhs) Styles -> Edit -> Simple
    • Database Monitor
    • Database Monitor Options dialog
    • Describe Objects -> Save List of Described Objects
    • Instance Manager

Toad Beta 26.3.34.9327, Released 11-Aug-2026
Bug Fixes

  • Data Compare: Flicker when in dark mode and switching windows
  • Dark Mode: Data grid font size incorrect on first run after switching to dark mode
  • Export DDL: Access violation if can't connect to database
  • Debug Privilege Check: Access violation if not connected to database
  • Options: Default Schema labels operlapping
  • Schema Compare: Column order diffs not detected
  • Session Browser: Occasional "file in use" errors
  • Schema Browser: Table Filter/Sort dialog not showing columns in alpha order
  • Generate Schema Script: Options tree jumps the first time clicked
  • Schema Browser: Rename object and Add column to table not quoting object names consistently

Enhancements

  • Blob Viewer: Added Frame Index support for TIF and other image types
  • Blob Viewer: Added SVG Image support
  • Export DDL: Added FORCE option for TYPE scripts
  • Accessibility: Added screen reader support in the following windows:
    • Administer Tablespaces
    • Analyze Objects
    • Automation Designer - Archive
    • Automation Designer - Compare Multiple Tables
    • Automation Designer - Copy Table Data
    • Automation Designer - Data Pump Export
    • Automation Designer - Data Pump Import
    • Automation Designer - DB Health Check/Scan
    • Automation Designer - Email
    • Automation Designer - Export Dataset
    • Automation Designer - Export DDL
    • Automation Designer - File Iterator
    • Automation Designer - Folder Iterator
    • Automation Designer - Import Table Data
    • Automation Designer - Message
    • Automation Designer - Object Search
    • Automation Designer - Pause
    • Automation Designer - Run Report
    • Automation Designer - Single Column Export
    • Automation Designer - Single Column Import
    • Automation Designer - Create Variable
    • Automation Designer - Test Variable
    • Automation Designer - TNS Ping
    • Automation Designer - Variable Prompt
    • Editor Find Dialog
    • Export Table to Flat File
    • Generate Table Data
    • Manage User Settings
    • Master-Detail Browser
    • Options -> Sensitive Data Search -> Search Rules -> Add a role
    • Oracle Parameters
    • Oracle OEM Warning dialog
    • Object Search
    • Redo Log Manager -> Alter system archive log... dialog
    • Rebuild Table
    • Rebuild Multiple Objects
    • Save/Load window snapshot dialog from actionized windows
    • Schema Browser -> Constraints - Alter Constraint
    • Schema Browser -> Recycle Bin -> Purge
    • Schema Browser -> Unified Audit Policies -> Right-Click -> Enable/Disable
    • Segment Advisor
    • SQL Recall
    • Space Manager Setup
    • TC Administration
    • TC Administration -> Azure Devops Services Login
    • TC Administration -> Subversion Login
    • TC Administration -> Add Project
    • TC File Extension
    • Trace File Browser Open File dialog
    • Utplsql - Install wizard
    • Utplsql - Create Unit Test dialog

The change log for Toad version 26.2 is here