TOAD (r) Copyright (c) 1995-2002 Quest Software All Rights Reserved
TOAD 7.3 ReleaseNotes
LAST REVISED: April 18, 2002
Table of ContentsIntroduction
These Release Notes are intended to provide an overview of new functionality and to list many of the fixes that have been implemented in this release of TOAD. The Release Notes are also intended to help you upgrade to the new version. For an introduction to TOAD, also see readme.txt.
TOAD 7.3 base features configurable toolbars, multi-selection on many schema browser tabs, a "Selected Text" option in the Replace dialog, an HTML Schema documentation generator, a greatly enhanced window for analyzing tables, a powerful window for rebuilding indexes, a window to move a subset of data from one schema to another, an interface for TKProf, multi-selection of tables and views in Reports, a rewrite and expansion of TOAD Security, and an interface for managing TNS names files. Many of the tabs in the schema browser now allow multi-selection of objects. The debugger now has the ability to watch the values in cursors and record types, and object-type function return values are declared properly in the anonymous block. The DBA module features enhancements to Generate Schema Script, a faster Database Monitor, Database Wizard enhancements, a Top Sessions window, a Database Health Check window, a Create Snapshot Log window, and an interface for DBMS_LOGMNR. Some features in TOAD 7.3 can be run from the command line, which makes it possible to use NT scheduler to schedule them to run. There are many new things, plus fixes to old things, so have fun trying them out!
TopImportant Installation and Upgrade Information
| ITEM | DETAILS |
|---|---|
| New Formatter Plus DLL | Formatter Plus IDE version 1.2.2 (which includes
FmtPlus.dll v4.6.6) is installed with TOAD 7.3 because an up-to-date
FmtPlus.dll is required for complete debugger functionality and because
some places in TOAD, such as the SGA Trace window, use the FmtPlus.dll to
format code. In order to format your code in the editors or launch
Formatter Plus, you will need to contact Quest in order to get a license
for Formatter Plus. The installation for the DLL is
FmtPlus_v1.2.2_IDE.exe, which is located in the same directory as
Toad.exe. Formatter Plus IDE version 1.2.2 is also compatible with prior
versions of TOAD. TOAD looks for FmtPlus.dll in its local directory. If it finds the dll there, then all files associated with Formatter Plus are loaded/launched from the local directory. If TOAD does not find FmtPlus.dll in its local directory, it checks the registry for the location where Formatter Plus was most recently installed, and loads/launches all Formatter Plus files from there. |
| TOAD Security Rewritten, Will Need To Be Set Up Again | TOAD Security has been redesigned in TOAD 7.3. Many more
TOAD Features can be handled through TOAD Security in version 7.3 than in
version 7.2. Note that TOAD Security's TOAD_RESTRICTIONS table in 7.3 REVOKES features from users, whereas having a record in TOAD 7.2's TOAD_SECURITY table normally meant GRANTING a feature to a user. Note that if you administer TOAD Security using roles, the users should not have the Admin privilege on the roles used for TOAD Security, because they will be able to revoke those roles from themselves. Because of the extensive changes, there is no upgrade script from TOAD Security in TOAD 7.2 to TOAD Security in TOAD 7.3. Because different tables are used for TOAD Security in versions 7.2 and 7.3, setting up TOAD Security for 7.3 should not interfere with the security set up in TOAD 7.2 for people who still use TOAD 7.2. |
| Trial DBA Module | The DBA module is still available on a trial basis until June 30, 2002. For information about what is in the DBA module, go to the "What's in the DBA module" menu item, shown under the DBA menu. You can disable the DBA module through TOAD Security, or by setting "IgnoreDBAModule=1" in your Toad.ini file. |
Enhancements
TopEnhancements and Changes in Base Toad
| WINDOW | CASE# | DESCRIPTION |
|---|---|---|
| Analyze All Tables | Total rewrite. The top of the window contains analysis options. The bottom of the window has 5 tabs: Table Statistics, Table Partition Statistics, Index Statistics, Index Partition Statistics, and Chained Rows Statistics. Each of the tabs contains a grid with information from the database so that statistics can be viewed, and individual items can be selected to analyze. | |
| Compare Schemas | Can now be run from the command line, perhaps for the purpose of a nightly scheduled comparison. Results can be emailed and/or saved to a file. | |
| Compare Schemas | Has buttons to save and load settings. Saved settings can be used for executing Compare Schemas from a command line. | |
| Compare Schemas | Right-click item on "Results (Interactive)" tab to save the treeview to a text file. | |
| Compare Schemas | Right-click items on Options tab to check or uncheck all object types | |
| DBMS Output | DBMS Output window and DBMS Output tab in SQL Editor now have a button to toggle polling for DBMS Output, in addition to the button just for enabling and disabling DBMS Output. Enabling DBMS Output with the round red/green toggle just performs a DBMS_OUTPUT.ENABLE, but it doesn't retrieve anything that has been placed in the DBMS Output buffer. When the polling toggle is turned on, the window polls for DBMS Output, i.e. it retrieves text from the DBMS Output buffer at a specified interval. | |
| DBMS Output | The popup window for processing PL/SQL Statements in Background will now poll for DBMS Output only if the session in TOAD has DBMS Output enabled or the "Automatically poll for DBMS Output if output detected" option is on. | |
| Data Subset Wizard | Window to copy a subset of the data for one schema into another schema. If you have the DBA module, the window will let you export the DDL for the schema objects too. | |
| Database Wizard | Minimum database size is now 272 MB | |
| Date/Time editor | Has new buttons to make the date or time portion null | |
| Find & Replace | "Selected text" option added to the Replace dialog, for replacing all instances within the text currently highlighted in the editor. Does not apply to Regular Expression searches. | |
| Find & Replace | Find & Replace options are now saved and restored from TOAD.ini. | |
| Find & Replace | New option in Options > Editors: "Find word under the cursor." If checked, then the Find and Replace dialogs will automatically be filled in with the word under the cursor in the editor. Otherwise, they will remember what they were most recently looking for, during the current TOAD session. | |
| Find & Replace | Windows are resizable to allow you to see longer strings | |
| HTML Schema Doc Generator | Generates one or more HTML documents showing the contents of the selected schema(s). By default, this window appears under the Tools menu. Use the "save settings" button in the window, and read in the saved settings file about how to run this window from the command line. | |
| Load in External Editor | You should now use a %S after any "External editor command
line" that you configure. All of the places where TOAD launches an
external editor (proc editor, SQL Editor, offline editor, FTP, SQL*Loader
wizard, Database wizard, Script manager) expect this.
Examples: NOTEPAD.EXE %S WINWORD.EXE %S |
|
| Menu Shortcuts | The key combinations to activate menu items are now user-configurable. Right-click over the main toolbar and choose "Menu Shortcuts." | |
| Options > Editors | "Show Editor toolbars on Sql Editor and Procedure Editor" option removed b/c both have fully configurable toolbars. | |
| Options > Editors | "Treat underbar character as part of object names" -- when checked, this option will treat the underbar character AND the space character as part of object names, for the purpose of highlighting items by double-clicking | |
| Oracle Users List | Now displays checkboxes next to user names | |
| Procedure Editor | Better support for mixed-case object names and schema names | |
| Procedure Editor | New option to determine whether packages loaded from the schema browser or the "Load Source from Existing Object" button will have the spec and body loaded onto separate tabs of the procedure editor or if both will go onto the same tab. | |
| Procedure Editor | 74157 | Proc Editor saves its size and position between sessions |
| Procedure Editor | Toolbars are configurable. Right-click on the toolbar and choose Customize, or right-click in the editor and choose Procedure Editor Desktop > Customize Toolbars. Buttons to bring up the debugger windows (watches, breakpoints, call stack, and DBMS output) can be added to the toolbar. | |
| Rebuild Multiple Indexes | New window to analyze and rebuild indexes in the database.
It allows you to analyze the indexes in order to determine whether they
need to be rebuilt, and it allows you to set the storage information for
the indexes that you want to rebuild. You can choose to send an email with the results of the rebuild. You can also run this window from the command line. By default, this window appears on the Tools menu. |
|
| Relocate Index | The Relocate Index window has been removed because the Rebuild Multiple Indexes window covers its functionality and more. | |
| Reports | TOAD Reports window now allows multi-selection of tables and views. | |
| SB > Procs | Arguments for procs and functions in a package are now retrieved by parsing the package body instead of querying the Oracle data dictionary. | |
| SB > Procs | New option in Options > Schema Browser > Page 2: Sort package procedures alphabetically. Determines whether the procedures and functions in a package will be sorted alphabetically or in the order in which they appear in the code. Applies to the Procs tab only. | |
| SB > Procs | New option under Options > Schema Browser > Page 2 to "Sort package procedures alphabetically" | |
| SB > Sequences | Browser filter added for Sequences tab | |
| SB > Tables | A Cancel button will appear while populating the Data tab, if "SQL Editor > Process queries in threads" is checked. | |
| SB > Tables | Generate Statement > Select added to right-click menu. This menu item creates a select statement for the selected table. | |
| SB > Tables | Support for mixed-case column names in the datagrids including the SB Data tab (updating, inserting) is fixed for 7.3. | |
| SB > Tables | You can again drag and drop table names into the editors from the tables tab | |
| SB > Triggers | There are some additional radio buttons for filtering the list of triggers: Valid only, Invalid only, Valid and Invalid, or Skip the Validity Check altogether (which populates the tab faster) | |
| SB > Triggers | You can drag and drop trigger names into the editors from the triggers tab | |
| SB > Views | "Blank page" icons for valid views no longer appear. "Red X" icons for invalid views still appear. | |
| SB > Views | A Cancel button will appear while populating the Data tab, if "SQL Editor > Process queries in threads" is checked. | |
| SB > Views | Triggers tab added to RHS to show Instead Of triggers on views. | |
| SB Options | Many options moved from "Page 1" to "Page 2" | |
| SB Options | New option allows you to turn off the toolbars on the left-hand side of the schema browser: "Page 2: Show toolbars above object lists on left hand side." | |
| SB Options | There are now 3 options for users to show: All users, only users that own objects, or only users that own objects other than synonyms. | |
| SQL Editor | Has configurable toolbars. Right-click on the toolbar and choose Customize, or right-click in the editor and choose Customize Toolbars. Four right-click menu items from the grid can be added to the SE toolbar: Save As, Size to header, Size to data, and Print Grid. | |
| SQL Editor | If Options > SQL Editor > Process PLSQL statements in background is checked, then DDL statements will also be run in separate threads. | |
| SQL Statement Recall | If you press Enter while the cursor is in the "SQL Contains" edit box, then the "Go" button gets pressed. | |
| Save As | Columns and headers are now left-aligned when the grid is saved to XLS, and gridlines are not applied | |
| Save As | The routine to save grid contents to an XLS file has been replaced. This should address most of the previous concerns about this feature. | |
| Schema Browser | "Delete" button now performs a Drop for Tables, Views, Triggers, and Sequences | |
| Schema Browser | Supports multi-selection of tables, views, procs,
sequences, triggers, users, and roles. Right-click menus expanded. Multi-selection can be turned off by unchecking Options > Schema Browser > Page 2 > Allow multi-select on left hand lists (disables drag-n-drop object names) |
|
| Script Manager | It's no longer necessary to close the Script Manager window in order to get the Quick Scripts to show up on the toolbar. | |
| Show Toolbar | View > Show toolbar menu item removed. Toolbars enabled/disabled through menu configuration. | |
| TKProf interface | This wizard constructs a command line to call Oracle's utility TKProf, which formats trace files into a human-readable form. The Executables tab of the TOAD Options window now contains a box to specify the location of TKProf. Appears on the Tools menu by default. | |
| TNSNames Editor | Window for managing your tnsnames.ora files. Allows you to add, edit, and delete entries, as well as copy entries from one file to another. Appears on the Tools menu by default. There is a corresponding option under "Editors" to "Reload last used tns names files". This option determines whether the editor will reopen the file you loaded the last time you opened the window. | |
| TOAD Options | "Find" button added to the bottom of the options window to allow you to search the options | |
| TOAD Options | "Startup > Use a 3D Main form" option removed. | |
| TOAD Options | Because of the growing number of TOAD windows that can send email, an "Email settings" tab has been added to the Options window. The email settings for the Database Monitor and the Instance Manager have been moved to this tab. Email settings are now stored in Toadmail.ini. | |
| TOAD Options | Tabs on left hand side are now in alphabetical order | |
| TOAD Security | Rewritten. TOAD Security information is now stored in one table, called TOAD_RESTRICTIONS, which is created in TOADSecurity.sql. Top-level menu privileges were removed because items can now be moved between menus. Many more individual menu items are covered by the new TOAD Security. Adding privileges TAKES them AWAY from the user, as opposed to the old TOAD Security model, in which adding privileges to a user GRANTED them TO the user. | |
| Toolbars | The toolbars and menus for the main window, SQL Editor, and
Procedure Editor are now configurable. Menu items can be renamed, and
items can be moved on and off the toolbars. The toolbars can also be
undocked from the TOAD main window. There are also a few options included,
such as the ability to have TOAD's menus show the more recently used menu
items first, and the option to show large icons. To configure a menu bar or toolbar, right-click over it and choose "Customize." |
|
| User editor | MAC privileges removed from the System Privileges tab | |
| Windows XP | TOAD has now been determined to be compatible with Windows XP. |
Enhancements in the Debugger
| WINDOW | CASE# | DESCRIPTION |
|---|---|---|
| Debugger | Debug popup windows remember their size and positions between sessions. | |
| Debugger | Nested tables should now be declared correctly in the anonymous block. | |
| Debugger | New option in Options > Debugging: "Transaction Control". Determines whether a COMMIT statment or a ROLLBACK statement will appear at the end of the anonymous block. You can also choose "Prompt", so that you will be prompted when debugging completes as to whether you want to do a commit or a rollback for the sessions spawned by the debugger. | |
| Debugger | Record parameters should now be declared correctly in the anonymous block. | |
| Watches | Debugger allows watches on records, cursors, and cursor variables. See help file for limitations. | |
| Watches | If text is selected when "Add Watch at Cursor" is invoked, TOAD sets the watch on the selected text. If no text is selected it grabs the text under the cursor. This change occurs so that if you have a recordname.fieldname, you can highlight recordname just to get a watch on it. And if you have an expression like v_List(2), where v_List is a varray, then you can highlight the whole expression to put a watch on it. | |
| Watches | Watches tab now has a shortcut to the Evaluate/Modify window |
DBA Module Enhancements
| WINDOW | CASE# | DESCRIPTION |
|---|---|---|
| Create Snapshot Log | Window to create a snapshot log. Appears by default on the Create menu | |
| Database Monitor | Reworked the SQL code for the Database Monitor to greatly increase performance. | |
| Database Wizard | "Use UNDO tablespace" checkbox added to Step 3 for 9i-compatible databases. | |
| Database Wizard | "View Script" button added to the end of the wizard to show the created script in your default editor (specified under Options > Editors > External Editor) | |
| Database Wizard | Extent Management options added for tablespaces | |
| Database Wizard | Logging/Nologging options added for tablespaces | |
| Database Wizard | Tablespace Layout Preview window in Automatic Layout mode is now editable. | |
| Generate Schema Script | 60555 | Allows selection of multiple schemas for which to generate
a script. It can write the scripts all to one file, or you can specify a
directory and have each schema go to its own file in that directory where
the file is named after the schema. Def files can be written only if it is
one file per schema, they can't be combined into one file. |
| Generate Schema Script | 75844 | Generate Schema Script optionally sizes extents according to the current total size of the table as opposed to the size of the last extent. |
| Generate Schema Script | Hash clusters supported | |
| Generate Schema Script | New checkboxes for Queue Tables and Queues | |
| Generate Schema Script | Object grants are included in the script for a user. | |
| Generate Schema Script | Right-click menu on options tab has "Select All" and "Unselect All" | |
| Health Check | Runs a configurable set of queries on the database to produce a report, which can be saved in Text, RTF, or HTML format. The report can also be automatically emailed. You can run this window from the Windows command line. By default, the Database Health Check window appears on the DBA menu. | |
| Instance Manager | Two new buttons have been added to the bottom of the
Instance Manager: Build init.ora: This button builds an init.ora file for the currently selected service name. Refresh current: This button tests the listener, node, and database connection for the currently selected service name. |
|
| Log Switch Frequency Map | Shows how many redo log switches were performed for each hour and each day. By default, this window appears on the DBA menu. | |
| LogMiner | Interface for Oracle's DBMS_LOGMNR package on Oracle 8i and 9i. By default, this window appears on the DBA menu. | |
| Pinned Code | Includes treeview at the bottom of the window for pinning
objects that aren't currently in the SGA. Uses buttons with icons. Flush SGA button added. Auto refresh functionality added. |
|
| SB > Tablespaces | New Properties tab on the right hand side of the Tablespaces tab | |
| Top Session Finder | Window to help determine which sessions on the database are using the most resources. The window allows you to configure which resources you want to examine. Appears on the DBA menu by default. | |
| UNIX Monitor | Support for Tru64 has been added, but the Disk I/O graph is empty for Tru64 machines |
Caveats
| WINDOW | CASE# | DESCRIPTION | WORKAROUND |
|---|---|---|---|
| Command Line | When you are running TOAD from the Command Line, and your settings file contains a "CloseTOAD" command, then the prompts to exit TOAD and to commit your changes will be skipped. (Presumably, you won't be there to press OK.) | ||
| Shortcuts | If you delete a menu item, the shortcut key for that menu item will also cease to function. For example, if you remove "Describe" from the Edit menu, then the shortcut for Describe, F4, will become non-functional. You can add an item back to the menu by right-clicking over the main toolbar, choosing Customize, and dragging the item from the Commands tab up to the menu. | ||
| SB > Tablespaces | Drop Tablespace now uses INCLUDING CONTENTS option | ||
| TNSNames Editor | The TNSNames editor does not support the Oracle 7 COMMUNITY attribute or the Oracle 8i features of multiple Descriptions and/or multiple address lists. Therefore, if entries of these types are edited, you may lose the information in them. The window does, however, make automatic backups in the same folder where you load the tnsnames file from. |
Bug Fixes
| WINDOW | CASE# | DESCRIPTION |
|---|---|---|
| Code Templates | 73777 | Function code template ended in a colon instead of a semicolon |
| Compare Schemas | 88751 | Missing tables list incorrect |
| Compare Schemas | 75477 76473 76597 82640 | PL/SQL: numeric or value error when schema contains check constraint with > 255 characters of text |
| Compare Schemas | 68548 73535 | Synch script had drop/add constraint in wrong order. |
| Data Grid | 73473 | Excel Export was translating NULLs to 0's for number columns |
| Database > Privs | 83586 | Not showing object privs granted via Role for User Tab |
| Debugger | Multiple DBMS_OUTPUT statements in a procedure on Oracle 7 would cause a timeout | |
| Debugger | 85402 85865 | OS-identified users get "null password given" when starting the debugger, and they can't debug |
| Debugger | 85411 | Parser causes debugged proc to open in multiple tab(s) |
| Debugger | 78217 | Run to Cursor (F12) fails when debugging in a Dependent procedure |
| End Connection | 93925 | "List Index Out of Bounds" when there is only one connection open, and you press OK. |
| Explain Plan | 76030 81268 | Plan wasn't showing partition columns on 8.0 databases |
| Explain Plan | 75594 | Value in TQ column truncated (column is now called 'Object Node') |
| Export Table | 82054 | DDL for same table(s) showing up in multiple files |
| Export Table | 83346 | files are created with repeated foreign key constraints from previous tables |
| Formatter Integration | 42127 | Couldn't launch Formatter Plus through TOAD |
| Formatter Integration | The Formatting Options are now loaded from the same directory as FmtPlus.dll when FmtPlus.dll is located in a directory other than the TOAD directory. | |
| Generate Schema Script | Cluster indexes weren't included when only "indexes" was checked. | |
| Generate Schema Script | Creates package specs after all package bodies, so that package bodies don't get created as invalid when there are circular references between package bodies. | |
| Generate Schema Script | 76656 | Named NOT NULL constraints are not explicitly specified. |
| Generate Schema Script | 75293 92931 | PL/SQL: numeric or value error when schema contains check constraint with > 255 characters of text |
| Help > Support > Email | 31388 | Email was truncated if site message contained an ampersand |
| Instance Manager | 79010 79656 90505 | Login info truncated if login name and connection string were long |
| Kill/Trace Session | 24321 | "Not enough timers available" error |
| Kill/Trace Session | Duplicate rows were appearing on the All Locks tab. The query has been fixed, and it also appears to run faster. The bottom panel also now corresponds to the grid in the All Locks tab when that tab is selected. | |
| Object Search | 54134 | Grid > Save As not working in Object Search window |
| Offline Text Editor | 85941 | Save Button active when no changes made to file. |
| 74157 | Printer margins for editors are saved between sessions | |
| Procedure Editor | 32468 87269 | Compiling Objects with excessive # of comment lines caused TOAD to disappear |
| Procedure Editor | 74405 76928 84029 84106 93605 93882 94558 94672 | Copy/Paste problems resolved |
| Procedure Editor | 75640 81683 85008 90589 | Files added to Reopen list on File menu |
| Procedure Editor | 88012 92393 87359 91088 | Opening non-existent files caused problems... |
| Procedure Editor | 84486 | Spec not being compiled w/DEBUG |
| Procedure Editor | 76469 | proc names in quotes cause Status Bar to go blank after compile |
| Relocate Indexes | 27314 | Issue #2: Relocate Indexes has been replaced in 7.3 by Rebuild Multiple Indexes, which does not force you to choose a different tablespace when rebuilding the index. |
| Reports | 84300 87755 | OS-identified user couldn't run TOAD Reports |
| SB > Java | 81574 92662 85977 | Java not appearing for 9i database. |
| SB > Procs | 76489 | 2 Procs w/same name in different package -> 2nd proc was displaying 1st proc's source code |
| SB > Procs | 60846 74555 82803 | Compile All wasn't following dependencies |
| SB > Procs | 76875 81539 | Created/Updated dates not updated when selecting a different package |
| SB > Procs | Dependencies tabs are now populated correctly depending on whether you've chosen the spec or the body for a package. | |
| SB > Procs | 76211 | Package Spec wasn't compiling if there was no package body |
| SB > Procs | 58121 90821 | Selecting overloaded method in package spec or body now takes you to the correct line of the code |
| SB > Procs | 76489 | Selecting procedure w/same name in different packages didn't cause refresh |
| SB > Queues | Supports queues created with retention set to "FOREVER" | |
| SB > Snapshots | 74637 84555 | Snapshots tab uses the ALL_ views if user doesn't have access to the DBA views |
| SB > Tables | 85519 | R-Click Add Index fails to add 'LOCAL' keyword in ddl script |
| SB > Tables | REF columns shown correctly on Columns tab (were previously shown as object columns) | |
| SB > Tables | 74161 | Used By Tab - F4 no longer works |
| SB > Tablespaces | 76544 88138 | SYSTEM user couldn't create script for tablespace |
| SB > Triggers | 73683 74124 75045 75161 79859 80170 80544 | Database triggers now shown again |
| SB > Triggers | 68291 | Trigger is marked invalid when "Load in Proc Editor" button is used |
| SB > Triggers | 73683 76091 76562 78113 78523 79859 83458 93620 86547 86593 86967 87108 86547 86967 90094 | Triggers again shown under owner of trigger instead of owner of table |
| SB > Triggers | 76064 | Triggers were being truncated if the WHEN or DESCRIPTION columns were > 1999 chars |
| SGA Trace | 74210 74756 75105 74455 74574 76030 76342 76625 77149 80786 84018 84534 87710 87969 91034 92492 | Duplicate SQL statements are appearing. |
| SQL Editor | 76309 | Cancel button for script execution has been restored |
| SQL Editor | 74687 74929 75502 75761 76931 77671 78062 82162 92306 84288 89080 91485 92157 | DML statements terminated with ; failed. |
| SQL Editor | 42392 | Not recognizing substitution variables inside quoted strings |
| SQL Editor | 74179 74328 74512 75049 75241 76000 76192 76646 77127 77128 77173 77472 77515 77780 78091 78209 78531 78872 79277 79517 79524 79828 80744 82064 82803 92290 92314 83460 83985 84028 86402 86532 86814 85450 85483 87242 87245 87309 87533 92601 93326 93597 88511 88653 88820 89178 89216 89313 90519 90546 | Tabs and carriage returns used as separators within a statement in the SQL Editor could cause a statement to fail |
| SQL Modeler | 86213 | Unable to create join between varchar2 and number columns. |
| SQL Statement Recall | 75805 | Remove feature of Named and Personal Statement Recall does not work. |
| Save As | 69200 80124 | Number columns now exported as Numbers, not as General |
| Save As | 86890 | Problems with copy/paste into Excel |
| Schema Browser | "Tabbed schema browser" option unchecked: The right-click menu over the object type dropdown on the left hand side can now be used to configure which object types show up in the dropdown. |
|
| TOAD | 84683 75560 | 2nd Login Dialog - Password not available when new db connection necessary |
| TOAD | 55284 | Connection problems if user has a table called USER_TYPES |
| TOAD | 58844 59290 76520 78766 78915 78935 80446 81793 83662 83932 86382 86829 84538 94392 94585 88138 88880 89949 91144 91443 | TOAD was taking focus by itself |
| TOAD | 79346 | When you use the ctrl Tab function to switch windows, it was giving an extra set of Windows management buttons. |
| Table Name Select | Leaving Table Select window open after closing all session windows could produce AV. | |
| Tools > Estimate Index Size | 80969 | Large NUMROWS values causes ORA-01455 |
| UNIX Monitor | 74566 74396 75124 75538 75854 86369 86932 87249 90349 91890 | Automatic Refresh not working |
| UNIX Monitor | Fixed bug in UNIX Monitor where disk activity graph was not showing anything for Redhat Linux 7.2. In addition, this fix makes the monitor refresh noticeably faster as it eliminates the writing and deletion of 3 temp files per refresh on the server that TOAD was doing. |
Some Known Issues
TopIssues for New/Changed Features
| WINDOW | DESCRIPTION | WORKAROUND |
|---|---|---|
| Debugger | AV when starting the debugger after Watch has been deleted by another user. | Don't delete a watch unless your user set the watch. The debugger will start if the watches tab is not in front. Or, you can close and reopen the connection. |
| Debugger | "Undeclared identifier" for record related to cursor declared in package spec | 1. Load package spec and body onto the same tab. 2. Put cursor declarations before procedure prototypes in the package spec. |
| Debugger | Can't watch implicitly declared record in package body initialization section | |
| Debugger | Can't watch record declared in package body on Watches tab | Use hover-watch |
| Debugger | Cannot watch cursor that is declared as a prototype in the spec and then completely declared in body | Load package body onto a separate tab |
| Debugger | If "Allow compiling when source loaded from database" is unchecked, then the procedure will not be recompiled, even if you are prompted to do so when starting the debugger | Check Options > Procedure Editor > Allow compiling when source loaded from database. Or, load from file. |
| Debugger | If you are debugging a procedure that belongs to another
schema, then you will not be able to watch records that are declared
without a schema name qualifier. Example: rec mytable%ROWTYPE; would need to be changed to rec myuser.mytable%ROWTYPE; Or cursor c1 is select * from mytable; would need to be changed to cursor c1 is select * from myuser.mytable; | Log in as the object owner, or use a schema name qualifier in the code. Or watch individual fields instead of the whole record. |
| Debugger | You cannot watch a record whose associated query contains a variable in the SELECT list | Declare the record type explicitly, as in: TYPE myrectype is RECORD ( col1 number); rec myrectype; |
| Debugger | You must step into the debugger in order to set a watch on a record. The debugger needs context information to resolve a watch as a record. | Step into the code first, then set the watch |
| Menu Shortcuts | Some menu items do not appear in the Menu Shortcuts window because they are hard-coded into TOAD | |
| Menus | Accelerator keys in MDI child windows are looking to the main menu before looking to the MDI child window. | Open Tools > Customize. Right-click over top-level menus to change or remove the accelerator keys from their names. |
| Schema Browser | You cannot drag and drop object names from the tabs in the browser. | Uncheck Options > Schema Browser > Page 2 > Allow
multi-select on left hand lists. This will restore drag-n-drop for the Tables, Views, Users, Roles, Sequences, and Triggers tabs. There is not currently a fix for this on the Procs tab. |
Some Other Known Issues
| WINDOW | CASE# | DESCRIPTION | WORKAROUND |
|---|---|---|---|
| Compile Dependencies | "Compile Dependencies" stops at a package -- doesn't compile lower dependents of package body or upper dependents of spec | ||
| Data Grid | 86145 | Date with year 0001 inserted as 1901 | |
| Data Grid | 75020 | Grid scrolls horizontally back to focused cell when scrolling vertically | Select a cell in the visible part of the grid before scrolling vertically. |
| Export Wizard | 91177 | Cannot export as SYSDBA or as OS-identified user | Use the Export Wizard to build the parameter file, but run
the export from the command line: Exp.exe 'SYS/SYSPWD@MYDB.WORLD AS SYSDBA' PARFILE="D:\myexportfile.dat" or Exp.exe '/@MYDB.WORLD AS SYSDBA' PARFILE="D:\myexportfile.dat" Or grant EXP_FULL_DATABASE to another user on the database. |
| Free Space Deficits | 46770-1 76920 76936 77711 | Free Space Deficits isn't working on Oracle 7 databases | Use option #20 in the Database Health Check |
| Index Script | 58851 | Script incorrect for some multi-column function-based indexes | If you have the DBA module, use Generate Schema Script |
| Print Grid | 74517 | Margin settings not saving for Print Grid | |
| Procedure Editor | An Undo after a Format Code clears the editor | Reload text from database or file | |
| Procedure Editor | 74483 | When a trigger has the same name as the table, the Navigator Panel shows the trigger name as the first variable declared in the trigger. | Uncheck Options > Editors > Use syntax highlighting on tablenames, and reopen the connection |
| Profiler | 93437 | In the Profiler Analysis window, the "Code" column is blank when drilling down to the 3rd level | |
| SQL Editor | 47100-2 | No column dropdown for subquery tables | |
| SQL*Loader | Cannot launch SQL*Loader as SYSDBA or OS-identified user | Use the SQL*Loader Wizard to build the control file, but
run the load from the command line SQLLDR.EXE userid='SYS/SYSPWD@MYDB AS SYSDBA' control=C:\mycontrol.ctl log=C:\mylog.log or SQLLDR.EXE userid=/@MYDB control=C:\mycontrol.ctl log=C:\mylog.log Or perform the load as a different user. |
|
| SQL*Loader | 91937 | Control file preview doesn't show selected Table Parameters when a table column is selected in the treeview | Select the table name when setting Table Parameters |
| SQLab Integration | 50030 | Extra text passed to SQLab when there is no blank line before the highlighted statement | |
| SQLab Integration | The current version of SQLab does not support 9i | ||
| Synonyms/Describe | 35340 87158 59890 93189 | Problems resolving synonym through a DB Link | |
| Synonyms/Describe | "Unknown object type" -- can't describe a snapshot | ||
| Test Connections | 86211 | Does not register Program and Module under V$SESSION | |
| Test Connections | 86211 | TOAD "disappears" on two Test Connections > Reconnect attempts for an 8.1.6 or lower Oracle client | Upgrade the Oracle client |
| UTF8 | TOAD's data layer does not currently support Unicode. | ||
| Unix Monitor | Dr. Watson error or error message when a process on AIX becomes defunct. The Unix monitor should continue to function on AIX similarly to how it functioned in 7.2, but for the above reason, we have removed AIX from the help file's list of supported OS's for the Unix monitor. | ||
| Window Menu | "Arrange All" is non-functional. | ||
| Window Menu | Trying to access the Window menu while certain other windows are closing can result in error messages, TOAD closing, and the loss of the list of current windows. | Reopen TOAD. Right-click over the toolbar and choose Customize. Go to the Commands tab, choose "Window", and drag "(List of Current windows)" back into the Window menu. |