Toad for Oracle 2024 R2 Beta

Toad for Oracle - Beta
1

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

Instructions for joining the Beta program:

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

  • Install Toad for Oracle version 17.1 for Windows (Non-subscription) and run it at least once. Do not uninstall 17.1 before installing the beta. The beta only works if the most recent GA version is 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 a bit faster than using a client.
    • Supported: LDAP, TNSNames.ora, TNS_ADMIN environment variable, Oracle Encryption and Data Integrity, Spool SQL, SSH, TCPS, IPV6, 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.
    • 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 in any way.

The beta change log is below

8 Likes
36

Toad Beta Change Log

Toad Beta 24.2.266.4641, Released 7-Oct-2024

Bug Fixes

  • Accessibility: Automation Designer - difficult/impossible to navigate by keyboard
  • Accessibility: Database Monitor - difficult/impossible to navigate by keyboard
  • Accessibility: Schema Compare difficult/impossible to navigate by keyboard
  • ADDM/AWR Browser: Current DBID not auto-selecting
  • Editor: Trim whitespace setting was being set globally
  • FTP: Date errors thrown if Toad's date format differs from windows date format

Enhancements

  • Data Grids: The popup menu has been reorganized. You may have to right-click -> Customize -> Reset to see it.

Toad Beta 24.2.256.4609, Released 30-Sept-2024

Bug Fixes

  • Accessibility: Schema Browser's "Object Type" dropdown losing focus when selecting Functions, Procedures, or Packages

