Toad for Oracle 17.1 Beta

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

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

  • Install Toad for Oracle version 17.0 for Windows (Non-subscription) and run it at least once. Do not uninstall 17.0 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, and Oracle Wallet connections.
    • Can connect to every database version since 7.3!
  • Cons of no-client option:
    • Not supported: tracing/logging, proxy connections.
    • Known issue: Timestamps display wrong offsets 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

8 Likes

Toad Beta Change Log

Toad Beta 17.1.625.3393, Released 25-Mar-2024

Bug Fixes

  • Alter Refresh Group: Added support for Oracle 18 changes around refresh group job management from DBMS_JOB to Scheduler Jobs
  • Dark Mode: Removed a white square in the corner between vertical and horizontal editor scrollbars
  • Export DDL: Constraints longer than 4000 characters getting truncated in scripts
  • Export Dataset: ORA-00936 "missing expression" error if user changes connection on export dataset dialog to a connection which does not have the tables being exported
  • Multiple Toads: Improved protection against multiple Toads from accessing ini files at the same time

Enhancements

  • Connections: Added ability to disconnect sessions w/o closing windows (the purpose of this is so you can disconnect from DB to avoid a more forceful disconnect from the server side, which might result in a slow reconnect process)

Toad Beta 17.1.615.3354, Released 18-Mar-2024

Bug Fixes

  • Data Grids: Time zone information incorrect when connected without Oracle client
  • External Tools: Tool names not displayed properly on scaled displays
  • Options: Can't change application data directory
  • QSR: Access violation when closing
  • Schema Browser: Treeview clipping text on scaled displays
  • Schema Browser: RHS Tablespace Free space tab not always consistent with Datafiles tab
  • Schema Browser (Beta-only-bug): Tables-RHS-Trigger tab showed "Created" instead of "Create or Replace" Link
  • Session Browser: Too responsive to fast clicking on LHS Link
  • Team Coding: Exception on Check-in with comment longer than 200 chars (up to 1000 now allowed)
  • Toolbars (Beta-only bug): Toolbar layouts not saving

Enhancements

  • Automation Designer: Improved "file in use" check for ToadActions.dat and ToadActions.log
  • Schema Browser: Tablespaces RHS Free space tab can now display storage occupied by recycle bin objects

Toad Beta 17.1.601.3308, Released 11-Mar-2024

Bug Fixes

  • Alter Table: "Rename column" command including schema when user requested to exclude schema Link
  • Analyze Objects: Access violation if window closed while refreshing
  • Automation Designer: Format Files action only affecting case of reserved words
  • Automation Designer: Access violation when changing connection to "none"
  • Compare Data: Source schema changing when connecting target connection
  • Compare Data: Unable to compare tables when column name contains asterisk
  • Connections: ORA-00045 (session terminated with noreplay) not displayed with option to reconnect
  • Editor: Focus not always changing to new tab Link
  • Editor: Access violation when running SQL that contains control characters
  • Export Dataset: Substitution variables not being set after editing SQL Text Link
  • Load DB Object Dialog: Gray square displayed when "Show Source" left unchecked Link
  • Mac: Some buttons not drawing correctly in dark mode

Toad Beta 17.1.585.3257, Released 04-Mar-2024

Bug Fixes

  • Alter Trigger (beta only): "Or Replace" missing
  • Code Analysis: Toad crashing after running SQL Scan in some environments
  • Dark Mode (beta only): SQLNet Editor button in login window had white boogers in the corners of the button
  • Editor: Shortcut for Print Preview cannot be changed. Link
  • Login Window: Buttons not displaying properly in Windows Server 2016. Link
  • Single Object Compare: Running more queries than needed while selecting objects Link

Enhancements

  • Connection Colors: Colored squares on connection and window bar buttons are now thicker Link
  • Editor: Editionable keyword option (set in Schema Browser) now followed when loading objects
  • Schema Compare: Now compares Editionable
  • Toolbars: New toolbar buttons will now be displayed in upgraded versions of Toad, if toolbars were never customized

Toad Beta 17.1.572.3212, Released 26-Feb-2024

Bug Fixes

  • Create DB Link: "Use full TNS Info" option not available in no-client mode
  • Create Pluggable Database: Error when creating from clone through DB Link
  • Compare Schemas: "Create" used instead of "Create or Replace" if parameter from prior version is used
  • Dark Mode: Ghosty lines around toolbars on high-dpi displays. Link
  • Data Import Wizard: Can't import '1.0' from text file into an integer column
  • Data Import Wizard: First character of each line missed if file has Mac-style line feeds
  • Database Browser: Access Violation from Quick Filter if it contains too many items
  • Data Grids: Some columns auto-sized too narrow on scaled displays. Link
  • Editor Backup Engine: Backing up files immediately after being drug into Toad
  • Editor: "DB Object newer than editor contents" prompts with each F9
  • Options: Font Ligature hint applied to every checkbox in Options|Editor|Display
  • Workspaces: Access violation while workspace loading due to backup engine firing right away. Link

