Toad for Oracle 16.1 Beta

We are proud to announce the Toad for Oracle v16.1 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:

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:

The change log below is updated when a new beta becomes available, typically each Monday.

7 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)
Export dataset multiple queries
Beta Released (15.0.42)
Beta Released (14.2.17)
Export Dataset -> Display all results in grid -> Default Value not saved
Beta Released (14.2.35)
Beta Posted (16.0.83)
Beta Released (14.2.102)
Toad for Oracle Version 14.0
BUG: Quick describe / CTRL+D bugg
'Not Responding' Freezes Session
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
JSON syntax error (conversion Collection type to Clob)
Beta Released (14.2.87)
Beta Released (14.2.93)
Beta Released (15.1.75)
Menu Animation Fade Effect
Toad for Oracle 14.1 - Shortcut changes not working
Automatic reconnect
Toad popup window do not show all records
Dark Mode in Toad12.6
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.52)
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
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)
Dark Mode Coming to Beta on Monday!
Dark Mode Coming to Beta on Monday!
Beta Released (14.2.71)
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
Beta Released (15.1.52)

Toad Beta Change Log

A note about Oracle Clients:
Oracle clients 19c and 21c are not recommended due to memory leaks with LOBs. Those versions also can exhibit hangs when cancelling queries against 11gR2 servers. 12cR2 and newer clients handle XMLTYPE better than older versions. Therefore, the best client versions to use with Toad are 12cR2 and 18c. Any client version will work, but some work better than others. The no-client option also works well. Just uncheck the "Use Oracle Client" box on the login window.

Toad Beta Change Log

A note about Oracle Clients:
Oracle clients 19c and 21c are not recommended due to memory leaks with LOBs. Those versions also can exhibit hangs when cancelling queries against 11gR2 servers. 12cR2 and newer clients handle XMLTYPE better than older versions. Therefore, the best client versions to use with Toad are 12cR2 and 18c. Any client version will work, but some work better than others. The no-client option also works well. Just uncheck the "Use Oracle Client" box on the login window.

Released 20-June-2022, Beta 16.1.52.
This is the final beta for version 16.1.
16.1 will be officially released on June 29th.

Bug Fixes

  • Alter Table Window
    • Can't modify DELETE RULE of a constraint
    • Split Partition - new partition displayed out of order in GUI
  • Automation Designer: Imported actions from another PC won't run from command line
  • Compare Table Data: Access violation when shutting down Toad with this window open
  • Connection Colors
    • Connection color borders drawn around windows sometimes disappear
    • Color not present when connection made via command line
  • Connections
    • Access violation after disconnect
    • No client + TNSNames with IFILE, can't connect to the IFILE entries
    • No-client connection with TNSNames fails from command line
    • No-client mode: Direct connect specified with SID not saved correctly
  • Copy Data to Another Schema: Unicode in XMLTYPE turning into ????
  • Dark Mode
    • Hard to tell if toolbar (window/connection bar) button is is the "down" position
    • Extra scrollbars in schema browser enabled
  • Data Grid: Popup text editor, Unicode characters turning into ????
  • Database Browser: DB list not loading in no-client mode
  • Datagrids: Blob dialog crashing Toad
  • DBMS Output: Unicode characters causing error
  • Editor
    • Code Insight, access violation on object type fields
    • Code Insight, not working for common table expressions
    • Navigator splitter usable even when navigator is hidden
    • Refactor: Find Unused Identifiers, false positives
    • Scroll position lost after changing tabs
  • Export DDL: Schema Name being added in wrong place into Java Source
  • FTP: SFTP not connecting via private key file
  • Import Table Data: Bogus "invalid date" errors when Array DML option disabled
  • Login Window: fancy color names appearing as "Custom"
  • Queues: Create/Alter, Export DDL - queue_to_queue and delivery_mode not supported
  • Schema Browser
    • "mCols: cannot perform on a closed dataset" after F3 on a Column node.
    • AV on partitions tab in SB-Tables
    • Collection types not showing in Treeview if expanded first
    • List Index Out of Bounds error when compiling in treevew
    • Subobjects, triggers and indexes owned by other schemas not showing
    • Tables Data Grid, Detail dataset only showing 12 rows
    • Toad freezes when sorting recycle bin objects by tablespace
  • Script Execution
    • @@ not working in no-client mode
    • @@ not working when running unsaved scripts
    • Autotrace "Unable to retrieve statistics" error
  • SDI Mode: Access violation when opening SQL Recall
  • Session Browser: Wrong values for locked objects in Locks tabs
  • SQL Optimizer: Not working with clientless connections
  • SQL Tracker: Failing license check for Toad subscription
  • SQL Tuning Advisor - bad error message for SQLID that is no longer in cache
  • Team Coding: full connect string shown in output tab in no-client mode
  • Workspaces: Not loading when using no-client mode and TNSNames

Enhancements

  • Automation Designer: Removed unneeded variables
  • Compare Table Data: Target schema auto-selected based on source schema
  • Connection Colors: Connection color borders easier to see non-themed mode
  • Create/Alter Table: Add ability to toggle columns grid between basic/advanced
  • Editor
    • DBMS Output LOB technique restored (and improved)
    • Find dialog can now exclude or find only comments and/or strings
    • Made it easier to identify active tab in dark mode
    • Added button to view selected errors of script output in external editor
  • Generate Schema Script: Added "hide common users" in the "add" dialog.
  • Internal security enhancements
  • Options: caution user when moving options from default location
  • Schema Browser
    • Display icons for Team Coding Status column
    • More subobjects supported
    • Quick filter - added option to for auto wildcard filtering
  • Script Manager: Added ability to clear all output. Added ability to Save/Load connection list
  • Spool SQL: Added a "Pause" option
  • Team Coding
    • Added filter to Team Coding Manager
    • Added option to check in objects after script execution
  • Toad: Improved behavior in environments with limited networks

The change log for Toad version 16.0 is here

1 Like
Beta Released (14.1.2.726)
Problems with Toad 14.0 crashing
Beta Released (14.1.84)
Beta Posted (16.0.86)
Beta Released (15.1.61)
Beta Released (14.1.114)
Beta Released (14.1.30.790)
Beta Released (14.1.39.807)
Beta Released (14.1.42.811)
Beta Released (14.1.73)
Beta Released (15.1.86)
Beta Released (14.1.54.830)
Beta Released (14.1.57)
Beta Released (15.0.47)
Beta Released (15.1.111)
Beta Posted (16.0.47)
Beta Released (14.1.108)
Beta Posted (16.0.83)
Beta Released (14.1.10.751)
Beta Released (15.0.87)
Beta Released (15.0.94)
Beta Released (14.1.96)
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 Released (14.2.71)
Beta Released (15.1.41)
Beta Released (14.2.73)
Beta Released (15.1.52)
'Not Responding' Freezes Session
Beta Released (15.1.64)
Beta Released (15.1.67)
Beta Released (14.2.87)
Beta Released (14.2.93)
Beta Released (15.1.75)
Beta Released (14.2.102)
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.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 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 Posted (16.1.52)
Beta Posted (16.1.44)