Toad® for Oracle 17.1
Release Notes
Revised 5/23/2024
New Features and Enhancements |
Enhancements from Idea Pond |
Discontinued Features |
Resolved Issues |
Known Issues |
System Requirements |
Product Licensing |
Getting Started with Toad |
Globalization |
About Us |
Copyright |
Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:
The Toad for Oracle solutions are built for you, by you. Nearly two decades of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over two million, Toad for Oracle continues to be the "de facto" standard tool for database development and administration.
Toad World is a unique and valuable resource available to all Toad users. Toad World provides forums, blogs, videos, product information, Beta releases (when available), and Trial downloads for Toad products. Visit Toad World at: https://www.toadworld.com.
Two of the most-often used features of Toad World are the Forums and the Idea Pond.
The Toad World blog pages feature a broad range of information, including topics of interest to our industry, as well as instructions from team members on how to use the latest Toad features.
The Toad for Oracle web-based training is a perfect accompaniment to your product license. This free training walks you through major product features and explains how to perform frequent tasks. You’ll also see how to utilize time-saving automation functionality. You’ll receive a certificate of completion for each course once you pass the accompanying test.
Toad for Oracle17.1 is a minor release, with enhanced features and functionality.
Toad for Oracle 17.1 includes component and requirement upgrades. These upgrades address security vulnerabilities previously identified in the third party component.
Each Toad for Oracle Edition is packaged with additional Quest products to expand your experience.
Toad for Oracle is now available with subscription licensing. The benefits of subscription include:
The following products may be part of your Toad for Oracle Subscription Edition:
The following Toad for Oracle Subscription Editions are available:
Edition |
Licensed |
---|---|
Toad for Oracle Base Subscription Edition |
Toad® for Oracle® |
Toad for Oracle Professional Subscription Edition |
Toad® for Oracle® Professional |
Toad for Oracle Professional DB Admin Subscription Edition |
Everything in Toad® for Oracle® Professional DB Admin Module Add-on Sensitive Data Protection Add-on |
Toad for Oracle Xpert Plus Edition |
Everything in Toad® for Oracle® Professional DB Admin Edition SQL Optimizer for Oracle® |
Toad for Oracle Developer Plus Edition |
Everything in Toad® for Oracle® Xpert Plus Code Tester for Oracle® Benchmark Factory® for Databases - Oracle Edition with 100 virtual users |
Toad for Oracle DBA Plus with erwin Edition |
Everything in Toad® for Oracle® Developer Plus Benchmark Factory® for Databases - Oracle Edition with 500 virtual users Spotlight on Oracle® erwin Data Modeler Lite for Oracle® |
Toad for Oracle DBA RAC Plus with erwin Edition |
Everything in Toad® for Oracle® DBA Plus with erwin Spotlight on Oracle® with RAC Option |
Toad for Oracle DBA Exadata Plus with erwin Edition |
Everything in Toad® for Oracle® DBA RAC Plus with erwin – Includes Exadata Spotlight on Oracle® with RAC and Exadata Options |
Note: Spotlight on Oracle® includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard.
Toad for Oracle non-Subscription uses offline term and perpetual licensing. This is Toad for Oracle's legacy licensing model.
The following products may be part of your Toad for Oracle non-Subscription Edition:
The following Toad for Oracle non-Subscription Editions are available:
Edition |
Licensed |
---|---|
Toad for Oracle Base Edition |
Toad® for Oracle® |
Toad for Oracle Professional Edition |
Toad® for Oracle® Professional |
Toad for Oracle Xpert Edition |
Everything in Toad® for Oracle® Professional SQL Optimizer for Oracle® |
Toad for Oracle Developer Edition |
Everything in Toad® for Oracle® Xpert Code Tester for Oracle® Benchmark Factory® for Databases - Oracle Edition |
Toad for Oracle DBA with erwin Edition |
Everything in Toad® for Oracle® Developer DB Admin Module Add-on Spotlight on Oracle® Benchmark Factory® for Databases - Oracle Edition erwin Data Modeler Lite for Oracle® |
Toad for Oracle DBA RAC with erwin Edition |
Everything in Toad® for Oracle® DBA with erwin Spotlight on Oracle® with RAC Option |
Toad for Oracle DBA Exadata with erwin Edition |
Everything in Toad® for Oracle® DBA RAC with erwin – Includes Exadata Spotlight on Oracle® with RAC and Exadata Options |
Toad for Oracle DBA Edition |
Everything in Toad® for Oracle® Developer DB Admin Module Add-on Spotlight on Oracle® Benchmark Factory® for Databases - Oracle Edition Toad Data Modeler® |
Toad for Oracle DBA RAC Edition |
Everything in Toad® for Oracle® DBA Spotlight on Oracle® with RAC Option |
Toad for Oracle DBA Exadata Edition |
Everything in Toad® for Oracle® DBA RAC – Includes Exadata Spotlight on Oracle® with RAC and Exadata Options |
Note: The DB Admin Module can be added to any Toad Edition. Spotlight on Oracle® includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard.
Toad for Oracle is now available for Mac using a new license specific for macOS. Click here to download the free trial.
It includes the great, award-winning Toad features you have grown to love with a few limitations:
The following Toad for Oracle on Mac Editions are available:
Edition |
Licensed |
---|---|
Toad for Oracle on Mac Professional DB Admin Subscription Edition |
Toad® for Oracle® Professional DB Admin Module Add-on Sensitive Data Protection Add-on |
Toad for Oracle on Mac Professional DB Admin Edition |
Toad® for Oracle® Professional DB Admin Module Add-on |
For more information about the products in your Toad for Oracle Edition and the minimum system requirements for running these products, see the Toad for Oracle Editions release notes at: https://support.quest.com/technical-documents
Using the power of AI, Toad examines your code providing an explanation of its purpose.
Note: AIExplain is a preview feature available to Toad for Oracle Subscription users. Refer to the Knowledge Base for instructions on how to enable it. Learn more about AI and Toad at Toad World.
IPv6 support has been extended to the following features:
Note: The order of statements and number of line breaks may differ when using "One file per schema" or "One file per object type" options
Toad for Oracle Professional DB Admin edition is now available for Mac. Click here to download the free trial.
Toad.exe -workspace my_favorite_workspace_name
DB Health Scan is a new window similar to DB Health Check with improved visualization of results. This window is a preview feature with additional improvements planned for a future release.
New minimap with options to control position and scale
Support for font ligatures
Revamped brace highlighting options to provide additional behavior
Search across all open Editor tabs from Find in Files/Editors
Auto Replace options to include/exclude replacement within comments and strings
Option to lock tab positions when multi-line tab mode is enabled
Reload file/database object improvements to support reloading all items that have been modified
Object name highlighting option to highlight dependencies from other schemas
Navigator option to exclude PL/SQL parameters from sorting
Navigator option to indicate PL/SQL parameter position
Navigator option to show references
Context menu is customizable
Refactoring item to replace package constant references with their literal values
Format Code can be canceled
Additional user experience improvements
Object quick filter support for regular expressions
Data tab filter dialog automatically adds quotes for IN/NOT IN conditions
Data tab filter dialog options to save size/position
Scheduler Jobs displays "subname" field on the Run Log tab
Tables | Copy to another schema allows setting options as the default values used each time the window opens
Tables | Copy to another schema options to create indexes/constraints when creating non-existent tables in the destination schema
Create/Alter Materialized View option to specify the refresh group
ID column added to the Arguments tab for PL/SQL
Option to lock tab positions when multi-line tab mode is enabled
Additional schemes
New action to run reports configured in the Reports Manager
New action to perform single column import
Running apps can be canceled
Execute Script action option to suppress the progress dialog
Action palette buttons rearranged to be more intuitive
Expanded copy to clipboard support to areas that previously lacked it
Paste from clipboard across multiple selected cells
Sort on multiple columns
Context menu, Appearance submenu improvements
7-Zip and gzip compression
Query executed when "Display all results in grid" is unchecked can be canceled
Flat File export option to set the end of line style
Excel File export option to retry when the file is locked by another process
Excel File/Instance export option to allow formulas which sets the Excel column formatting accordingly
Ability to rename a window by right-clicking on its Window Bar button
Option to show individual Editor tabs on the main Window menu
Create multiple logins at once applying the same properties across databases defined in tnsnames.ora
Reconnect Lost Connections feature added to only reconnect sessions that are known to be disconnected
Test Connections from the Login window improvements to update password if an ORA-01017 is raised and multiselect output
Filter tabs when previously used connections are displayed using one of the "Tabbed by" views
Toad Script Runner clientless connection support
Retry button on the connection error dialog
Messages configured using the SEC_USER_UNAUTHORIZED_ACCESS_BANNER and SEC_USER_AUDIT_ACTION_BANNER properties in the server's sqlnet.ora are displayed and acceptance is required to make the connection
Custom field values can be modified when editing multiple login records
Option to group object DDL into folders by their object type
Option to exclude BEQUEATH clause from Views
Improved workflow when moving items from recently used to saved
Options moved from the toolbar to a dedicated dialog to improve toolbar usefulness
Additional display options and usability improvements
Automatically backup key configuration files with options to configure what is backed up, the frequency, and a discard policy for old backups
Ability to reset user files and selectively restore configuration files from a backup
Team Coding automatically remaps object IDs which is necessary when controlled objects have been dropped and recreated
Code Analysis option to limit the number of violations per rule type
Compare Schemas produces an overall summary file in addition to each comparison's individual report when the multiple schemas option is used
Various improvements to document recovery
Various improvements to Master Detail Browser
Many bugs fixes and other enhancements
Knowledge Xpert. Knowledge Xpert is no longer available on Toad World. Beginning with release 13.1, Toad components no longer reference the online Knowledge Xpert.
Ask a Question. The Go to Toad World and Ask a Question commands on the Toad World toolbar have been replaced. To ask a question, click the Forums toolbar button to go directly to the forum. To go to Toad World, click the Forums or the Browse Blogs toolbar buttons. You can also use the Help menu: Help | Toad World | Forums. This change is found in Toad for Oracle 13.1 or later.
Integration with Toad Intelligence Central. Beginning with Toad for Oracle 13.1, Toad no longer provides integration with Toad Intelligence Central. The Toad Intelligence Central window is not available and you cannot publish scripts, files, Code Analysis results, and other resources to a Toad Intelligence Central server using Toad for Oracle. You cannot connect to Toad Intelligence Central through Toad for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center