Toad for Oracle 16.3 Beta

We are pleased to announce the Toad for Oracle v16.3 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 Beta code constitutes usage agreement.

  • Install Toad for Oracle version 16.2 (Non-subscription) and run it at least once. Do not uninstall 16.2 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.

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.

A change log is below

8 Likes
Beta Released (13.2.0.16)
Beta Released (13.2.0.37)
Beta Released (13.2.0.4)
Access violation at address 00000000046DB240 in 'Toad.exe' (Toad for Oracle Xpert v 13.0.0.80)
TOAD_FILE_CHUNK split issue (tfo v13.1.0.78)
Beta Posted (16.1.52)
Beta Released (14.2.35)
Toad for Oracle Version 14.0
Beta Released (14.2.102)
Beta Released (15.0.42)
Export Dataset -> Display all results in grid -> Default Value not saved
BUG: Quick describe / CTRL+D bugg
Beta Posted (16.0.83)
Beta Released (15.1.52)
Export dataset multiple queries
Beta Released (14.2.17)
[16.0.90] revoke privilege doesn't work from schema browser
Automation Designer Change Connection
Beta Released (15.1.61)
Beta Released (15.1.64)
Option problem: Desktop SQL o PLSQL
Team coding toad 14.0 not compatible with 14.1
Beta Released (15.1.67)
Export dataset multiple queries
Beta Posted (16.2.54)
JSON syntax error (conversion Collection type to Clob)
Beta Released (14.2.87)
Object Type LHS drop down won't work on extra monitors
Toad Script execution very slow
Beta Posted (16.2.64)
Beta Released (14.2.93)
Beta Posted (16.2.77)
Beta Released (15.1.75)
Beta Posted (16.2.72.1705)
Beta Posted (16.2.92)
Beta Posted (16.2.85)
Menu Animation Fade Effect
Toad for Oracle 14.1 - Shortcut changes not working
Automatic reconnect
Beta Posted (17.0.22)
Access violation toad.exe
Beta Posted (16.3.8) *Version Change - Please Read*
Beta Posted (17.0.34)
Beta Posted (16.3.19)
Beta Posted (16.3.29)
Toad popup window do not show all records
Dark Mode in Toad12.6
Dark mode performance
Beta Posted (16.3.60)
Beta Posted (16.3.41)
Beta Posted (16.3.65)
Saved Workspace with split screen in one of the editor tabs
Beta Released (15.1.84)
Beta Released (15.0.37)
Toad 14 Editor loses a character
TOAD 13/14 - Leading tabs in the editor truncate the sql statement by 3 characters
Beta Released (15.1.86)
"Next/Previous Navigator Node" keyboard navigation do not work
Beta Released (15.0.33)
Beta Released (15.0.47)
Beta Released (15.0.55)
Beta Released (15.0.61)
Beta Released (15.0.69)
Beta Released (15.0.66)
Beta Released (15.0.78)
Beta Released (15.1.92)
Beta Released (15.1.104)
Beta Released (15.1.111)
Beta Posted (16.0.4.1390)
Beta Posted (16.0.9)
Beta Posted (16.0.12)
Beta Posted (16.0.16)
Beta Posted (16.0.25)
Describe dialog size/location
Beta Posted (16.0.36)
Opening files with existing /*<TOAD_FILE_CHUNK>*/
Toad 13.1.0 Schema Browser RHS shows wrong object
Java compile F9 ORA-24344: success with compilation error
Bug in New toad version compare to very old version
Toad for Oracle blocked by VPN
Beta Posted (16.0.47)
VARCHAR2 values not DESC correctly in Toad
VARCHAR2 values not DESC correctly in Toad
Beta Posted (16.0.53)
Toad 15.1 schema Browser Public synonyms - out memory
Beta Posted (16.0.64)
On Monday, you can do this
Toad showing incorrect TEMP tablespace / datafile size
Beta Released (16.0.74)
Comparing schemas: list indexes with table creation scripts
Trace File Browser blocking
Toad for Oracle New Unit Testing Capability Available in Beta
Connection error External exception C0000006
Toad for Oracle appears an alert with ORA-29275: partial multibyte character when i execute session browser feature on Toad for Oracle.
Toad for Oracle New Unit Testing Capability Available in Beta
TOAD Memory Leak & Crash on SB Synonyms
BUG: data editing fat fingered bummer
AV on Explain Plan using Threaded query session
Old BUG: Table Rebuilder removes INTEGER numeric type
How to display the actual execution plan of the last executed query using dbms_xplan.display_cursor?
Export dataset with XMLTYPE column
ORA-01775: looping chain of synonyms with TOAD_PLAN_TABLE
Schema Compare doesn't generate script for table diffs
Nested Table Edit always shows one row
Object Palette does not conform to Windows Display setting for High Contrast
Object compare jumps pages
AutoConnect doesn't work on TOAD 13.2
Schema compare default collation difference
Unable to edit dataset of query in Editor
Naming Excel sheets when Exporting data from SQL Queries
Automatic update fails
Beta Posted (16.0.86)
SQL-Error when comparing a single object
Access violation at address 00000000041A44AB in module 'Toad.exe'. Read of address FFFFFFFFFFFFFFFF
TOAD for Oracle 15.1 and 16.0 BETA - Issue with Synonyms Tab in Schema Browser
Toad for oracle 15.1.113.1379 tnsnames editor not working
Toad 13.3 session browser does not work properly on RAC
Batch file for Toad
Toad 13.3 session browser does not work properly on RAC
Toad Editor behaviour copy paste ctrl chars
Tooltips in TOAD appear black
Error ORA-01741 when editing table (F4)
Beta Released (14.1.10.749)
Access violation 041A3E6C, TOAD shuts down
Displaying cached execution plan in "tree display" without inactive steps for adaptive plans
Beta Released (14.1.10.751)
Problems with Toad 14.0 crashing
Problems with Toad 14.0 crashing
Displaying cached execution plan in "tree display" without inactive steps for adaptive plans
Highlight hangs up Toad
Beta Released (14.1.22.778)
How to get the most out of this forum and support
TOAD 14 Export Dataset is broken
Toad for Oracle 14.1.10.751 Bug When Adding Constraint to View
Beta Released (14.1.30.790)
Expired 15.0.23.x?
Beta Released (14.1.39.807)
Toad Beta version 16.1.7.1521 is posted
Toad 13.1.1.5 getting ORA-22053
Toad 15.1.113.1379 - sFTP issue
Highlight hangs up Toad
Beta Released (14.1.42.811)
Problems with Toad 14.0 crashing
Problems with Toad 14.0 crashing
Beta Released (14.1.73)
Beta Posted (16.1.25)
Beta Posted (16.1.37)
Beta Posted (16.1.32)
Beta Released (14.1.54.830)
Beta Released (14.1.57)
Lockout with Oracle saved workspaces
Importing connection and passwords from 12.8 to 14.0
Dark Mode Cobalt - Current Tab Highlighting
Beta Posted (16.1.39)
Problems with Toad 14.0 crashing
Beta Posted (16.1.44)
Toad For Oracle 14.0 High sys utilization & crashing when idle
Beta Released (15.0.87)
Beta Released (14.1.84)
Search Results - Chinese (?) characters in Results grid
Beta Released (15.0.94)
Beta Released (14.1.96)
Running a build script - API Guard Error Function 5308
When clicking SAVE to save SQL - Export Dataset dialog pops up instead
Beta Released (14.1.108)
Pasting from Vim into the editor
Inconveniente despues de actualizar Toad 14.2
Beta Released (14.1.114)
Toad connection time when instance is down
Beta Posted (16.2.7)
Beta Posted (16.2.12)
Beta Posted (16.2.22)
Comportamiento exraño editor
Beta Released (15.1.24.1225)
Change of keyboard shortcuts doesn't work in TOAD 14
Beta Released (15.1.29)
Notification on SQL completion
14.2.104.1069 Toad Adds extract character (non-ASCII) when loading
Beta Released (14.2.43)
Ctrl + c broken in beta
Option problem: Desktop SQL o PLSQL
Beta Released (14.2.52)
Beta Released (14.2.55)
Beta Released (14.2.59)
Grid Popup Editor for Clob Values displaying corrupted data
Beta Released (14.1.114)
Beta Released (15.1.33)
Beta Released (14.2.65)
Beta Posted (16.2.34)
Dark Mode Coming to Beta on Monday!
Dark Mode Coming to Beta on Monday!
Beta Released (14.2.71)
Runtime Exception when running UnitTests
Running a build script - API Guard Error Function 5308
Import data - datetimefromstring
Beta Released (15.1.41)
Beta Released (14.2.73)
Big bug in rebuild table, Toad 14.1.120
'Not Responding' Freezes Session
Beta Posted (16.2.43)

