Quest Toad for Oracle

Version 9.5

Release Notes

October 25th, 2007

Contents

Welcome to Toad for Oracle

New in this Release

Resolved Issues

Enhancements

Known Issues

Installation and Upgrade

System Requirements

Global Operations
 

For More Information

Release Statistics


Welcome to Toad for Oracle

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 a short summary of new features, also see the "New in Toad" topic in the Toad help file. For an introduction to Toad, please see TOAD Getting Started Guide located in the 'docs' folder.

Toad for Oracle 9.5 continues our commitment to providing new features while improving and streamlining existing features and windows. The 9.5 development cycle focused on stability, usability, and consistency. Some examples include additional support for Oracle 11g databases and functionality. Please note that the Oracle 11g client has not been tested with Toad 9.5. Support for 11g includes support for the hierarchical profiler.

In the Toad Professional Edition, the Debugger can now open the Parameters window automatically, and you can set both debugging parameters and profiler parameters from this location.

In the Quest DBA module, there is now a graphic interface to the StatsPack functionality, including several charts and data grids for easy viewing of statistics gathered.

 


New in This Release

New Features in Toad for Oracle 9.5:

 


Resolved Issues

The following is a list of issues addressed in this release of Toad for Oracle:

Component Description QCM
Action Console AV when loading grid results in editor a second time 32470
Alter Table window Alter table window closes after "Invalid Identifier" error 32268
Alter User Erroneous ability to revoke privs/roles from Object Grants tab 32934
Citrix Error: "Invalid file ...CONNECTIONSPWD.ini" when using Toad on a Citrix server 32127
Compare Schemas Formatting error in sync script 32959
Compare Schemas GUI Print Sync Script button prints results summary instead of script 32317
Compare Schemas Settings Compare schema with DBLInk and "SQL*Plus 'prompt' comments in script" is invalid 30995
Compare Schemas Settings Schema Compare ignores ¿include schema name in migration DDL¿ re sequences 31097
Create Scheduler Program Schedule Program defaults to sending NULL for procedure arguments 31121
Create Script for Table Rebuild table script does not drop index if it shares its name with a constraint 31947
Create Script for Table Script DDL does not show LOB index name of tablespace 32244
Create Synonym Making public synonym for a database link using Toad. 32298
Create Table window Destination connection inheriting login mode from source connection 32957
Create Trigger Create script for triggers inserts blocks for spaces 32111
Create and Alter Table Constraints not added on table rebuild when constraint names are in quotes 31896
Create and Alter Table AV when launching Alter Table window, then hitting <esc> 32370
Create or Alter View Table name not highlighted when validating a query with a nonexistent table 32587
DB Menu: Export DDL Request to have output SQL filenames in lowercase 32589
DB Menu: Export Source Code List of triggers in selection dialog is not alpha sorted 30842
DB Menu: Export Table as Flat File Null date columns exported as '12-30-1899' 31986
DB Menu: Import Source Files Will not import alpha chars that correspond with their respective column letter 30822
DB Menu: Import Table Data Wizard Hot search for object in dropdown does not work initially 31283
DB Menu: Import Table Data Wizard Error when importing data of XMLTYPE 32266
DB Menu: Import Table Data Wizard Need to hide error for blanks in date columns 32644
DB Menu: Import Table Data Wizard AV when importing attached data 32931
Data Grid Save As: when exporting to XLS file, numbers with more than 15 digits are rounded 30974
Data Grid Create INSERT does not escape quotes properly 31047
Data Grid Data Grid | Print Grid paper size settings not retained properly 31245
Data Grid Create insert fails with ORA-01741on column named "COMMENT" 32319
Data Grid Save As gives error for result of query SELECT dummy as "ä" FROM dual; 32293
Data Grid: Blob Edit window Popup editor not enabling POST action when changes made for XMLTYPE 32434
Data Grid: Find Value in Column "Cannot focus a disabled or invisible window" on unpinned grid with Find Data 30882
Database Health Check (DBA) Running HC from command line with -min option pauses Toad until it gets focus 32316
Database Health Check (DBA) Toad issuing query on PARTITION_NAME (HC item #26) for 7.3.4 server 32328
Database Menu: Create Reference table is blank when using Database>Create>Constraint 30908
Database Menu: Create Create table wizard only allows 255 byte size max on RAW data types 31551
Database Monitor (DBA) MS Waited/Sec Data Incorrect 32677
Debug Menu (Pro) Particular script yields AV when debugging as SYS 31265
Describe (F4) Repeatable AV when closing desc window 30904
Editor AV resulting from zero-size .LAY file 31703
Editor Opening multiple sessions at once, editor windows not associated with correct session 32314
Editor Options Editor>Behavior>"Use single editor instance" has no effect 30885
Editor Options: Key Mappings Impossible to remap the home/end/page navigation keys 30780
Editor Options: Languages (Lexers) Adding a code template always places new template at bottom of list 30829
Editor Options: Languages (Lexers) Highlighting attributes for strings in PL/SQL not retained in upgrade 32588
Editor Window: Column/Object dropdown Dot lookup hangs Toad when scanning a very large select statement 31067
Editor options: Auto Replace Auto replace does not work if preceded by a period 30864
Editor: Auto Trace Tab Autotrace pulling incorrect description columns in 9.2.0.7 31310
Editor: CodeXpert Tab (Pro/Exp) AV when processing large file > 500kb 31093
Editor: CodeXpert Tab (Pro/Exp) Erroneous readability suggestion when "decode" encountered 32507
Editor: Compile Compile error results when using OUT param as a sys_refcursor 30873
Editor: Compile Compiling with debug invalidates other packages and procedures 32678
Editor: Create New PL/SQL Object Toad caches list of parameters; shows wrong order in hint 32168
Editor: Execute Script execution arrow not pointing to correct lines when highlighting is used 30746
Editor: Execute Statement execution arrow does not follow "commit" statements 30821
Editor: Explain Plan Tab Access Violation when explaining a statement that has a "with" and a self-join 30844
Editor: Explain Plan Tab "other_tag" preference in Adjust Content does nothing in EP tab 31316
Editor: Explain Plan Tab Incorrect comment for explain plan 30972
Editor: JDWP Debugger (Pro) Watch variables undefined for record types within a FOR cursor 30818
Editor: PL/SQL Debugger (Pro) Need support for 10g RAC when using LDAP for connections 32256
Editor: Save and Load to Disk Editor not assigning yellow package symbol to editor tabs for files loaded form disk 32365
Editor: Script Debugger Unable to debug if object name is in quotes 32188
Editor: Script Engine Unable to pass bind variables with script execution 30738
Editor: Script Engine LDAP entry not set properly in QSE 32769
Editor: Script Engine "ALTER SYSTEM SET use_stored_outlines = TRUE" yields incorrect status message 32250
Editor: Script Engine SET commands not persisting throughout editor session, despite option setting 31066
Editor: Script Engine Script Engine no longer allows alternate connect syntax 31012
Editor: Script Engine Blank lines not recognized in script output 30750
Editor: Syntax Parser Reserved words getting cut off when UPPERCASE used with fixed-width fonts 30796
Editor: Window Unindent does not bring lines all the way to gutter as in 8.6 30744
Editor: Window Picklist does not auto-drop if used in an UPDATE statement 31197
Estimate Index Size Function based indexes not showing 30993
Files Options Can not undo file type associations under Options 30812
Files Options Error log path/file not being saved 31220
Generate Schema Script (DBA) Generated Schema script does not suppress grants on No Recycle Bin option 30982
Generate Schema Script (DBA) Redundant types appear in create script as SYS_PLSQL_* 32805
Generate Schema Script (DBA) GSS returning wrong results when both TABLES and CLUSTERS checked 31100
Generate Schema Script (DBA) Substitute schema name ignored for system privs 31156
Instance Manager Options Options not being saved 30838
Master/Detail Browser Column selection not being saved 31051
Object Palette Filter color for OP not the same as Schema Browser, despite identical settings 32346
Object Search Since version 8.0, search no longer highlights search keyword in results 30768
Oracle Options Optimizer hints not taking effect for 8.1 db, 9iR2 client 32437
Oracle Parameters Format incorrect if first sorted by column header 32577
Oracle Parameters Adding control file strips quotes and adds them back in incorrectly 32676
Oracle Parser "member of" syntax not supported 31207
QB Tree View: Input the Where definition Access Violation when adding where clause with multiple joins 30976
QB: Execute Generated Query NO PARALLEL hint has no closing "*/" in generated query tab 31346
Redo Log Manager (DBA) Cannot add log member if log group was created with kilobytes spec 30859
Replace Prompting for incorrect search string 30742
SB Tables: Copy Data To Another Schema Error "cannot bind a LONG..." when copying data to another schema 30782
SB Tables: Export Table Data Incorrect script for spatial datatypes 30830
SB Tables: Filter Tables Applied filter in SB not being carried over to Data Duplicates as in previous versions 31800
SB Tables: RHS Columns Tab Filter tab of the Table Sort/Filter dialog no longer allows auto-replace in edit box 31170
SB Tables: RHS Data Tab "Object Not Allocated" error when viewing data from AQ Queue tables 31119
SB Tables: RHS Data Tab Columns missing in SRV when sorting by column name 32576
SB Tables: RHS Data Tab Size to column data/header options do not take effect until SB restart 31586
SB Tables: RHS Data Tab large fonts: post and cancel post buttons are truncated 32288
SB: Jobs Treeview showing erroneous job listing 32471
SB: Procedures Procs showing twice under certain conditions, due to a compile w/debug issue 32830
SB: Roles View Object Grants in Session Info 32704
SB: Snapshots Desc on MVs shows table instead of MV 30792
SB: Snapshots Not recognizing partitioned materialized views 31023
SB: Tables Typo in r-click context flyout 30970
SB: Tables Save As SQL Loader type does not create a file for an empty table 32286
SB: Tables Leaving off estimate_statistics clause for compute with DBMS_STATS 32672
SB: Tablespaces Error when viewing very large tablespaces 32472
SGA Trace/Optimization Window not refreshing properly when re-opening 32090
SQL Command Recall Error on Toad install if upgrade and SAVEDSQL.XML exists 32272
SQL Command Recall SQL Recall search function occasionally gives erratic results 32828
SQL*Loader Wizard Wrong syntax created in control file when partitions used 30831
SQL*Loader Wizard Loader does not handle multiple tabs correctly 32312
SQL*Loader Wizard Table not visible in SQL*Loader window 30999
Save As Export Format doesn't change options when using keyboard 32451
Save As Toad does nothing when saving datasets with more than 1000 columns 32545
Save As Scrolling to bottom of data set and saving to file results in empty data set 32510
Schema Browser Long delay after displaying table with lots of columns 31559
Schema Browser Options Silently ignore 01044 error on when viewing table with lots of FKs 32567
Schema Browser Tree View Params not visible in Arguments tab in treeview 30775
Schema Browser Tree View Filter expands wrong node on LHS 32645
Script Manager Output results not correct 31620
Server Login Window Error when Toad opens minimized and auto-connect is enabled 30779
Server Login Window Dragging Custom Fields Into Header 32392
Server Login Window Oracle homes information in the connections.ini file not being updated 30958
Server Login Window Launching SQL Optimizer with direct connect throws error 30811
Server Login: LDAP Editor Incorrect format applied when order is changed 31517
Session Browser Unable to alter session for user names that need to be double-quoted 31017
Session Browser Not querying gv$sql_plan to obtain a cached EP in RAC 32927
Session Browser Problem when using tuning advisor to create a SQL profile 32808
Session Browser Error when starting trace on 8.0.6 server 32391
Session Browser Inst_id not being populated for RAC instances 31108
Session Browser Locks not showing across nodes on a cluster environment 32324
Session Browser Not connecting to right instance if traced/killed session is not in current instance 31495
Single Object Compare Comparing a package works only in one direction 32294
TNSNames Editor Unable to place special chars in comments of TNSNAMES.ORA 30739
TNSNames Editor Error when clicking on "Text Editor" tab 30945
TOAD Desktop Focus is jumping to "floating" windows and causing AV on close 31013
Toad Policy Manager Policy mgmt on a port other than 80 does not work after a restart of the service 32487
Top Sessions (DBA) Ambiguous column error when double-clicking an LHS param 32251
Unix Scheduler Unix Job Scheduler not saving new server entries 30837
Windows Options Audit Object window does not retain set size and position 31239
Windows Options Auto-open/bring to front does not work for DB Browser 32844
eBiz Browser Blank browser filter dialogs appear when tabs selected that have no filter 30745

Enhancements

The following is a list of enhancements implemented in this release of Toad for Oracle:

Base Toad

Window Description
Analyze All Objects Option added to load either all partitions for a table/Index, or just the table itself. This allows for analyzing the entire partitioned table/index in a single command.
Analyze All Objects 10g Locking/unlocking of table and schema stats is now supported. A "Force" option is included to allow overriding the lock
CodeXpert Added error log for command line processing. CXCmdLineErrors.log is stored in the User Files folder and is generated for every CX command line run.
Data Grids Date/Time Editor now has a 'SYSDATE' button which will pull the Oracle system date to be posted. SYSDATE can now also be typed into a data grid cell and the Oracle system date will be posted to date columns.
Describe Object types can now be described via F4
Editor Ability to sort selected lines added. To access this functionality, the toolbar must be customized the buttons added (buttons are in the "Edit" category in the customize dialog).)
Editor The Editor now uses a new parsing technology for statement/script execution and populating the navigator. The new parser resolves several issues while adding 10g and 11g syntax support.
Editor Options 2 new options added in Editor > Code Assist: "Ctrl+click loads PL/SQL objects" and "Ctrl+click describes objects"
Export DDL 11g Support: All 11g partitioning and subpartitioning types are now supported in DDL extraction throughout Toad.
File > Print Print selection added back. If text is selected in the Editor, only the selected text will be printed.
File > Print "Print Preview" item added to File menu.
Grid > Report Report Wizard Dialog closes when you hit the ESC key.
Health Check New option added to "List tablespaces with less than X% free space remaining" check to allow checking for X MB remaining
Import Table Data Now supports DBase (dbf) files
Index Editor 11g Support: New partitioning/subpartitioning options are now supported.
Index Editor 11g Support: Bitmap join Indexes can now be created on Index Organized Tables. Indexes can now be created and/or altered using the VISIBILITY option.
Materialized View Editor 11g Support: New partitioning/subpartitioning options are now supported.
Materialized View Log Editor 11g Support: New partitioning/subpartitioning options are now supported.
Options All of those possible interval/timestamp types have been removed from the Create/Alter table window, and they've been replaced with "Interval..." and "Timestamp...". If you choose either, then a dialog will appear where you can choose options (or just hit ENTER to take the default). This is also implemented in Create/Alter Cluster and Create/Alter Program windows.
Options > Data Grid New options Data Grids > Data > Preview Clob Data. Default is checked. If unchecked, Toad will display just '(Clob)' or '(CLOB)' and load the grid much faster.
Options > Datatypes Timestamp/Interval has been removed. If either is selected in the the Create/Alter window a popup is opened where the user can set the scale.
Options > Execute/Compile The option 'Always open Parameters window' has been added requiring the Parameters window display when executing or debugging a procedure. The default is checked.
Options > Execute/Compile The option 'Auto name Profiler runs' has been added. If enabled the user will no longer be presented with a popup box to enter the run name. The name will be the object name plus timestamp. The default is unchecked.
Options > Execute/Compile Option added to use hierarchical profiler for 11g database. Also added an option to save profiler settings between sessions.
Profile Editor Hierarchical Profiler has been added for 11g database. R-click and select filter to choose only the results you specify in the tree.
Project Manager Multiple project files can now be open simultaneously (multi-tabbed).
Project Manager Files can now be dragged from the Editor (drag from the tab) to and FTP node in the Project Manager and the file is uploaded to FTP.
Project Manager Project Manager now auto-registers applications based on file type. For example, loading a folder item of type .doc will load your file based on your windows file association.
SB > Indexes RHS Subpartions tab added
SB > Tables A LOB editor has been added in the Create/Alter Table window. Right-click on a BLOB, CLOB or NCLOB column and choose "Lob Parameters...
SB > Tables 11g Support: SecureFiles now supported for LOB columns.
SB > Tables Create/Alter Table window now has a LOB editor for BLOB, CLOB and NCLOB datatypes. The Editor is available from the right-click menu on the LOB datatype column.
SB > Triggers User name no longer getting duplicated or included incorrectly, in the Trigger Script.
SB > Users > Copy/Clone User Clone/Copy now includes object privileges.
SQL Optimizer Integration If SQL Optimizer 7 is installed and nothing is selected in the Editor, the entire contents of the editor is sent to SQL Optimizer for batch processing
Schema Browser RHS now shows details about LHS items. If no items are selected, RHS shows details about all LHS items.
Schema Browser RHS Partition and Subpartition tabs now show the type of partition or subpartition.
Schema Browser In Non-Treeview modes, item icons are now in their own columns. Icons can be grouped on the LHS and RHS. Applies to all tabs exception LHS packages, procedures, functions, and types.
Schema Browser Object icons have been moved into their own column in SB object lists, so that they can be sorted.
Script Execution Script Execution now uses a new parsing technology that supports Oracle 10g and 11g syntax
Set Parameters PL/SQL Profiling can now be enabled or disabled through this window.
Table Editor "Load cols from file" function now supports DBase files (dbf)
Table Editor 11g Support: Virtual columns and the READ ONLY option are now supported.
Table Editor 11g Support: New partitioning options are now supported including Interval, reference, and system partitioning. Additional subpartitioning options are supported as well.
Toad Release notes added to help menu.
Toad Toad now support 11g database connectivity and select features. As of Toad 9.5 release date, Oracle has not released an 11g client for windows.
Toolbars/Menus "Connection list" dropdown button has been restored and can be added to the Toad toolbar.
Trigger Editor 11g Support: Now supports compound triggers and FOLLOWS TRIGGER options.
User Script In 11g, passwords are no longer stored in encrypted form in dba_users. So Toad cannot create user scripts with the "IDENTIFIED BY VALUES" clause. Instead, the script will have "IDENTIFIED BY &ltpassword>", and the user will have to fill in the password before running the script.