Enhancements

  • Accessibility:
    • Options window: Now much easier to navigate using keyboard
    • Window Menu now has "Focus Toolbar" (Shortcut = CTRL+`). This will display a list of available toolbars in Toad. When you select one, the toolbar receives focus. Then you can TAB to the toolbar button that you are interested in and ENTER to "click" it, or ESC to jump out of the toolbar.
    • Window Menu now has "Docked Panels" gives a list of docked panels (Object Palette, SQL Recall, etc). When you select one, the docked panel receives focus
    • Editor: F6 Shortcut to toggle between memo and lower panels is now in Options -> Toolbars/Shortcuts, so you can change it to a different shortcut if you wish

Toad Beta 24.2.246.4576, Released 23-Sept-2024
Bug Fixes

  • Export Dataset: File selection button sometimes disabled
  • Editor: Code Insight not suggesting table related via FK constraint:
  • Editor: "Replace all" dialog missing selected text
  • Export DDL: Auto/Interval partitions not always export according to selected options
  • Login Window: Password prompt now shows TNS name instead of value (in no client mode)
  • Login Window: Password prompt is now resizable
  • Oracle 23ai: "DataType not supported" error from Schema Browser -> Domains, if using a 23ai client
  • Schema Browser: ORA-00904 "Vector Info invalid identifier when connected to 23c (NOT 23ai)
  • Schema Compare: Excessive data dictionary privilege requirements when only comparing tables
  • Single Object Compare: "Type" listed 3 times in the object type dropdown

Enhancements

  • Accessibility:
    • Add multiple logins is now usable by keyboard only
    • Edit login record is now usable by keyboard only
    • The data grid's popup menu is now accessible via F10
  • Describe Objects: Added a refresh button
  • Editor: Added toolbar button to toggle "trim whitespace" option
  • SGA Trace / Optimization: Renamed to "Shared Pool Browser"
  • Shared Pool Browser: Individual statements can now be purged from shared pool

Toad Beta 24.2.222.4504, Released 3-Sept-2024

Bug Fixes

  • Font Dialog: On scaled displays, resulting font size can be larger than expected
  • Editor: Code Insight not showing fields of implicit cursor record
  • Editor: Code Insight: fixed misc bugs caused by recent fixes to other problems
  • Editor: "Load Object at Caret" does not respect Package/Type load as pair option
  • Fast Report: Toolbar buttons disappearing on scaled displays on Windows Server 2019
  • Editor: "Replace all" misses selected text if "from cursor" is chosen
  • utPLSQL: Does not support multi-schema install

Enhancements

  • Connection Colors: Can now be auto-suggested based on rules which you can define
  • Schema Browser: When dropping indexes, ORA-02429 is raised if the index is used to enforce a PK or Unique constraint. Now the "Drop Index" confirmation has an option to drop the constraint if this occurs, preventing the error and dropping both constraint and index.
  • Schema Browser: Filter for ROLES now includes an option to exclude Oracle-Maintained roles.
  • Font Dialog: Now filterable and remembers recent selections
  • Administer Tablespaces: Space manager setup fails in no-client mode

Toad Beta 24.2.208.4458, 26-Aug-2024

Bug Fixes

  • Trace File Browser: Trace files with "CursorDiagnosticNodes" section cause errors
  • Schema Browser: ORA-01791 error displayed when expanding Unified Audit Policies node when Schema Browser is in treeview mode
  • Compare Data: CHAR datatypes not synchronizing correctly when tables are in different databases
  • SFTP: Private key file with passphrase caused "The password is incorrect" error

Enhancements

  • Options: Advanced options added to Options->Editor->Behavior to help handle Editor text rendering problems on scaled displays
  • Connections: In Options -> Oracle -> Connections, you can now specify that Toad disconnects after a period of inactivity within Toad (to prevent connections from being lost, which can lead to freezes/locks)

Toad Beta 24.2.195.4406, Released 19-Aug-2024

Bug Fixes

  • Editor: Find Next doesn't advance to next matching text if dialog is opened with matching text already selected
  • Connections: Toad unnecessarily polling LDAP for list of TNS entries when connection is made

Enhancements

  • Create Constraint: A warning is now displayed if you are about to create a circular foreign key constraint

Toad Beta 24.2.185.4369, Released 14-Aug-2024

Bug Fixes

  • Connections: "NET: Invalid Arguments" error when connecting to 23ai or fully patched 19c DB with Crypto or Encryption parameters set in server side SQLNet.Ora
  • Compare Databases: List Index Out of Bounds if attempt to preview differences too quickly

Toad Beta 24.2.182.4361, Released 12-Aug-2024

Bug Fixes

  • Datagrids: DB Object popup editor showing wrong columns and access violation
  • No-client mode: "Drop type" gives "drop materialized view" message when running scripts
  • Schema Browser: List Index Out of Bounds error if attempt to enable/disable constraint that was dropped
  • Schema Browser: "Show column ID in grid" option caused lag on views, m-views, and a-views with lots of columns
  • Data Grids: "Pin" icon in Editor showing wrong state
  • Schema Browser: RHS tabs too short on scaled displays
  • Docking panels: Selected dock label fuzzy on scaled displays

Enhancements

  • Automation Designer: Improved action placement when double-clicking in palette

Toad Beta 24.2.167.4299, Released 5-Aug-2024

Bug Fixes

  • Data Grids: Fuzzy text on while editing varchar2 fields on scaled displays
  • Editor: Code Insight not prioritizing ref. integrity suggestions if columns have different names
  • Editor: Toad hangs selecting text with $ characters when brace highlighting set to "innermost pair in scope"
  • Editor: CONNECT command not working in script execution with no-client mode
  • Login Window: TNSNames, LDAP, SQLNet buttons fuzzy on scaled displays
  • No-client mode: Not finding tnsnames.ora from Project Manger, Support Bundle, TNSNames Editor
  • Options: Temporary folder now defaults to %TEMP% (same location, but now variable can be specified incase it changes)
  • Team Coding: Filenames with non-ascii characters not handled properly with Git

Enhancements

  • Editor: Shift+Right-click on DB Object name now shows Schema Browser popup menu

Other

  • RExec is no longer supported in Toad as it is an insecure protocol. Use SSH instead.

Toad Beta 24.2.150.4235, Released 29-July-2024

Bug Fixes

  • Code Insight: Some of the icons are incorrect
  • CodeXpert.ini rewritten each time Toad starts
  • Connections: First auto-exec action executing silently. Others, non-silently
  • DBMS Output: ORA-20005 occurs with some old Oracle client versions
  • Export Dataset: Substitution variables not substituted if SQL contains comments or trailing whitespace before sub variable
  • Export/Import Utility Wizards: Error thrown if parameter file's folder doesn't exist (Toad should create it)
  • HTML DB Documentation: Custom fields from login window not included in output
  • Login Window: Import prompting for overwrite if same login present but with different "Connect as"
  • Login Window: Import not auto-checking "save password", even after prompt to do so
  • Options: The following files were being created even when empty: Connections.Ini, ConnectionActions.ini, ToadMail.ini, ToadMonitors.ini, SProjManFilterHist.xml, Networkconnections.dat
  • Master-Detail Browser: Dialog to migrate to another schema showing "Current Schema" more than once
  • Script Manager: "Could not convert variant" error when sending script to TSR

Enhancements

  • Editor: Code Insight has new option to include matches that contain the partially typed text (not just start with it). Options page improved also
  • Editor: Breakpoints panel rewritten for consistency across the various debugger types
  • DB Health Scan: Information/Statistical items no longer count as pass/fail. Also, pass/fail is now per check, not per failure

Toad Beta 24.2.134.4180, Released 22-July-2024

Bug Fixes

  • Data Grids: Invalid filter values raised error instead of "nice" message
  • DBMS Output: ORA-02005 thrown with some Oracle clients
  • DB Health Check: Format error in check for items which cannot extend due to lack of room in tablespace
  • DB Health Scan: Check/Uncheck all does nothing
  • Editor: Edit command caused ORA-00904 if table named used as alias
  • Editor: Desktop layout incorrect after dragging tabs
  • Editor: Access violation after closing hex tab
  • Editor: FmtPlus.opt file sharing error due to too frequent file access
  • Editor: Code Insight not showing after subquery in FROM clause
  • Editor: Code Insight not showing join suggestions in subquery
  • Import Wizard: List Index out of Bounds if opening small parameter file
  • JDWP Debugger: Access violation when connection closed and breakpoint exists
  • Rebuild Multiple Objects; Field BYTES not found for partitioned tables
  • Schema Browser: Stray text remnants after disabling "Show PK" option for materialized views
  • Team Coding: Admin window disabled after TC Installation

Enhancements

  • SQL Firewall: Misc enhancements and bug fixes
  • Schema Browser: Custom queries and filters can now be stored globally by table name (Configurable in Options|Schema Browser|Data Tab)

Toad Beta 24.2.111.4104, Released 15-July-2024

Bug Fixes

  • Create Constraint: Error on "move column down" if nothing selected
  • Editor: "New tab" icon colored wrong in dark mode with some tab styles
  • Formatting: Fmtplus.opt file sharing error when SQL formatted for internal use
  • Grid: Popup text editor saving files with uppercase TXT extension
  • Login Window: Grid reloading and jumping to wrong row after display of TNS Editor
  • Recover Documents: Access violation if grid filtered, then recover recent
  • Schema Browser: Error when selecting a file item in Favorites
  • Schema Browser: Wrong icon for disabled constraint

Enhancements

  • Compare Schemas: When types differ because one as been altered, we'll now use ALTER TYPE to alter the other if possible (rather than CREATE OR REPLACE, which fails if dependents exist)
  • Editor: Caret width is now configurable in Options|Editor|Display
  • Oracle 23ai: SQL Firewall window added under Administer menu (DB Admin module required)
  • Workspace: Added cancel button to stop the loading of a workspace

Toad Beta 24.2.92.4041, Released 8-July-2024

Bug Fixes

  • Database Browser: Can't connect as externally authenticated user
  • Login Window: LDAP dropdown not loading after switch from client to no-client mode
  • Session Browser: Vertical splitter not retaining position when switching to other windows and back to SessB.
  • Team Coding: Get Last Version failed due to extension mismatch
  • Window Menu: Wrong window shown as active

Enhancements

  • Oracle 23ai: Added support for Tablespace Shrink functionality in Schema Browser

Toad Beta 24.2.79.4007, Released 24-June-2024

Bug Fixes

  • Create Table: Window locks up when dragging from grid
  • Connections: Access violation if no Oracle clients present and login attempted with expired password
  • Data Grids: ANYDATA access violation
  • Editor: "Display full path as tab hints" stops working Link
  • Editor: Inline parameter assistance copy/paste bad behavior Link
  • Login window: "Invalid Oracle Home" when testing connections and no clients installed
  • Schema Compare: Evolved types not handled properly in sync script
  • Session Browser: Access violation when opening if "Format Statement" unchecked
  • Session Browser: Test Filter causes access violation
  • Single Record Viewer: Options dialog not opening
  • Single Object Compare: Sometimes missing SYNC script

Enhancements

  • Application Logging: Support bundle now automatically included
  • Connections: Added Connection Timeout setting (for when connection is being established or reconnected) Only available in no-client mode.
  • Master Detail Browser: Added "Current Schema" option to make MD files portable across different schemas with same tables Link
  • Schema Browser: Data tab filter now uses date format specified in options Link
  • Schema Browser: Display both Base and Log tables for materialized view logs Link
  • Session Browser: Rt-click: Styles added to main grid/tree

Toad Beta 24.2.61.3952, Released 17-June-2024

Bug Fixes

  • Data Grids: Column headers not always wide enough on scaled displays
  • Session Browser: Access Violation when opened if "Format Statements" unchecked
  • Startup: If "Allow multiple copies of Toad" unchecked and 2nd Toad started with command line parameters, parameters not passed to 1st Toad
  • Startup: Toad not remembering display if closed while maximized

Enhancements

  • Application Logging: Support bundle now automatically included in Logs folder
  • Data Grids: Now crisp and sharp on scaled displays
  • Oracle 23ai: Respect Bigfile tablespace default
  • Oracle 23ai: ORA-41900 handled like ORA-00942
  • Project Manager: Filter added Link

Toad Beta 24.2.51.3922, Released 10-June-2024

Bug Fixes

  • Automation Designer: Export Dataset actions erroneously throwing "Parameters out of sync" message Link
  • Editor: Grid not allowing edits if OCI Array Buffer Size set to Manual. Link
  • Main Form: Size/Position not always restored correctly Link
  • Session Browser: RHS refresh delay is annoying Link

Enhancements

  • Editor: Added ability to fold all regions at any level Link
  • Editor: Added some "copy to clipboard" options for Explain Plan Link
  • Oracle 23ai: Added support for Logical Partition Tracking. Note, this requires the READ privilege on the table SYS.TABLOGICPART$. Hopefully Oracle will give us some standard USER/ALL/DBA views for this data soon.
  • Oracle 23ai: Added ability to open pluggable databases in Hybrid Read Only mode
  • Oracle 23ai: Added support for hybrid partitioned tables with interval and auto list partitioning
  • Oracle 23ai: Added ability to rename LOBs w/o moving them
  • Oracle 23ai: Added support for concurrent refreshes in MVs
  • utPLSQL: Version 3.1.1.14 now supported

Toad Beta 24.2.31.3856, Released 3-June-2024

Bug Fixes

  • Alter Unified Audit Policy: "Disable" not working
  • Add/Edit Login: TNS dropdown not loaded unless TNS_ADMIN specified Link
  • Blob Viewer: Viewing PNG data as PDF caused Toad to freeze Link
  • Compare Databases: Revoke Role above the comment for that role Link
  • Export DDL: Not Null constraints missing from script for object tables
  • Misc Internal SQL: Not always using SYS. with data dictionary view names
  • Schema Browser: SQL error when listing DOMAINS

Enhancements

  • Compare Databases: Added preview panel
  • Manage User Settings: Added ability to restore individual settings from backup
  • Oracle 23ai: Added support for read only users
  • Oracle 23ai: Added support for enable/disable dictionary protection
  • Oracle 23ai: Added support for individual columns in Unified Audit Policies
  • Oracle 23ai: Added support for VECTOR datatypes
  • Oracle 23ai: Added support for VECTOR indexes
  • Oracle 23ai: Added support for staging tables
  • Schema Browser: Added option to adjust node heights Link
  • Team Coding: Added "Locked by" field in SB RHS and Editor
  • Team Coding: Added option to use OS User or login schema as lock user Link

Toad Beta 24.2.15.3785 Released 28-May-2024

Bug Fixes

  • Error on startup if color themes enabled

Toad Beta 24.2.11.3771 Released 28-May-2024

Bug Fixes

  • Code Analysis: Access violation if window closed too quickly
  • Editor: Errors thrown if attempting to step into Java Source while debugging with JDWP
  • Export DDL: private synonyms excluded when getting script for multiple users
  • Export DDL: Object Table Substitution clause left out of table scripts
  • Schema Browser: SQL error when clicking system tablespace
  • Session Browser: Blinks on refresh
  • Workspaces: Describe Objects window focused after loading workspace

Enhancements

  • New version numbering system: Year.Release.Build.Internal
  • Database Compare: Added preview panel for differences
  • Manage User Settings: Added ability to recover specific items from backup
  • Schema Browser: Added icons to indicate Unified Audit Policy enablement Link
  • Schema Browser: Added ability to enable/disable Unified Audit Policies Link
  • Single Record View: Table name is now displayed when launched from Editor Link

The change log for Toad version 17.1 is here

3 Likes