Toad Beta Change Log

Notes:

  • Oracle clients: 12cR2 and 18c are the recommended client versions.
    • 19c and 21c will work, but are not recommended due to memory leaks with LOBs, as well as hangs when cancelling queries against 11gR2 servers.
    • 12cR1 and older clients don't handle XMLTYPE natively.
    • Toad's no-client option works well, and is a bit faster than using a client, but it has a few limitations such as Tracing/logging, proxy connections, and TCPS. However, LDAP, TNSNames.ora, Oracle Encryption and Data Integrity are all supported in no-client mode. This post has a good discussion about it. Uncheck the "Use Oracle Client" box on the login window to try it.
  • The beta version number changed from 17.0 to 16.3. If you have 17.0 installed, you must uninstall it before installing 16.3. You can copy 17.0 beta settings into 16.3 by using Utilities|Manage User Settings.

Beta 16.3.65.1875, Released 28-Nov-2022

Bug Fixes

  • Create/Alter Scheduler Job: "Parallel Instances" attribute missing
  • Schema Browser: Wrong popup menu on multiselect after using subobjects
  • Login window: Last connection not always remembered

Enhancements

  • Schema Browser: Flattened out toolbars

Beta 16.3.60.1870, Released 21-Nov-2022

Bug Fixes

  • Connections: Connection error dialog not displayed in no-client mode
  • Connections: "Invalid Release" error if Oracle version number has more than 5 digits
  • Dark Mode: Active connection color on window bar buttons difficult to see
  • Dark Mode: Grid lines difficult to see in some themes
  • Data Grids: ANYDATA causes access violation if it contains certain data types
  • Database Browser: Invalid connection attempt when no saved login info present
  • Editor: Run in QSR/SQL*Plus - not setting current schema
  • Export Dataset: Current_schema not always set
  • File Compare: Mini-map hard to see in dark mode
  • Find Dialog: Dialog gets smaller and smaller if used over RDP under varying screen resolutions
  • Schema Browser: Excessive scrolling in data tab on Shift+PgDown to select rows
  • Schema Browser: Function Based Indexes not displayed properly in SubObjects