DBA Module

Window Description
ADDM/AWR Snapshot Baseline management tabs have been reworked to display full Snaphsot details and detail grids now allow for column sorting and incremental searches.
Session Browser Six new columns have been added on the LHS and RHS Sessions tabs: CPU, CPU This Call, UGA Memory, PGA Memory, Rollbacks, Commits.
StatsPack Browser Located under Database-Monitor, this new screen shows changes in various performance metrics between statspack snapshots. The window supports Statspack in Oracle versions 8.1.6 and higher, and is available only in the DBA Module. Some of the available features in the Statspack Browser are several built-in charts and grids, the ability to create customized charts and grids and categorize them in a tree view. Also the user may select a range of Snapshots to run their reports again, save and recall selected Snapshots, or save and recall a group of checked charts by database. The Browser also acts as an interface to Statspack administration by allowing the user to manually take or delete Snapshots, quickly identify statspack collection jobs in the database or adjust statspack parameters.

Other Changes to Note

Window Description
Editor Capitalization effects applied to text in the editor are now preserved when saving out to file or clipboard. The Editor now behaves like older versions of Toad in that the capitalization effects are applied permanently when the caret is moved to a new line.
Editor Ctrl+I will not init caps for new users. Existing users will have to manually set Ctrl+I as the shortcut for init caps in the menu shortcuts options page.
Editor Shift+Tab has been added as a secondary keystroke for unindent selection in key mapping.
Editor Options Option to set Code Templates shortcut key has been removed from Editor options > Behavior. This shortcut can now be set in Editor Options > Behavior > Key Mapping
Options > Team Coding Option 'Enable Actions in Schema Browser & Project Manager' now defaults to checked.

 


