Toad® for Oracle 14.2
Release Notes
Revised 6/16/2021
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 Oracle 14.2 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. The following products may be part of your Toad for Oracle Edition:
The following Toad for Oracle 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 |
Toad® for Oracle® Xpert — Includes all features in Base and Professional Editions SQL Optimizer for Oracle® |
Toad for Oracle Developer Edition |
Toad® for Oracle® Xpert Code Tester for Oracle® Benchmark Factory® for Databases - Oracle Edition |
Toad for Oracle DBA Edition |
Toad® for Oracle® Xpert DB Admin Module Add-on Spotlight on Oracle® — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle Data Guard Benchmark Factory® for Databases - Oracle Edition Toad® Data Modeler |
Toad for Oracle DBA RAC Edition |
Toad® for Oracle® Xpert DB Admin Module Add-on Spotlight on Oracle® with RAC Option — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle Data Guard Benchmark Factory® for Databases - Oracle Edition Toad® Data Modeler |
Toad for Oracle DBA Exadata Edition |
Toad® for Oracle® Xpert DB Admin Module Add-on Spotlight on Oracle® with RAC and Exadata Options — Includes Spotlight on Unix/Linux, Spotlight on Windows, and Spotlight on Oracle® Data Guard Benchmark Factory® for Databases - Oracle Edition Toad® Data Modeler |
Note: The DB Admin Module can be added to any Toad Edition.
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
Note: Applies to Toad for Oracle Subscription with online licensing.
Toad for Oracle Subscription was introduced in version 14.0, but limited to Base product functionality. We are pleased to announce that the following editions are now supported:
Much empasis was placed on improving application stability and security. Well over 100 defects identified by customers, internal testing, and by data collected from the Toad Improvement Program were resolved.
The Toad Improvement Program collects anonymous usage data to help the Toad for Oracle team identify usage patterns and prioritize new development including, but not limited to, organizing the UI to make the features you rely on more accessible. The Toad Improvement Program also collects data on unhandled exceptions so that we can identify and resolve defects. We'd like to thank all who participate in Toad's ongoing success by enabling Toad Improvement Program data collection. To enable Toad Improvement Program data collection, select "Yes" to the participation opt-in in Options (View | Options | Online).
Import can now resume after connection loss.
Treeview mode now supports Adaptive Plans.
New action added for single column export.
Improvements to loading saved workspaces:
As part of ongoing efforts to ensure the continued performance and security of our products, we are certifying our product releases up to specific Oracle database and Windows releases. When there is a new Toad for Oracle release available, we will notify our users to upgrade to the latest release.
Note: Applies to Toad for Oracle Subscription with online licensing.
Toad for Oracle Subscription maps licenses to your Quest.com account which are managed via a new, self-service licensing portal. Sign in with your Quest.com account to begin using Toad immediately. New users are automatically issued a 30-day trial during which you are free to explore all of Toad's features. Learn more.
Note: Running multiple copies of Toad is supported, but only the first copy will make presistent changes to configuration files. Additional running instances operate in a "virtual" mode where configuration settings are loaded from your last used options, but changes made do not persist when Toad is closed. This is equivalent to the /VIRTUAL command line switch.
Much empasis was placed on improving application stability and security. Well over 100 defects identified by customers, internal testing, and by data collected from the Toad Improvement Program were resolved.
The Toad Improvement Program collects anonymous usage data to help the Toad for Oracle team identify usage patterns and prioritize new development including, but not limited to, organizing the UI to make the features you rely on more accessible. The Toad Improvement Program also collects data on unhandled exceptions so that we can identify and resolve defects. We'd like to thank all who participate in Toad's ongoing success by enabling Toad Improvement Program data collection. To enable Toad Improvement Program data collection, select "Yes" to the participation opt-in in Options (View | Options | Online).
Using data collected from the Toad Improvement Program, the Database | Create menu has been reorganized to group related items and make the commonly used items readibly accessible.
Note: This pertains to Toad for Oracle Subscription, only.
Toad for Oracle Subscription edition is bundled with Quest Auto Update , a service to periodically check for and deliver product updates. Upon successful installation, Quest Auto Update is configured to run automatically using the LocalService account. Product updates are automatically downloaded and a notification window displays alerting you to the pending updates. You can install or dismiss updates from the notification window.
Note:Quest Auto Update does not provide updates for all products produced by Quest.
Support for Analytic Views, Attribute Dimensions, In-Memory Join Groups, and Hierarchies has been added to the following areas...
An option has been added to suppress the error dialog shown when running SQL or compiling PL/SQL raises an ORA exception. Errors are still displayed in the Editor's error panel. See the "Display SQL errors in popup dialog" option (View | Options | Editor | Behavior).
An option has been added to automatically expand the node for the logon schema when the Schema Browser is opened.
An option has been added allowing for column comments to display as mouse-over tooltips on the Data Grid tab.
Azure DevOps Server 2019 is supported.
The VCS login dialog now selects the repository used for the database, by default.
Optimizations resulting in improved load times, especially on large database.
Additional rules are included to detect German, French, and Italian sensitive data patterns.
Anomalies in data used to populate charts can cause auto-scaling such that the remainder of the data is indecipherable. To combat this, a new option has been added allowing for user-defined min/max chart values and how to handle data outside of this range. Data falling outside of the display range can be skipped, replaced with the previous data point's value, or the max/min display value can be used. See the Alerts and Display tab in the Database Monitor Options window.
Improved performance in displaying this window.
When connected to a container database (CDB) on Oracle RAC you can now specify the pluggable database (PDB) instances to open or close.
Constraints are now listed individually in the run report and a new option has been added allowing for constraints to be exported to their own .sql file.
Ability to group and filter by "Container ID" has been added for easily identifying which pluggable database each session pertains to.
Added support for extracting encrypted passwords for the "identified by values" clause using DBMS_METADATA. DBMS_METADATA is accessible to all users having the SELECT ANY ROLE system privilege.
The following is a list of enhancements submitted by Toad for Oracle users through Idea Pond and implemented in this release.
The Toad for Oracle Idea Pond on Toad World is a site where you can submit your ideas to improve Toad and vote or comment on ideas submitted by other users. The Toad development team has always been driven by Toad customers, and Idea Pond makes it easy for you to tell us what changes are most important.
Enhancement | Issue ID | Link to Idea Pond |
---|---|---|
Delete button added to Login window. | TMB-1666 | link |
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. Feedback Términos de uso Privacidad Cookie Preference Center