Enhancements

  • Automation Designer: Added sample apps to demonstrate iterators and passing variables from one action to another
  • Connections: Added "Retry" button to connection error dialog
  • Create/Alter Materialized View: Added a way to set/clear refresh group
  • Dark Mode: Editor Gutter colors improved
  • Data Grids: Multi-cell paste is much faster now.
  • Editor: Mini-map feature added.

Beta 16.3.41.1848, Released 14-Nov-2022

Bug Fixes

  • Color Schemes: "Calypso" theme did not have enough contrast for selected cells in grid
  • Color Schemes: "Search Match" editor color hard to see
  • Color Schemes: Toolbar dropdowns checkboxes not always visible
  • Database Browser: Toolbar button behavior inconsistent if no connection present
  • Master-Detail Browser: Label too short for long table names
  • Schema Browser: RHS blank if opened with only one item in LHS list
  • Schema Compare: Sync script created public synonyms when it should not
  • Single Object Compare: Object Type dropdown causes a slow query

Enhancements

  • Color Schemes: Improved window switch performance
  • Data Grids: Added ability to paste a value into multiple cells

Beta 16.3.29.1831, Released 7-Nov-2022

Bug Fixes

  • DBMS_Output: Tabs not trimmed after 10th line
  • Export Dataset: "Invalid Pointer Operation" after cancel export to Excel File format
  • Generate Database Script: Roles not sorting for dependency order
  • Session Browser: "TOAD_SESSBROWFILTERS.ini is locked by another process" error