Known Issues

The following is a list of issues known to exist at the time of Toad for Oracle's release:

Window Description Workaround
CodeXpert Saving results to DB: When dealing with nested procedures, CodeXpert can only insert run data from procs one level deep.  
CodeXpert Saving PL/SQL results to database may fail or save invalid data to database for invalid PL/SQL objects. To ensure PL/SQL results get saved to database correctly, verify the validity of all objects before CodeXpert is run.
DBMS Output DBMS Output doesn't display in the DBMS Output sub tab or the DBMS Output window while debugging or executing pl/sql with debug. If DBMS Output is enabled in the Editor sub-tab or DBMS Output window, DBMS Output will not show while debugging or executing pl/sql in debug mode unless the following option is checked: View > Options > Debugger > "Enable DBMS Output before debug session"
Data Export "Create Insert for Selected Rows" and "Data Export" from the schema browser are giving the error "No exportable columns found" when "Return object names in lower case from selection windows and drag drop" is checked under Options > Editors. 1. Uncheck that option or 2. Right-click on the data grid and choose "Save As". Choose "Insert Statements". If you have selected multiple rows and want to only export those, then check "Selected rows only". If you want to put only certain columns in the Insert statements, then you will need to use the right-click "Select columns" function to choose the columns for the grid before going to "Save As" or 3. If you just want to get INSERT statements for a lot of tables, go to Database > Export > Table Data
Data Grids REF columns now show as "(REFERENCE)" in the grid instead of showing the object ID, but you can still double-click them to pop up a display of the object type that they point to.  
Data Grids Some users have received the error "invalid rowid" when adding a row to a data grid The error appears to be linked to the use of Oracle 7 client calls. You are using Oracle 7 client calls if either of the following is true: 1. "SQL*Net compatible Net8" is checked on your Server Login window 2. You are using an Oracle 7 client (Note that "Force SQL*Net" will force TOAD to select the Oracle client on your machine.) We strongly recommend upgrading your Oracle client to at least the same version as the Oracle server that you are connecting to. We also recommend unchecking "SQL*Net compatible Net8" -- the only known advantage of using that setting with TOAD 7.5 is that for Oracle 8.0.x clients, it is the only way to get the error position in the SQL Editor
Data Grids Data does not always display correctly when using an older Oracle Client on a newer Oracle Database. We strongly recommend using Oracle Clients equal to or greater than the Oracle Databases you are on to ensure data integrity.
Data Grids You may receive an "ORA-00902 invalid datatype" error when editing object, nested table, or varray data if you have redefined the data type for that data during the current session. If you redefine an object type, nested table, or varray and then need to edit data in a table based on that type, end your current connection and begin a new one.
Data Grids Grid scrolls horizontally back to focused cell when scrolling vertically Select a cell in the visible part of the grid before scrolling vertically.
Data Grids Pasting multiple rows of text into a cell will only register the first row of the data. Paste multiple rows of text into the text editor (popup editor) instead of into the grid cell.
Database Probe Database Probe does not work with Oracle version 8.1.5. Upgrade to supported Oracle version 8.1.7
Debugger The debugger is not designed to work with word-wrapped lines, since the editor will then have a different set of line numbers than what is stored in Oracle. Toad provides a warning message about this if you open the procedure editor while word-wrapping is enabled. To disable word-wrap, go to Edit > Editor Options and uncheck "word wrap lines" under "General".
Describe Viewing XML_TYPE data in the F4 describe window may cause memory leaks. Try to limit the amount of times the describe window is used to view XML_TYPE data during a given Toad session. Use the Editor or Schema Browser data grid to do the majority of your work with XML data
Editor On an Oracle 8.0 client, if "Display large numbers in scientific notation" is unchecked, and the query contains a non-alphanumeric other than "*", the error "OCI-22061: invalid format text [TM9]" is returned. Either: 1. Check Options > Data Grid - Data > Display large numbers in scientific notation, or 2. Upgrade the Oracle client to at least Oracle 8.1.6
Editor Parameter hints for overloaded packages are no longer scrollable. The parameter hint will be limited to the size of your screen  
Editor In an Oracle Apps environment, the default syntax highlighting options (options > Editors > General) can make the SQL Editor open very slowly. Go to Options > Editors > General and uncheck all of the options to highlight object names.
Editor The procedure editor will jump to the wrong line number for PL/SQL Errors and debugging stepping if the name of the object is not on the same line as the CREATE OR REPLACE If you add "PELineOffsetOverride=1" under the "[SETTINGS]" section in your Toad.ini, it should fix the offset problems, as long as the CREATE OR REPLACE is on the first line of the editor.
Formatter Plus As long as the FmtPlus.dll exists in the TOAD directory, Toad will read its formatting options from there, even if there are other installations of Formatter Plus on the machine This behavior is meant to ensure that the version of the FmtPlus.dll that Toad is loading will be high enough. If you have Formatter Plus version 1.4.0.6 (FmtPlus.dll version 4.8.0.23) or higher in another place on the machine and you would like Toad to use the options there, uninstall Formatter Plus from the Toad directory and manually delete the FmtPlus.dll from the Toad directory.
Installer If the Toad Group Policy Manager install is an upgrade, the product will not self-register in the local manifest Use the Windows Add/Remove utility to properly remove TGPM
Installer The Quest Installer wizard screens do not correctly remember the user-specified install folders Either exit the installer and start over, or manually modify the installation folders
LDAP Support While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly. These features include but may not be limited to Quest Script Runner, Database Browser, and Service Manager.  
LogMiner You may get the following error when moving from the first screen of the LogMiner to the second screen of the LogMiner: 17:46:25 Info: ORA-06532: Subscript outside of limit ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 ORA-06512: at line 2 This results from an Oracle bug in 8.1.7.0.0 and 8.1.7.1.0. Upgrade to Oracle version 8.1.7.2.0 or higher, or see Oracle Metalink Note:124671.1 for details of how to fix the package.
Multi-file Formatting Results After running a "Profile Code", "Check Syntax", or "Format Code" against files in the Project Manager, a results tab appears in the output window. Clicking on an occurrence node in the results tab will load the file in the appropriate Toad window. If you are loading a full package into the Procedure Editor in the manor and select "yes" to the Spec/Body file split prompt, your file will be split into 2 Procedure Editor tabs. At this point, selecting an occurrence node in the output window will only highlight the appropriate line in the Procedure Editor if the line is in the "Spec" tab. Clicking on an occurrence in the Body of the Package will always highlight the last line in the Spec tab. When loading a package into the procedure edit in this manor, select "no" to the Package spec/body split prompt.
Query Builder Reverse Engineering The Query Builder now supports, for the first time ever, the reverse engineering of queries. SQL Reverse Engineering represents a considerable technological advancement for the Builder. Although it was heavily tested throughout its development lifecycle, due to the vast array of possible queries there may be some queries it can create but cannot reverse. We encourage users to inform Quest if they discover such queries. The main limitations of reverse engineering are that it only supports single-level subqueries in the SELECT and WHERE nodes, and no subqueries in the FROM clause, and some calculated fields that include arithmetic operators might not be reversed correctly.  
SB > Procs Sometimes on Oracle 8.1.7 or higher, after pressing "Compile invalid objects", you may get: ORA-20000: You have insufficient privileges for an object in this schema. ORA-06512: at "SYS.DBMS_UTILITY", line 282 ORA-06512: at line 1 This could mean that you really don't have the privileges to compile the object. But it also happens when the schema contains a package body that does not have an associated spec. Look in the schema that you are trying to compile to see whether there are any orphan package bodies. If it is your own schema, then do: select * from user_objects o1 where object_type = ''PACKAGE BODY'' and not exists (select ''x'' from user_objects o2 where o2.object_name = o1.object_name and o2.object_type = ''PACKAGE'') Then drop any orphan package bodies that are found.
SB > Tables > Data -Changing the order of the columns in the "View/edit query" popup does not change the order of the columns in the grid. -Renaming a column in the "View/edit query" popup moves the renamed column one position to the left. The renamed column will not be editable. Use drag-and-drop in the grid to change the column order.
SQL Monitor The "Explain plan" options page describes SQL Monitor explain plan's limitations and potential side effects. Mainly, since SQL Monitor has to execute statements, it becomes proactive and can interfere with the program's execution flow. And since it executes statements, the statements may get into the SGA, and there is a remote possibility that they may affect the execution plan of the monitored application's statements. The only 100% guaranteed way of getting the execution plan that was actually used by Oracle for the statement is to turn on server-side tracing and get the plan from there. SQL Monitor is not guaranteed to display the plan that Oracle used, although it should be correct in most cases.  
SQL Monitor In order to monitor services, you must run the SQL Monitor from one of your local drives. If you try to monitor a service while SQL Monitor is running on a mapped or network drive, you will get the message "Error installing monitor for the service process." This happens because services run under the "Local System" account, which can only see local drives. Install SQL Monitor on a local drive and run it from there.
Save As > XLS Exporting data grid cells of over 800 bytes (est.) could cause "OLE error 800A03EC" for Microsoft Office 2003 users when using the "XLS Instance" option. Save using the "XLS file" option instead
Script Manager Installed Script Manager files are not found in Citrix and Client/Server Environments. Toad installs packaged SQL Scripts with it's Script Manager. When Toad runs in a Citrix or Client/Server environment, the default paths to these script manager files will be pointing to the wrong place on the Server. These paths need to be changed to point to the client's files. Every client user will have to manually change these paths 1 time. To change the paths, open File > Script Manager and Select the DBA category from the dropdown box. Click the move button and enter your new path, which will be "C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\DBA". Repeat for the "Schema Objects" category and move to "C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\Schema Objects".
Server Login Selecting a new Oracle home in the ''Connect Using'' dropdown box does not guarantee that the correct home will be used. Switching between major Oracle client versions works correctly in Toad. Switching between patch or mid-release versions of Oracle will not always work. For example, switching from Oracle client 9.0.1.4 and Oracle 9.2.0.4 will not guarantee the correct Oracle home is used. To ensure the proper home is used while logging on, close TOAD use the Oracle Home Selector to select your home, and reload TOAD. Select the correct home in the ''Connect Using'' dropdown and login.
Session Browser Session Browser does not work with Oracle version 8.1.5 Upgrade to supported Oracle version 8.1.7
Session Browser The Program name in the Session Browser may be blank or may be the full path to the executable instead of just the executable name. This depends on the Oracle client, not on Toad.  
Session Browser In RAC databases, version 10.1.0.3 (and possibly other 10.1 versions), the query used to show the populate the "Current Statement" in the Session Browser fails with the following error: Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance <instance name> ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments. Uncheck the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary.
Session Browser "PLS-00553: character set name is not recognized" error encountered when opening Session Browser We received this when opening the Session Browser on a 9.0.1 database with a 7.3.4 client. We recommend always using a client version greater than or equal to the server version.
Snapshot Script If you check "Indexes" on the Scripts tab for snapshots, then the primary key for the snapshot will be included in the script, even though the CREATE MATERIALIZED VIEW statement implicitly creates this primary key. We have not been able to determine a way to tell the difference between indexes explicitly created on the snapshot and indexes automatically created when the snapshot is created. If you are running the generated script to recreate the snapshot, then you can simply ignore the error that occurs when the script tries to re-create the primary key index for the snapshot. If you do not normally create indexes on snapshots, then you can uncheck "Indexes" when generating the snapshot script.
Team Coding When you are using CVS as a version control provider, Toad may fail to retrieve the list of projects for you to select from, either in the VCS Browser or in Code Control Groups configuration. Toad determines which files and folders are in your CVS repository by reading the file named Entries. This normally resides in a folder named CVS under each of your working folders. If Toad cannot find this file in your top-level working folder, or if this file does not contain all the projects, then Toad cannot retrieve all the projects. Please see the "Missing CVS\Entries File Error" topic in Help for details about how to create the Entries file.
Team Coding Team Coding and SourceSafe: -Integration via the SCC API is available but not recommended for SourceSafe 6.0 -SourceSafe 5.0 ignores the "Force revision" flag and ignores ''Create a new revision for existing objects'' option when exporting  
Team Coding When you log into CVS from within Toad, Toad opens a command prompt window to send the password to the CVS server. Sometimes, the command prompt window opens in the background instead of the foreground, and this causes the login to fail. When this happens, the user needs to select "Log in to VCS Provider" from the Team Coding menu or toolbar to re-do the login. The second attempt invariably succeeds.  
Team Coding Team Coding and Clearcase: Dynamic Views are not supported via SCC interface. Snapshot Views must be used instead. (Rational case id v0830629, Rational Defect # CMBU00053934)  
Team Coding Most version control providers that integrate with Toad through the SCC API ignore the "Force revision" flag and the "Create a new revision for existing objects" option when exporting.  
Team Coding Team Coding and PVCS: -Integration via the SCC API is available but not recommended for PVCS 6.6 and up. -PVCS 6.6.1 is not supported. In testing, we were not able to get check in and check out to function properly. PVCS 6.6.0 and PVCS 6.7.0, however, worked correctly in testing. -PVCS 6.8.0 is not supported because it has been found to cause a crash in Toad after about 5 to 15 minutes of use. We therefore recommend upgrading to PVCS 6.8.1, which does not have this problem. -PVCS Version Manager 6.6 and above only supports "Tip Revisions" via the COM interface used by Toad. Attempting to retrieve a non-tip revision using the Version Control Browser will always return the latest revision. (Merant case id 1230782). This means that comparing revisions in the VCS Browser will fail because both versions will return the text of the latest version of the file. -After connecting to a PVCS database, successive connections made during the same Toad session will always connect to the same PVCS database, even if a different database is specified in the "Logon to PVCS" dialog. A work-around for this problem is to close and re-open TOAD before attempting to connect to a different PVCS database. If simultaneous connections to two different PVCS databases are required, this can be achieved by opening a second copy of TOAD.
Team Coding Team Coding and StarTeam: If you cancel the login dialog for StarTeam, you will not be able to log in to StarTeam until you restart Toad.  
Team Coding Team Coding is disabled for mixed-case object names  
Toad Help Toad Help file no longer opens for Network installs. Microsoft security update 896358 disables ActiveX Components, which renders the Toad help file useless for network installs. Copy the Toad help file (Toad.chm) from the server to the client and change the following Toad.ini (located in main toad directory under the "User Files" folder) entry to point to the new location: [SETTINGS] HelpFileDir=C:\Program Files\Quest Software\Toad for Oracle 8.6 Client
Unicode Toad's data layer does not support UTF8 / Unicode data. Most non-ASCII characters will display as question marks in the data grid and should not produce any conversion errors except in TOAD Reports. TOAD Reports will produce errors and will not run on UTF8 / Unicode databases. It is therefore not advisable to edit non-ASCII Unicode data in Toad's data grids. Also, some users are still receiving "ORA-01026: multiple buffers of size > 4000 in the bind list" messages, which also seem to be related to Unicode data.  
Windows Vista Support If you install Toad on Windows Vista with UAC (user access control) enabled, you may encounter file access errors Turn off UAC. If you don't have permission to do this, then when files are not found, such as lexlib.lxl, files may need to be renamed and/or moved to other locations. In the case of the lexlib.lxl error, you must copy this file from your local profile (where vista redirects your data) to your install directory \user files folder.
XML Editor The XML Editor has been tested successfully with the following combinations: -Oracle 9.2.0.4 database with 9.2.0.4 client -Oracle 9.2.0.5 database with 9.2.0.5 client -Oracle 10g database with Oracle 10g client -Oracle 10gR2 database with Oracle 10gR2 client Some errors in other configurations: With an Oracle 9.0.1 client and any server, XMLType columns will show up as "(ADT)" and be unreadable. With an Oracle 9.2.0.5 client and a 9.0.1 or 9.2.0.1 server, small XMLTypes seem to work, but trying to post an XML over 4000 bytes to a Unicode database yields "ORA-31011: XML parsing failed" even if the data is all English With an Oracle 9.2.0.1 client and a 9.2.0.4 server, attempting to post data causes "two-task conversion" errors or "ORA-31011: XML parsing failed" errors. With an Oracle 10g client and a 9.2.0.5 database, XMLType data shows in the editor as a long string of question marks. These errors seem to be a result of errors occurring at the Oracle client level, which we cannot control.  
XML Editor An extra newline gets added to the value for a mixed-content node when the XML is stored as XMLSchema. A mixed-content node is a node that has a value as well as subnodes. For example, this: &lt;node1&gt;value1&lt;subnode1/&gt;&lt;/node1&gt; Returns exactly the same when it is in a CLOB or in an XMLType stored as CLOB: &lt;node1&gt;value1&lt;subnode1/&gt;&lt;/node1&gt; But, when it is in an XMLType stored as XMLSchema, it returns from Oracle to TOAD like this: &lt;node1&gt;value1 &nbsp;&nbsp;&lt;subnode1/&gt; &lt;/node1&gt; As you can see, an extra newline appeared after value1. When TOAD posts altered data back to Oracle, that extra newline is posted along with the data (unless you manually eliminate it), and when TOAD then retrieves the data again, Oracle has added another newline: &lt;node1&gt;value1 &nbsp;&nbsp;&lt;subnode1/&gt; &lt;/node1&gt; If you wish to use TOAD's XML editor with mixed-content nodes in an XMLType stored as XMLSchema, then any code you use for parsing will need to be insensitive to newlines at the end of values.
XML Editor "ORA-31001: Invalid resource handle or path name "%s" when trying to post XMLType data that points to a document type definition stored in the XML repository. Even though an insert statement with the same data may work, there appear to be problems with posting these items from the XML editor. We do not really have a workaround for this. But note that XMLType data that uses a registered XMLSchema for validation seems to post successfully. Also, XMLType data with an inline document type definition also seems to post successfully.

Installation and Upgrade

Component Description
Command Line Execution As of Toad 9.1, some command line parameters have been desupported and changed to the standard convention, such as -c to connect, -min to minimize window, -max to maximize and -f to load files.
Desktops Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve old desktop layouts from previous versions of Toad. All previously saved desktop layouts for the main Toad desktop and the Procedure/SQL Editor desktops will be overwritten to the new default layouts. Once Toad is upgraded, users are advised to add customizations back if they wish.
Editor Key Mapping As of Toad version 9.5, all custom Editor key mappings will be reset to defaults. Any customizations made in this area will have to be manually re-applied after upgrade.
Editor Options Toad now uses a new Editor component, therefore not all pre-9.0 Editor options could be preserved on upgrade. The new "Auto Replace" and "Code Templates" options will recognize your pre-9.0 configurations and will not be lost when upgrading. As for the rest of the old "Editor options" (linked from Toad's main options screen in previous versions), they are now merged in with the other Toad options. The options in question will now revert back to the default settings as if you were re-installing Toad. For example, any custom Editor key mappings that were set for previous Toad versions will not be remembered when you upgrade. The key mappings will be set to match the defaults for Toad 8.6
Editor Toolbars Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve old SQL Editor and Procedure Editor toolbar layouts if upgrading from previous versions of Toad. Since the 2 Editors have been combined into a single Editor, there was no way for us to determine which toolbar to preserve. In addition, new toolbar items available in the single Editor would not be seen for upgrading users.
Editors Merge In Toad version 9.0, the SQL Editor, Procedure Editor, and Text Editor have been merged into a single Editor. The new Editor features context sensitive execution (F9 key or green arrow button). The new execution routine can identify the statement at your caret and perform the correct execution action when a single Editor tab contains heterogeneous statements. PL/SQL can also be compiled directly from the Editor's navigator panel via the Right-click menu. Script Execution is still available in the new editor as well as 3 debuggers (PL/SQL, JDWP, and Script). Only 1 debugger may be used at a time, use the "debug" main menu to switch between debuggers. "Execute Statement at cursor" is still available via Shift+F9, Ctrl+Enter, and the button may be added back to the toolbar using customizable toolbars. The new Editor now has 5 different "Tab Styles" that are used depending on what you are doing in the Editor. For example, if "XML" tab is selected, the tab will be in XML editor mode using the HTML parser and an XML tree will appear. Tab styles are also associated with a Desktop layout and file extensions.
Master/Detail Browser As of Toad 8.6, this window no longer remembers previously selected relationships or filter conditions. This behavior has been replaced with the Open/Save Relationship functionality.
Object Loading The Toad 8.6 option to include owner when extracting source from database has been changed. There are 3 choices now in Options > Editor > Open/Save > Object Loading options group. Always include, never include, and include when the owner of the object to load is not that of the connected schema. In 8.6, if USER1 loads an object owned by USER2 and the include schema option was unchecked then compiling would still compile that object in the USER2 schema. For 9.0 if the schema name is not present then compiling will always occur in the connected schema. The new options set is not mapped to the old "Include owner when extracting source from database" option and defaults to always include owner.
Options Due to the Editor merge and the introduction of a new Editor component, there has been some significant options re-work throughout Toad. For example, options previously found in the stand-alone "Editor Options" are now included with the rest of the Toad options. All of the old SQL Editor and Procedure Editor options have been moved and reorganized to be more intuitive with the single Editor. The best way to find the option you are looking for it to use the Options window's search function.
Parser and Syntax Highlighting in Editor Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve custom syntax highlighting, or any other parser customizations made to Toad's pre-9.0 parser files.
SQL Editor Script Options The Toad script options have been removed as of Toad 8.5. Toad now respects the SQL*Plus standard login.sql and glogin.sql. The Script options section in SQL Editor options will display this path when login.sql and/or glogin.sql are found. You can also open these files for editing from Toad's options window.
Script Execution and DBMS Output The script execution is an almost identical replacement for SQL*Plus so all script output will go to the script output tab in Toad 9.0. As with SQL*Plus, to see DBMS Output while running a script, a 'SET SERVEROUTPUT ON' command will have to appear at the beginning of your scripts. For frequent use of the server output command, we suggest adding this to your login.sql file.
Server Login Window As of Toad 8.5, The 'SQL*Net compatible Net8' and 'Force SQL*Net (ignore Net8)' options have been removed. These options are no longer necessary since the bugs that they were used as workarounds for have been fixed.
Team Coding If you plan to use Team Coding, we strongly recommend that you check Options > Editor > Execute/Compile > Toggle modified flag after compiling source loaded from database. The option defaults to checked in TOAD 7.5, but it is remembered from your previous installs, where it defaulted to unchecked. If the option is unchecked, then switching tabs or windows will disable check-in until you compile again.
Threaded Queries As of Toad 8.5, the SQL Editor options "Process statements in threads / allow queries to be cancelled", "Process Update, Insert, and Delete statements in background (threaded)" and "Process PL/SQL statements and DDL in background (threaded)" have been replaced with the new General option "Execute in threads (creates a new session for every active query). This new option provides true threaded query support. A "Query Viewer" window and new SQL Editor subtab have been added to supplement this new functionality. As of Toad 9.0, When using TQ, the "Commit" and "Rollback" buttons on Toad's main toolbar now only act on the current threaded session, instead of acting on all open threads for the current connection.
Toad Main Menu The Toad menus have been completely restructured for Toad 9.0. The new Session menu contains session-specific items such as creating and ending connections and anything else that can modify specific connections. The Database menu has been greatly expanded and generally contains all of the Oracle functionality, arranged by function. The new Utilities menu contains non-connection/Oracle windows for the most part, such as Network Utilities, Archive, and FTP. In the Files menu, you will now find items that operate on files only. The View menu toggles the visibility state of dockable windows along with a few other items that fit nicely in that category. The Search menu contains all search-related functionality from searching text to Oracle object search. The Edit and Grid menus have been left untouched. The "SQL Editor" menu has been renamed to "Editor" menu and the debug menu has not changed with the exception of removing items whose only function was to toggle the visibility of Editor sub-tabs.
Toolbars Toad's pre-packaged toolbar templates have been depreciated as of Toad 8.5. The toolbars will no longer be updated with this and all subsequent Toad releases. However, the toolbars will still appear in your custom toolbar list as read-write. The depreciated toolbar may still be used but will be missing new features.
eBiz Reports As of Toad 9.0, eBiz Reports, which used to reside in the "eBiz" menu have been moved to Database > Reports > Reports Manager

 


System Requirements

Before installing Toad for Oracle, ensure your system meets the following minimum hardware and software requirements:


Hardware


Software

 


Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: Updating multi-byte or bidirectional character data, exporting multi-byte character data to excel. Visual display in some grids/views.

 


For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad team and other community members. Join the Toad for Oracle community here.

Contacting Quest Software:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com

Refer to our Web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global Support Guide.pdf.

 


Release Statistics


Number of Bugs Fixed143
Number of Enhancements57
Number of Known Issues50

This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

 

2007 Quest Software, Inc. ALL RIGHTS RESERVED.

 

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

 

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
Email: legal@quest.com

Disclaimer

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.