Enhancements

  • Toad on Mac: File menu items moved to Apple file menu

Toad Beta 17.1.559, Released 19-Feb-2024

Bug Fixes

  • Connection Bar: "Alter session set container" in Editor caused container indicator on connection bar to get out of sync. Link
  • Connection Bar: "Frequently Used" windows can be launched in the wrong connection. Link
  • Create Tablespace: Access violation trying to add Oracle Managed File (beta-only bug)
  • Export Dataset: Clobs more than 32K in length not exporting at all to Excel files
  • Schema Browser: Incorrect tab order in Filter/Sort dialog. Link
  • Shutdown: Toad not shutting down completely (beta-only bug)
  • Window Menu: Grows each time you click it. Link

Enhancements

  • Compare Schemas, Export DDL, Generate Schema Script: Added option to exclude EDITIONABLE/NONEDITIONABLE. Link
  • Connections: Added an option to prevent Toad from attempting to use SYS.USER$. Link
  • DB Health Scan: GUI enhancements

Toad Beta 17.1.532.3067, Released 05-Feb-2024

Bug Fixes

  • Editor: Access violation while debugging certain objects

Enhancements

  • Data Grids: Popup Blob viewer can now preview contents as PDF, XLSX, DOCX (first page only), Text, Image, or Hex
  • Data Subset Wizard: Minor UI enhancements
  • Connection Bar Buttons: "As SYSDBA" is now optional. Link

Toad Beta 17.1.517.3008, Released 30-Jan-2024

Bug Fixes

  • Menu: Fixed disappearance of Database->Monitor caused by yesterday's beta. See this post if your Monitor menu item is missing.

Toad Beta 17.1.513.2997, Released 29-Jan-2024
Bug Fixes

  • Connection Bar: "Restore Lost Connections" menu item not always enabled when it should be. Link
  • No client mode: Access violation when selecting RAW through DB Link
  • Connection error dialog: "Search this message" link goes to wrong place
  • Export Dataset: Default Excel format was XLS instead of XLSX. Link
  • Mac: Registry warning in Toad Advisor
  • Editor: Goto line (CTRL+G) caused access violation. Link
  • Code Analysis: Not running after editor open, then closed

Enhancements

  • Connection Bar Buttons: "As SysDBA" is now optional. Link
  • Generate Schema Script: Add variable support to "Top Level Directory" field. Link

Toad Beta 17.1.494, Released 22-Jan-2024

Bug Fixes

  • Mac: Caps lock slowing down editor load time
  • Editor: Incorrect error line reported after compile. Link

Enhancements

  • Trace File Browser: Added advice for more wait events

Toad Beta 17.1.487.2904, Released 15-Jan-2024
Bug Fixes

  • Mac: Caps lock getting confused
  • Mac: Compiling Team Coding controlled object using shortcut causes an endless loop
  • Mac: Can't drag-drop from Mac's Finder to Toad's editor to open files
  • Mac: F3 (Find Next) not working if dialog not visible
  • Mac: Fast Exit does not shut down Toad
  • Schema Browser: Common Unified Audit Policies created in container DB not visible in pluggable
  • Team Coding: Lock message showing wrong user name

Enhancements

  • Create/Alter Schedules and Scheduler Jobs: Added buttons for sample start/end times
  • Editor, QSR: Script Execution: A summary grid, to summarize the other grids, has been added
  • Mac: Improved fonts for Editor and Data Grids
  • Trace File Browser: The data at the top of "Query Summary" has been reorganized to a new "File Header" tab. Some of the info has been moved to the "File Header" tab.

Toad Beta 17.1.478.2849, Released 8-Jan-2024
Bug Fixes

  • Login Window: Add, Test Connection gave "SSH Host Required" message
  • Mac: License expiration bubble hint getting cut off
  • Options: "Allow multiple Toads" option not respecting Toad version
  • Script Execution: Execution time sometimes wrong. Link.
  • Team Coding: Locked message showing wrong user name
  • Toad Script Runner: Tabs don't look right in dark mode
  • TNSNames Editor: Can't add new service
  • Unit Test Manager: Connection changing unexpectedly when clicking in tree. Link.
  • Unit Test Manager: Connection changing unexpectedly when closing. Link.

Enhancements

  • Automation Designer: ToadActions.log now written in a manner safer for multiple Toads running
  • Editor: Double-click on error in script output no longer opens web browser. Link.
  • Editor: Save breakpoints between debug sessions
  • Session Browser: Trace Session now has "include waits" checked by default
  • Trace File Browser: Added a Min/Avg column in wait summary tab. This can be helpful in finding statements have that a particularly long wait
  • Workspaces: Auto-Save/Load options are now separate. Link.