Enhancements

  • Automation Designer: Progress dialog is now optional for Execute Script actions
  • Export Dataset: Added GZip and 7-Zip compression formats
  • External Tools: Added macro for Active Editor Folder

Beta 16.3.19.1809, Released 2-Nov-2022

Bug Fixes

  • Automation Designer: Order of actions doesn't stick after drag-drop
  • Automation Designer: Drag/drop of actions sometimes wrongly allowed
  • Automation Designer: Non-responsive when opened not maximized
  • Color Schemes: Editor background color didn't update when color scheme changed
  • Color Schemes: Editor tab colors not consistent with other tabs in Toad
  • Color Schemes: Increased contrast on window/connection bar buttons in dark modes
  • Datagrids: CTRL+C including column headers. CTRL+Ins should do that.
  • Datagrids: Summary panel badly placed, scrolls out of view
  • Editor: ORA-06502 from DBMS_Output
  • Editor: Formatting loses cursor position in split Editor mode
  • Scheduled Task Wizard: Text cut off
  • Scheduled Task Wizard: Colors bad in dark mode

Enhancements

  • Automation Designer: Allow move of actions with CTRL+up/down arrow
  • Editor: Made look of splitters consistent with other splitters in Toad
  • Schema Browser: Filter/Sort dialog - make save size/pos optional
  • Schema Browser: Filter/Sort dialog - auto-add quotes for in/not in
  • Upper/Lowercase shortcuts: Now apply to all edit controls

Beta 16.3.8.1808, Released 24-Oct-2022

Bug Fixes

  • Data Grids: Mouse-wheel scrolling causes grouped grid to expand
  • Variables dialog: getting on top of other apps
  • Team Coding: SVN repository URL with trailing slash caused stack overflow
  • Files: New File Type not saved
  • Editor: SQL Desktop panels disappear after rearranging tabs

Enhancements

  • Editor: Added "Resolve Constants" feature (right-click -> Refactor)
  • Color schemes: Added several new color schemes

Beta 17.0.34.1788, Released 17-Oct-2022

Bug Fixes

  • Data Grids: multiline data only pastes first line
  • Color Schemes: Lilac Night theme lost on update from 16.1
  • Editor: Delay before execution of long script
  • Options: Unable to specify space for thousand separator
  • Schema Browser: color scheme painting problems on RHS deps tabs
  • Team Coding: Crash caused by extra slash in SVN repo URL
  • Workspaces: Toad crash when loading some workspaces

Enhancements

  • Editor: Context menu is now customizable
  • Schema Browser: DBA_LMT_FREE_SPACE now an option on Tablepsace RHS Files tab
  • Report Manager - use of parameters is now more clear
  • Statspack/AWR Browser: "New Chart" wizard updated to a newer look
  • Team Coding: A warning is now displayed if merging a table will cause data loss

Beta 17.0.22.1770, Released 10-Oct-2022

Bug Fixes

  • Automation Designer: DBMS_Output not available from script actions
  • Auto Optimize SQL: "Invalid password" given for globally authenticated users
  • Color Schemes: Current step not easily identifiable in wizards
  • Editor: Find Dialog - "Not found, retry" sometimes not shown
  • Editor: File modified prompt displayed too frequently for split packages
  • Editor: Hex Editor throws error if file is locked
  • Editor: "Rollback to savepoint" rolling all the way back
  • Export DDL: DBMS_IJOB being used when user does not have privileges
  • Schema Compare: Bad SQL when index and constraint renamed
  • Schema Compare: Bad SQL when moving LOBs
  • Team Coding: Excessive queries on startup
  • TSR: Execution error when calling from a different folder
  • Trace File Browser: Multi-file trace not handled
  • Window Pop Out: Connection info disappears from window title when popped out

