Are you ready for the most exciting news of the year? The latest version of Toad for Oracle 17.0.341.1977, the world’s leading commercial database management tool, is now available on Mac! That’s right, you can now enjoy the power and productivity of Toad on your favorite operating system. Whether you are a developer, a DBA, or a data analyst, Toad for Oracle 17.0 has something for you.
Toad for Oracle 17.0 introduces DB Health Scan (Preview). An update to our DB Health Check tool that can help you check the overall health of your database. You can use the Database Health Scan feature to perform a 120-point health check on your Oracle database. You’ll learn where your database could be vulnerable to hackers, spot problematic configuration settings, discover storage and performance issues, and more. You can also save the results to HTML and send them by email. DB Health Scan, while in preview, is open to everyone without the need to have the DB Admin Module add-on. We look forward to your feedback on this new and exciting enhancement.
Toad for Oracle 17.0 supports Oracle Database 23c, the next long term support release of Oracle Database that delivers the most complete and simple converged database for developers. You can take advantage of the new features and enhancements in Oracle Database 23c.
Toad for Oracle 17.0 makes it easier to connect to your databases with native SSH connection support without needing external SSH clients. You can also use clientless connections that now support TCPS, which is a secure protocol that encrypts data in transit. These features improve the security and convenience of your database connections.
Toad for Oracle 17.0 improves the user experience with a new and improved automation designer layout. You can now create and manage your automation scripts with a more intuitive and user-friendly interface. You can also use the trace file browser enhancements to view and analyze your trace files more efficiently. Additionally, the improved schema browser has increased performance when selecting procedures, functions, and packages.
But wait, there’s more! Toad for Oracle 17.0 also comes with a new Toad for Oracle on Mac offering that lets you run Toad on your Mac device. You can enjoy the same features and functionality of Toad on Windows, but with a native Mac look and feel.
Toad for Oracle 17.0 is the ultimate tool for database professionals of all skill and experience levels. It helps you understand your database environment, meet deadlines easily, perform essential tasks, deploy high-quality applications, validate database code, manage and share projects, and much more. With Toad for Oracle 17.0, you can work smarter and faster than ever before.
Choose from the best subscription offerings of Toad for Oracle Base, Toad for Oracle Professional, Toad for Oracle Professional DB Admin, Toad for Oracle Xpert Plus, Toad for Oracle Developer Plus, and Toad for Oracle DBA Plus Editions for an affordable annual price.
Starting today, joining the subscription family is the Toad for Oracle on Mac Professional DB Admin Subscription Edition.
Get your subscription today by going to Toad for Oracle Subscription or Toad for Oracle on Mac Subscription Quest Online Store.
To learn more about these subscription offerings, visit https://www.toadworld.com/products/toad-for-oracle.
For all of our existing customers, Toad for Oracle 17.0.341.1977 contains many new fixes and enhancements. (Many of which have been suggested by our Toad World members—Thank you all!)
For more information on these and other stability and performance improvements, view the release notes at https://support.quest.com/technical-documents/toad-for-oracle/release-notes.
To download this latest release, visit https://support.quest.com/toad-for-oracle/download-new-releases for Windows and https://support.quest.com/toad-for-oracle-on-mac/download-new-releases for Mac.
To learn more about Toad for Oracle, visit https://www.quest.com/products/toad-for-oracle.
Bug Fixes
- Add Column dialog: Column names were limited to 30 characters
- ADDM Report: Text cut off in "drop baseline" dialog
- Alter Datafile: "UNLIMITED" appears in SQL after other edits
- Alter Table: Access violation if connection ends while window is opening
- Alter Table: LOB editor throws error if column renamed
- Analyze Table: Table not being auto-selected when window launched from Schema Browser
- Automation Designer:
- Excessive file writes of app backup files
- Export Dataset file extension not always remembered for multi-table exports
- Internet Access option blocking FTP actions
- Script action fails if output path contains variables
- Text of selected action hard to see in some color schemes
- TNSPing access violation when no client is present
- Variables not processed in FTP downloads
- Code Analysis: SQL Scan didn't return results with Oracle Proxy connections
- Code Insight: Filtering was slow on databases with large numbers of objects
- Code Insight: Not working in subqueries
- Color Schemes:
- MDI Min/Max/Restore buttons painting badly after minimize/restore
- Colorization not always applied fully to SQL Recall window
- Editor tab coloring in slightly off in Aqua (and Golden) Graphite
- Connection Bar: Missing icons on right-click menu item for open windows
- Connection Colors: Schema Browser border color lost when selecting an object
- Connection Error dialog: Fixed incorrect advice on "no listener" error
- Connections: Test Connections dialog doesn't cancel when clicking the X to close
- Create Materialized View: Not detecting MV Log through synonyms
- Create Table: Datatype lost after cancelling out of interval/timestamp gui
- Create/Alter Datafile: incorrect tab order
- Data Compare: Unneeded queries run when launched from Schema Browser
- Data Grids:
- Missing ellipsis when very long data is shown
- Access Violation if connection lost, then attempt to edit a date field
- Crash after open/close/open user-defined object popup editor
- Invalid Pointer Operation after posting change in text popup editor after connection loss
- Pasting into grid with aliased ROWID column caused error
- "Invalid value for field" Error on DELETE key in cell of numeric data.
- Popup text editor throws "cannot modify read-only dataset" when formatting SQL
- Data Pump Export: "View as Table" columns too wide
- Database Browser:
- Database columns show wrong info in no-client mode
- Typing in the filter causes excessive refresh
- DB Health Check: Incorrect result for "Foreign keys with mix of nullable columns" when running as SYS
- Docked Panels: An undocked, floating panel can go behind Toad after switching to another app and back
- Editor:
- "DB Contents Newer - compile anyway" prompt displayed even after compile (related to workspaces)
- "Invalid Floating Point Operation" error from minimap
- Bad screen scaling in some cases
- Code Insight not showing PL/SQL elements with caret after SQL
- Code Insight sometimes duplicating suggestions
- Explain Plan Access Violation after closing connection, then changing dbms_xplan format
- Explain Plan sometimes connects to wrong DB in RAC
- Fixed multiple "reload file" prompts after clicking "Yes to all"
- In no-client mode, a cancelled script wouldn't cancel until current SQL finished
- In no-client mode, SQL feedback not correct for some statement types
- Opening maximized if previously minimized, then procedure dbl-clicked from Schema Browser
- Profiler data generated by Code Tester not summarized
- Refactor not working for SQL with only one package constant
- Refactoring causes "Group function now allowed here" error when setting the "Remove Subqueries" option
- Script Execution moves caret to the wrong location after execution
- Script execution not cancelling in no-client mode until current query finishes
- Simple Navigator sometimes does not show package proc/func
- Toolbar AV while customizing
- Export Dataset: DBLink containing a dot was confusing schema auto-detect
- Export DDL:
- Dialog too small
- Incorrect script for encrypted tablespaces
- Incorrect script created for comments which begin and end with a single quote
- PLSQL block for refresh groups (after MV script) missing slash
- Scheduler Job script with unnamed arguments produces SQL error
- Semicolon missing when exporting views with "query only" option
- Export Utility Wizard: List Index Out of Bounds when running from parameter file
- FTP: File timestamps not displayed in local time zone
- Generate Schema Script:
- Sometimes creating empty folders
- Tablespace inmemory and compression options ignored
- Grid Find: Access Violations after multi-column find
- Grid Sort Dialog: Fixed tab order
- Import Table Data:
- Access violations when importing text files with values over 32Kb in size into CLOBs
- Not continuing to import after error with array DML
- Login Window:
- "Test" failed when no Oracle client in use
- Grid grouping changes after deletion
- Oracle home text didn't clear when unchecking "Connect Using Oracle Home"
- Selected/Focused row not in sync in tabbed display style
- Mac: Toad now runs on Mac (separate license required)
- Open Trace File dialog: Some files showing NULL for date (fix requires drop/recreate of ToadDirList java source object)
- Report Designer: F1 not downloading Fast Reports user manual
- Schema Browser:
- Tables, Add Constraint: Removed unneeded "Close w/o saving" prompt
- Bad screen scaling in some cases
- Access violation after dropping subobject
- Access violation in Mat. View "Used By" tab
- Can't rename favorites folder
- Data tab Filter/Sort dialog - "Columns" dropdown not wide enough
- Double clicking on trigger errors not finding the errors in source tab
- Dragging multiple objects from Favorites only including one object
- Error when F5 to refresh if quick filter is dropped down
- Load Trigger Into Editor ignored Editor's Schema Name options
- Procedure node not selected in navigator after FIND parameter and parameters not displayed
- Run Scheduler Chain after lost connection throws access violation
- Run Scheduler Job dialog too small
- Save Procedure/Function defaulted to wrong extension in save dialog
- Single Row of tabs mode - Right/Left arrows not shown in Windows 11
- SQL error displaying Scheduler job run log on Oracle version 10.1
- Synonyms and "Uses/Used By" RHS tabs running unneeded SQL in some cases
- Tablespace's RHS Objects tab not displaying grid
- Treeview selected node not visible in many color themes
- Schema Compare:
- "Include schema in migration DDL" option ignored if "format" also checked
- Create Materialized View including default comment on underlying table
- False diffs on LOBS, Tables, and Indexes found if segment exists on source DB but not target
- False diffs on triggers if FOLLOWS clause contains schema name
- Invalid parameter in sync script with LOBs:
Next -1 - Option for "Clusters" not always remembered
- Some "no action taken" comments in sync script did not mention which object they are talking about, making the comment useless.
- Statements generated for tables auto-created by domain indexes
- Sync script attempting to alter tables automatically created for materialized view logs
- Sync script attempting to drop materialized view as a table
- Sync script attempting to modify constraints in the recycle bin
- Session Browser:
- Explain plan failed when connected to RAC without an Oracle client
- Filter settings lost
- Open Cursors subtab changes selected row in parent grid.
- Settings: "File in use" error when saving some settings
- Shutdown: Toad not shutting down properly after connection loss during editor backup process
- Single Object Compare:
- Excessive queries during incremental search of target schema
- Unneeded queries run when launched from Schema Browser
- SQLNet Editor: Dash-style comments after numeric values causing errors
- Startup: Fixed slow startup due to system proxy settings not being detected properly
- Subscription: Access violation after update
- Team Coding:
- Access Violation after dropping Mat. View
- Error checking in/out objects with unicode character in object name
- Unicode lost when comparing files
- TNSNames Editor:
- Formatting caused unsupported parameters to disappear without warning
- SSL_SERVER_SN_MATCH parameter not supported
- Toolbars: Flickery when color schemes enabled
- Trace File Browser: contrast problems in dark mode
- TSR: Added missing color themes
- Window Bar: Not sorting correctly when connection bar also sorted
- Window Menu:
- Minimized Editor tabs not restored
- Minimized windows always restored as maximized
- WINE compatibility: Fixed access violation from Schema Browser
- Workspaces
- Changes in Editor contents lost if loaded object from DB
- Dropdown doesn't support incremental search
- Minimized window position lost after multiple saves
- Modified files loaded incorrectly when split to multiple editor tabs
- Not able to toggle Workspace toolbar's visibility
- Position of minimized windows was lost
- Removed artifact on mainform when workspace toolbar hidden
- Split files marked as modified when not modified
- Unicode data was lost
Enhancements
- Automation Designer:
- Action Palette is now much more user-friendly
- Export Dataset - Parameters can now be passed into SQL Files
- Replaced navigator with nodes in the tree.
- Connection Bar Button: Added "Frequently Used Windows" right-click option
- Connection Colors: Color now visible on Toad's main form when Color Scheme also enabled
- Connection Error dialog: Added suggestion to verify installation of MS Visual Studio redistributable if using instant client
- Connections:
- If logged in as a common user with the SET CONTAINER privilege, you can now right-click on connection bar button to change to a different pluggable/container
- TCPS protocol can now be used in no-client mode
- SSH connections can now be defined within Toad. You no longer need to use PuTTY or similar to do this
- Copy Table Data: 'Default Settings' behavior made more clear
- Create Table: Added prompt to launch Import Table Data after creating columns from file
- Data grids: Can now sort by column header click when SQL already has ORDER BY
- DB Health Scan: New window similar to DB Health Check, but looks nicer. Improvements to follow.
- Debugger: Added a "Check Privileges" window on the main menu
- Describe windows: Added server info to window caption (ungrouped describe windows)
- Editor
- "Export all grids to Excel" now handles "file in use" errors gracefully
- Add prompt when multiple matching tables exist on Shift+Rt-Click
- Added a summary page to "Export all grids to Excel"
- Added ability to pin data grids (after F9 or CTRL+Enter). Look for the pin icon on the toolbar above the grid.
- Added an optional mini-navigator panel at the top of the edit area
- Added option in script output to sync currently selected grid with SQL in script, and vice versa
- Added option to dumb down the smart upper/lowercase feature
- Added option to ignore utPLSQL if it is installed.
- Added option to trim whitespace when saving files
- Added refresh button above data grids
- Backup Engine now does a much better job of cleaning up after itself
- Improved package parse time in Editor and Schema Browser when "Show References" unchecked
- Parameter assistance will now appear faster for Oracle built-in functions which exist in the SYS.STANDARD package. For example, when you type
TO_CHAR(then wait.
- Error Dialogs: Removed "Search Forums" in error dialogs caused by loss of DB connection
- Generate Schema Script:
- Added ability to export private synonyms for exported schema's objects
- Added option to combine files for some object types
- New option to include schema in object file names
- Grid Find/Filter: Added ability to find a value in any column
- Import Table Data: Added "Create new table" button
- Licensing: License expiration warning was too imposing. We dialed it back a bit.
- Logging: Added enhanced logging for internet activity
- Manage User Files: Grids, desktops and window positions can now be restored after resetting user files
- Object Palette: Can now display subobjects as Schema Browser does
- Object Search:
- Now remembers settings per-connection
- Now remembers settings when launched from Export DDL
- Options:
- Got rid of DBA page. Moved those options out to their respective windows
- Internet access can now be disabled from Toad options window
- Toolbars/Menus, shortcuts: Added a search box
- Oracle 23c:
- Added new keywords for syntax highlighting
- Added support for "create if not exists"
- Added support for "drop if exists"
- Added support for annotations
- Added support for boolean datatypes
- Added support for domains
- Added support for JSON Relational Duality Views
- Added support for new DEFAULT ON NULL options
- Added support for PRECHECK keyword on constraints
- Added support for schema privileges
- Schema Browser:
- Added "Copy script to Editor" in SB-Tables-Triggers
- Added ability to pin quick filters
- Added options for Show SQL and Commit when refreshing refresh groups
- Added options to exclude Domain Index tables, Toad Feature tables, and Oracle feature tables
- Added separate icons for Session and Transactional Global Temporary Tables
- Dropping an object from Invalid Objects tab now gives a more descriptive prompt
- Improved performance of Package/Proc/Func nodes
- Minor improvements to filter for triggers
- Moved Table's right-click "n Selected Items" items to "create" submenu
- Tables-Partitions - added a note to clarify that some data is from statistics and may not be exact
- Work around ORA-01873 which can occur when querying DBA_JOBS after database upgrade to 19c or newer
- Schema Compare: Add options (under Options -> Script) to verify that a) tablespace exists in target DB and b) Oracle option exists in target DB. Either of these could make the SQL in the sync script fail. With the new option checked, if a statement will fail, the difference is colored red and unchecked on the difference details page. This will exclude it from the sync script. You can check it if you want to include it in the sync script anyway.
- Session Browser:
- "Filter" dropdown and funnel icon consolidated into one, and moved so it is nearer to "Limit" controls.
- Added "Kill Session" button to Locks tab.
- Added status column to Locks tab
- Single Record Viewer: Added ability to copy column name and value to clipboard
- SQLNet Editor: Improved look of this window and added a few parameters for SSL
- TNSNames Editor: Added support for Retry Delay, Retry Count, and Compression parameters
- Trace File Browser: "Load Trace File From Server" dialog has improved workflow and new filtering and preview options
- Window Bar:
- Added "Current Connection Only" menu item on right-click menu
- Rearranged items on right-click menu for a cleaner and more useful look
- Workspaces:
- Can now be specified from command line like "Toad.exe -workspace X" where X is workspace name. Put X in double-quotes if it contains spaces.
- Combined buttons into one dropdown to save space on the toolbar
The change log for Toad version 16.3 is here