Toad Beta 17.1.451, Released 18-Dec-2023

Bug Fixes

  • Connection bar button: List of containers not always fully populated Link
  • Export DDL: "Alter user X default role all" incorrectly appearing when only one role granted
  • Mac: License expiration warning text cut off
  • Team Coding: "Object source has changed" dialog appearing in a loop on checkin

Enhancements

  • Automation Designer: ToadActions.dat is now written in a manner that is safer for multiple Toads running
  • Automation Designer: Variables are now supported for connections and source/target schemas in Generate Schema/DB Script, and Compare Schema/DB actions Link
  • Create Unified Audit Policy: "Container=ALL" can now be specified
  • QSR: There is now a dropdown arrow on the tab control, making it easier to look through and select from a long list of tabs
  • Trace File Browser: You can now add notes on a SQL statement
  • Trace File Browser: Now automatically identifies cases where a cursor loop drives a SQL with binds (in which case performance could be improved by removing the loop and joining the SQL
  • Trace File Browser: The worst performing statement is now highlighted in red

Toad Beta 17.1.437, Released 11-Dec-2023

Bug Fixes

  • Login Window: LDAP dropdown in no-client mode was painfully slow
  • Login Window: LDAP entries not sorted when using Oracle client
  • Login Window: TNSPing button not working on LDAP entries
  • Login Window: TNSPing button giving bogus error if TNSPing.exe not found
  • Schema Browser: Tables, Script tab: If table contains an identity column, a bogus "drop sequence" command was produced

Enhancements

  • Automation Designer: Added a VERY advanced feature to make mass-edits to all selected apps or actions Link.
  • Describe Objects: Object list settings file (DescribeWindowList.xml) is now automatically backed up Link
  • Editor: Toad now attempts to stay on current line after a file is reloaded in the editor Link
  • Export Dataset: Add support to run non-select statements in the script Link
  • Login window: Remember last focused column in grid
  • Login window: Add option to start focus in Grid or "User" box
  • Login window: Moved the checkboxes from the bottom of the window into the "Display Style" dropdown on the toolbar above the grid
  • Login Window: TNSPing button now returns actual TNSPing output
  • Mac: Make TNS_ADMIN location easy to locate
  • Options: If Options|Oracle|General->OCI Array Buffer Size is Set to Manual, Toad no longer performs an "OCI Describe" before executing SQL for grids. OCI Describe was preventing Adaptive Cursor Sharing from working correctly Link
  • QSR: Now supports F2 functionality to move the splitter up/down, same as Toad's editor
  • Schema Browser: Create Insert for All Rows Data substitution feature added. Link
  • Schema Browser: Quick Filters can now be saved per-connection. Link
  • Schema Browser: Run Scheduler Job's "Ok, I did it" message is now no-nag.
  • Script Execution: Replaced the ugly animation from the status dialog with a standard progress bar Link.
  • Session Browser: Display active filter name Link
  • Spool SQL: OCI Describe events are now spooled

Toad Beta 17.1.417, Released 4-Dec-2023
Bug Fixes

  • Editor/Dark Mode: Editor toolbars not wide enough, hiding buttons in favor of dropdown arrows
  • Mac: Blob Editor not showing Save dialog correctly.
  • Mac: Grid lines not visible in some grids.
  • Schema Browser: Data grids loading slowly if "include column ID in grid column header" option is checked
  • Toad Script Runner: "Save as" not creating XLS/XLSX files

Enhancements

  • Automation Designer: Script Execution: Error codes added to the "ignore error list" are now auto-checked when you add them.
  • Connection Bar and Window Bar: Middle-click now closes a connection or window
  • Create/Alter Datafile: Find/Copy now lists default disk group (ASM)
  • Create/Alter Datafile: Can now add multiple datafiles at once
  • Data Grids: Popup menu is now customizable. Rearrange menu items and hide what you don't want to see.
  • Schema Browser, Tablespaces: The right-hand-side "Objects" tab now has a button that allows you to rebuild/move selected objects within the same or a different tablespace. This can be handy when you need to shrink datafiles but objects at the end of the file are preventing that
  • Schema Browser, Tablespaces: Can now multi-select tablespaces and choose "Add datafile" to add a file to each selected tablespace
  • Schema Browser, Favorites: Expansion state is now saved/restored automatically
  • Script Execution: The animation on the progress dialog has been replaced with a standard progress bar
  • Session Browser: Can now start/stop tracing database-wide (as opposed to selected sessions)
  • Tablespace Map: Can now display the contents of a single datafile in multi-file tablespaces
  • Trace File Browser: A histogram has been added to "Wait Summary" tab
  • Trace File Browser: Start/End times, as well as a gantt chart showing this info, and some additional columns like Executions, Fetches, Parses, has been added to the Preview File dialog

Toad Beta 17.1.397.2461, Released 27-Nov-2023
Bug Fixes

  • Dark Mode: Editor's "Load Database Objects" not painted correctly until SQL finishes
  • Automation Designer: Access violation when running script action after switching to another window, then back to Automation Designer.
  • Schema Compare: Error - 'Nothing selected to compare' when constraints selected

Enhancements

  • Automation Designer: Content type (plain or HTML) can now be specified in email actions
  • Automation Designer: Option added to script action to not display popup error messages

Toad Beta 17.1.391.2240, Released 20-Nov-2023
Bug Fixes

  • Automation Designer: Cannot import Data Pump Import actions from prior versions
  • AWR Browser: Insufficient privs error from AWR report when connected to pluggable DB
  • Import Table Data: Fixed field width imports giving bogus error about field size
  • Import Table Data: Error if Array Size value too large.
  • Create/Alter Table: Show SQL w/o Schema still showing schema when adding foreign key
  • Debugging: "Invalid Oracle Home" when trying to debug in no-client mode
  • Editor: "Save as" including full path in file dialog
  • Export DDL 23c: "Invalid Table Name" error when creating scripts
  • Login: grid filtering by client while in no-client mode
  • Misc: "Cannot perform this operation on a closed dataset" error after lost connection
  • Options: "Allow internet access" not disabling Toad Improvement Program
  • Schema Browser: DB Link dependencies finding links in other schemas

Enhancements

  • Schema Browser: Commit/Rollback buttons above data grids now only enabled when in transaction
  • Schema Browser: Tables-RHS-Indexes - creation date can now be displayed (click top-left corner of grid to enable)
  • Schema Browser: Tables-RHS-Stats/Size - index size can now be included

Toad Beta 17.1.375.2275, Released 13-Nov-2023

Bug Fixes

  • Alter Datafile: Error when specifying file size greater than 2147483647 bytes
  • Alter Database Link: DB Link name appearing in User Name field
  • Code Road Map: "File in use" error when multiple Toads running
  • Compare Multiple Tables: "[] is not a valid directory" error if output file name specified without path
  • Connections: Access violation if ending connection while quick describe window is open
  • Editor: Tab stop setting not saved
  • Editor: Excessive scrollbar movement when navigator reloads (most noticeable when a color theme is applied)
  • FTP: Invalid private key file raised exception instead of "nice" error
  • Import Table Data: Exception raised if importing from Excel and the sheet to be imported is missing:
  • Login Edit Dialog: Password shown in clear text when entering new password for multiple login records:
  • Schema Browser: Access violation if changing RHS dimension tabs while script is loading
  • Script Manager: Access violation when running scripts
  • Startup: "Scheduler is not running" error if windows scheduler is not running
  • Toolbars: Access violation if toolbars reset while describe window open

Enhancements

  • Export DDL: Much faster now when exporting multiple objects. Please note, this change means that in some cases the output files from Export DDL may be slightly different. Specifically:
    • When exporting multiple objects to either "One file per schema" or "One file per object type", the order of the statements in the file may be different than before.
    • When exporting multiple objects to either "One file per schema" or "One file per object type", line feeds between statements may be different than before
    • "BuildAll.sql" is now "Build_All.sql". This change was made so that Generate Schema Script and Export DDL produce the same file name.
    • When exporting objects to "One File per Object" in Generate Schema Script - an additional line feed is present at the end of each file as compared to version 17.0.
  • Log Switch Frequency Map: Can now show size/quantity of Archive Log switches
  • QSR: Show connection info on title bar like Toad
  • Team Coding: Much faster now when working with multiple objects (check in/out, etc)
  • What's new dialog: Links now open in default browser
  • Workspaces:
    • "Save" now saves without prompts
    • New "Save as..." can be used to save to a new workspace
    • "Delete" and "Rename" options now show additional info about workspace

Toad Beta 17.1.352.2151, Released 6-Nov-2023

Bug Fixes

  • Schema Browser: RHS Script buttons - icon should match the LHS script button.
  • Schema Browser: Tabbing from the quick filter goes to no-man's land
  • Schema Browser: Quick Filter didn't work for Favorites
  • Import Table Data: Access violation when re-running import and Excel sheet no longer in file

Enhancements

  • Schema Browser: Favorites - Annoying "# Objects Added" message removed
  • Schema Browser: In LHS, CTRL+F now moves focus to the quick filter
  • Schema Browser: Added some Schema Browser actions to Options -> Toolbars -> Shortcuts

The change log for Toad version 17.0 is here

2 Likes