Enhancements

  • Application Logging: Options -> General: All application logging can now be enabled here
  • Automation Designer: Added ability to cancel running actions
  • Automation Designer: Added Run Report action to run report from Reports Manager
  • Automation Designer: Added Single Column Import action
  • Automation Designer: Actions are now better organized on tabs
  • Copy User Settings:
    • Renamed to "Manage User Settings"
    • Added automatic backup of Toad settings
    • Added ability to recover some settings from backup when resetting
  • Data Grids: Improved popup menu -> Appearance
  • Editor: SQL Recall workflow improved and options centralized into a dialog
  • Editor: SQL Recall now includes semicolon when sending to editor
  • Export DDL: Added option to exclude "Bequeath" for views
  • HTML Schema Doc Generator: Updated to a newer look
  • Import Table Data: Updated to a newer look
  • Log Miner: Updated to a newer look
  • Login Window: "Test" now allows you to update passwords
  • Login Window: "Edit" now allows you to update passwords for multiple logins
  • Login Window: Tabbed by User/Server view styles now include a filter
  • Login Window: Export Connections - Removed obnoxious password hint
  • Schema Browser: Quick filter now supports regular expressions
  • Team Coding: Any out-of-sync Object IDs will now get remapped when user goes to TC Config window and clicks OK
  • TSR: Added no-client support

The change log for Toad version 16.2 is here

2 Likes
Beta Released (14.1.2.726)
Problems with Toad 14.0 crashing
Beta Posted (16.0.86)
Beta Released (14.1.84)
Beta Released (15.1.61)
Beta Released (14.1.114)
Beta Posted (17.0.22)
Beta Released (15.0.47)
Beta Posted (16.0.83)
Beta Released (15.1.86)
Beta Released (14.1.10.751)
Beta Released (14.1.30.790)
Beta Released (14.1.39.807)
Beta Released (14.1.108)
Beta Released (14.1.42.811)
Beta Released (14.1.73)
Beta Released (14.1.54.830)
Beta Released (14.1.57)
Beta Posted (16.1.52)
Beta Posted (16.1.44)
Beta Released (15.1.111)
Beta Posted (16.0.47)
Beta Released (15.0.87)
Beta Released (15.0.94)
Beta Released (14.1.96)
Beta Posted (16.2.7)
Beta Posted (16.2.12)
Beta Posted (16.2.22)
TOAD Menu Bug when Connection Lost
Beta Released (15.1.24.1225)
Beta Released (14.2.17)
Beta Released (15.1.29)
Beta Released (14.2.35)
Beta Released (14.2.43)
Beta Released (14.2.52)
Beta Released (14.2.55)
Beta Released (14.2.59)
Beta Released (15.1.33)
Beta Released (14.2.65)
Beta Posted (16.2.34)
Beta Released (14.2.71)
Beta Released (15.1.41)
Beta Released (14.2.73)
Beta Released (15.1.52)
'Not Responding' Freezes Session
Beta Posted (16.2.43)
Beta Released (15.1.64)
Beta Released (15.1.67)
Beta Posted (16.2.54)
Beta Released (14.2.87)
Beta Posted (16.2.64)
Beta Released (14.2.93)
Beta Posted (16.2.77)
Beta Released (15.1.75)
Beta Posted (16.2.72.1705)
Beta Posted (16.2.92)
Beta Released (14.2.102)
Beta Posted (16.2.85)
Beta Posted (16.3.8) *Version Change - Please Read*
Beta Posted (17.0.34)
Beta Posted (16.3.19)
Beta Posted (16.3.29)
Beta Posted (16.3.60)
Beta Posted (16.3.41)
Beta Posted (16.3.65)
Beta Released (15.1.84)
Beta Released (15.0.37)
Beta Released (15.0.42)
Beta Released (15.0.33)
Beta Released (15.0.55)
Beta Released (15.0.69)
Beta Released (15.0.66)
Beta Released (15.0.78)
Beta Released (15.1.92)
Beta Released (15.1.104)
Beta Posted (16.0.4.1390)
Beta Posted (16.0.9)
Beta Posted (16.0.12)
Beta Posted (16.0.16)
Beta Posted (16.0.25)
Beta Posted (16.0.36)
Beta Posted (16.0.53)
Beta Posted (16.0.64)
Beta Released (16.0.74)
Beta Released (14.1.10.749)
Beta Released (14.1.22.778)
Toad Beta version 16.1.7.1521 is posted
Beta Posted (16.1.25)
Beta Posted (16.1.37)
Beta Posted (16.1.32)
Beta Posted (16.1.39)
Beta Released (15.0.61)