Toad^® for Oracle

Version 11.0

Release Notes

September 30, 2011

Welcome to Toad for Oracle	New in This Release	Resolved Issues and Enhancements	Known Issues	Third Party Known Issues
Upgrade and Compatibility	System Requirements	Global Operations	Getting Started	For More Information

Welcome to Toad for Oracle

Toad for Oracle provides an efficient and accurate way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow and productivity. With Toad for Oracle you can:

Understand your database environment through visual representations
Meet deadlines easily through automation and smooth workflows
Perform essential development and administration tasks from a single tool
Deploy high-quality applications that meet user requirements and perform reliably in production
Validate database code to ensure the best-possible performance
Manage and share projects, templates, scripts, and more with ease

The Toad for Oracle solutions are built for you, by you. Over 10 years of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over one million, Toad for Oracle continues to be the standard tool for development and administration.

Toad for Oracle Editions

All commercial versions of Toad are bundled with additional Quest products, based upon the Edition that you purchased. For more information about the latest features in your Toad Edition and the bundled products, see the Toad Editions Release Notes.

New in This Release

Review the following sections for new features in this release.

All Toad Editions
Professional Edition and Higher
DB Admin Module, DBA Suite Edition, and DBA Suite RAC Edition
Idea Pond

All Toad Editions

General

The following features no longer require the DB Admin module, and are now available in the Base edition of Toad:
- Oracle Parameters window (Database | Administer | Oracle Parameters)
- Altering audit options in the Schema Browser
- Audit Objects window (Database | Administer | Audit Objects)
- Audit SQL/Sys Privs window (Database | Administer | Audit SQL/Sys Privs)
- Maintaining the following object types in the Schema Browser: Directories, Profiles, Resource Consumer Groups, Resource Plans, Roles, Rollback Segments, DBMS_Scheduler Objects, System Privileges, and Tablespaces
Toad now features a Rerun menu. It allows you to quickly re-execute windows that were recently executed via a Toad Action. Select More on the menu to see all available actions.
The Automation Designer has a new Rexec/SSH action. This allows you to execute a command on a remote server. It is available on the Utilities tab of the Automation Designer.
The Automation Designer has a new Create Variable action. You can create a local variable (temporary, only used for the execution of the app) or a global variable (permanent, saved in Toad Options and persists after execution). This action is available on the Control tab in the Automation Designer.

Editor

You can now perform basic calculations on grid cells, such as finding the sum or average of the selected cells. To use this feature, select adjacent cells in the grid and click in the grid toolbar (CTRL+N). The calculations display in a new row below the grid. Idea Pond #75.
You can now save your settings in the Find and Replace window as a reusable macro. To use this feature, click . See "Find and Replace Text" in the online help for more information. Idea Pond #133.

To quickly reuse a macro, click the arrow beside on the Edit toolbar and select it from the list.
You can easily execute a SQL statement embedded within PL/SQL. To use this feature, place the cursor in the statement and press SHIFT+F9. A new window displays with the extracted and reformatted SQL statement.
You can export your saved SQL and import it back into Toad. Toad exports your history, personal, and named SQL statements from SQL Recall. To use this feature, open the SQL Recall pane (F8), and click the Import or Export buttons on the SQL Recall toolbar.
The Editor now helps you complete parameters by inserting the parameter signature. It creates placeholders for the parameter values, which you can type over and use TAB/SHIFT+TAB to navigate between. You can also have Toad use a named notation (this option can be enabled on the Toad Options | Code Assistance page). Idea Pond #411.

Schema Browser

Schema drop-downs have been updated, and now it is easier to customize them by creating a list of favorites, hiding schemas, setting the default schema for connections, and other options. The changes apply to all windows with the schema drop-down, such as the Editor and Schema Browser. See "Customize Schema Browser Tabs" in the online help for more information. Idea Pond #32.
When you view a table's data in the Schema Browser, you can split the window to also show child or parent tables in a new detail grid. You can also change the query for the detail grid.

To use this feature, click the Show Detail Dataset button on the Data tab toolbar. If the table has a single foreign key, Toad automatically displays the related table. If there is more than one foreign key, click the arrow beside the View/Edit Detail Query button on the detail grid toolbar and select the table. Toad remembers your selection.
The History button has been replaced with forward and back buttons. History is still available as a drop-down on the new buttons. Items will now only be added to history when you stop on them for at least one second. Consequently, holding the up or down arrow key to browse no longer fills your history with items you browsed past.

Team Coding and Source Control

The source control setup process has been redesigned, and it is now much simpler to select a version control system (VCS) and set up Team Coding. To set up a VCS on its own, select View | Toad Options | Source Control. To set up Team Coding, select Utilities | Team Coding | Configure Team Coding. See "Set Up Team Coding" in the online help for more information.
The source control toolbars have been combined and simplified. Now, you can perform all of your source control tasks from one toolbar, regardless of whether you use just Team Coding, just a VCS, or both. To view the toolbar, right-click the menu area and select Team Coding.
Source control now has a Check in All Files button on the toolbar, which lets you check in all files or objects which you currently have checked out.
Code Control Groups have been replaced by Code Collections. Code Collections combine information in Code Control Groups and the Team Coding Mask in a single user view, thereby making it easier to set up groups for Team coding. See "Create Code Collections" in the online help for more information.
Team Coding roles have been simplified, and now there is only one role: TC_ADMIN_ROLE. This helps simplify setting up Team Coding. All other users in the database can automatically use Team Coding with restricted privileges. See "Team Coding Roles" in the online help for more information.
When a user with the TC_ADMIN_ROLE sets up a VCS, Toad stores the server settings as the default for all Team Coding users. This makes it much easier to set up Team Coding for a group of developers. (This feature only works with Microsoft Team Foundation Server, Perforce, and Subversion.)

Connections

You can now save database connection settings without connecting to the database. To use this feature, from the Database Login window click . See "Create New Connections" in the online help for more information. Idea Pond #234.
You can now easily edit saved database connection settings. To use this feature, select the connection in the Database Login window and click on the window toolbar. The Edit Login Window displays for you to quickly update the record.
You can now execute Toad Actions upon connection. To use this feature, open the Edit Login Record window and select Execute Action upon Connection. Then, select the action to execute and a parameter file for the action (optional). Idea Pond #217.
You can now test connections on the Database Login window. To use this feature, click the Test Connections button on the toolbar. Idea Pond #234.
You can now export your connections settings and import them back into Toad. This feature is especially helpful when you need to work on a different computer or share the settings with another person. If you save your connection password, it is encrypted in the exported file. To use this feature, open the Database Login window and click the Import or Export button. See "Import/Export Connection Settings" in the online help for more information. IdeaPond #82.
You can now mark connections as Read Only in the Database Login window, meaning that you cannot make any changes to the database. This option is especially helpful when you want to access data for a production database but you do not want to accidentally make any changes.
You now can rearrange the order of items in the Connection and Window bars. To use this feature, right-click the bar and select Connection/Window Bar Button Order. Then, use the arrows to determine the order for items to display. Toad remembers these settings. For example, if you list Editor first, then Editor windows always display in front of other windows (even if the Editor was opened last). Idea Pond #26.

Professional Edition and Higher

Code Analysis (formerly CodeXpert) is Toad's powerful code review and analysis tool. It helps you ensure that the performance, maintainability, and reliability of code meets and exceeds your company’s best practice standards.

Watch the Evaluating PL/SQL Code Quality with Code Analysis video on Quest's video channel.

Code Analysis has the following new features:

Code Analysis checks code in the Editor while you type. It underlines rule violations with a blue wavy line. You can hover over the line for a brief rule description.

To view a detailed description of the violation, right-click the blue line and select Code Analysis Violations | Explain Rule.
You can easily change the rule set used in the Editor from the Code Analysis toolbar.
Code Analysis is now a Toad Action. You can create the action from the DB Misc tab in the Automation Designer. See "Code Analysis Action" in the online help for more information.

Note: You can use an old CodeXpert ini file in a Code Analysis action. Alternately, if you run a CodeXpert ini file on the command line, Toad automatically converts it to a Code Analysis action.
The analysis engine has been completely rewritten, and now features:
- More thorough analysis
- Unicode support
- Comprehensive database support
- Faster analysis
The report in the Code Analysis window has been greatly enhanced. It is now a single, consolidated report and it includes more information. If you analyzed multiple items, you can include all of them in a single report by enabling the Display all selected results on Report tab option. The beginning of the report includes a table of contents, which is hyperlinked so you can easily navigate the report.
The Result tab in the Code Analysis window now includes a preview of the script. If you select a violation in the tree view, the preview on the right displays the corresponding code.

DB Admin Module, DBA Suite Edition, and DBA Suite RAC Edition

DB Health Check includes new categories and items for production databases and databases on a virtual machine.
Many DB Health Check items now have descriptions and usage suggestions in the Expl column. You can edit the description of any health check item and add your own notes.

Idea Pond

Idea Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.

The following Idea Pond submissions were implemented for this release:

Feature	Enhancement	Idea Pond ID
General	Add a Date field to Query Viewer.	60
	(Import Table Data) Ability to Automap source data to table columns for text files—You can match based on the first row of a text file that contains the column names.	98
	Save files as NO BOM format.	128
	Close all windows—Right-click the Window bar and selecting Close All Windows.	249
	Remove Toad Tips.	143
	Restore only the files that were not saved since their last edit.	162
	Windows Task Bar flashes when execution completes.	169
	Restrict Toad in production databases—Select the Read Only checkbox in the Database Login window.	172
	Preserve tab names on recovered documents.	208
	Added a 'Default spooler encoding' option on the General options page—You can now select ANSI or UTF-8.	284
	Use DBMS_STATS to gather statistics for Compare Schemas—Previously Toad used ANALYZE TABLE, but DBMS_STATS is the preferred way of gathering statistics.	375
Connections	Make tabs sortable in Window Bar and Connection Bar—To use this feature, right-click the bar and select Connection/Window Bar Button Order.	26
	Export and import connection settings—Open the Database Login window and click the Import or Export button.	82
	Provide an option to end all connections—Click the End Connection button and select all connections in the dialog.	199
	Support executing Actions on startup—To use this feature, open the Edit Login Record window and select Execute Action upon Connection.	217
	Test connections—From the Database Login window, click the Test Connections button on the toolbar. Save connection without connecting—From the Database Login window click the Add Login Record button.	234
Grid	Sort within memory—After all rows are fetched, you can right-click and select Memory Sorting.	19
Grid	Sum numbers when selecting multiple cells (like Excel)—You can now perform basic calculations on grid cells, such as finding the sum or average of the selected cells. To use this feature, select adjacent cells in the grid and press CTRL+N. The calculations display in a new row below the grid.	75
Editor	Highlight all instances of a variable—Selecting a whole word will highlight all instances of that word in the Editor.	18
	Show elapsed time of a statement during execution—A new panel was added to the status bar to display the execution time.	22
	Ability to execute SQL embedded within PL/SQL—SQL extraction allows you to execute SQL embedded within PL/SQL with minimal additional work. You can execute embedded SQL by placing the caret within SQL and using the "Execute Snippet" command (CTRL+Enter or Shift+F9) or you can select embedded SQL and use the "Execute Statement at Caret" command (F9).	29, 232, 244
	Bypass Toad's parsing to allow compilation—Toad will no longer block on syntax errors caused by the parser.	32
	No code completion in comments—Code Insight no longer displays when you are typing within a string or comment.	65, 92
	Automatically view results of SQL execution in Trace File Browser—Right-click in the editor and select SQL Trace \| Enabled - Retrieve Trace File After Execution. This feature requires the DB Admin module.	66
	More convenient word-wrap within Grid Popup Editor—New toolbar button added to grid popup Editor to toggle word-wrap. This affects only that editor and not the global Toad option to enable/disable word-wrap.	86
	Close tabs using middle-click.	97
	Ability to ignore substitution variables in comments—The option is accessible via the Editor right-click menu and on the View \| Options \| Execute/Compile options page. Select Ignore those in comments in the Substitution Variable Prompting field.	130
	Comma separate a list of text in Editor—You can use the Find and Replace window to do this, and now you can save your settings in the Find and Replace window as a reusable macro. See "Find and Replace Text" in the online help for more information.	133
	Only describe an object if you press CTRL before clicking on it.	327
	Display elapsed time and row/column on the same bar—A new panel was added to the status bar to display the execution time.	357
	Display length of selected text in Editor in the line/col panel of the status bar.	371
	Code completion on procedures fills in named parameters—The Editor now helps you complete parameters by inserting the parameter signature. It creates placeholders for the parameter values, which you can type over and use TAB/SHIFT+TAB to navigate between.	411
Schema Browser	Select favorite schemas—Schema drop-downs have been updated, and now it is easier to customize them by creating a list of favorites, hiding schemas, setting the default schema for connections, and other options. See "Customize Schema Browser Tabs" in the online help for more information.	36
	Back/Forward buttons in the Schema Browser History.	154
	Create insert statements—Feature already existed, but Toad 11 has enhanced features in Export Dataset: 1) exclude primary key columns, 2) exclude virtual columns, and 3) exclude columns by selecting them from a list.	156
	Better support for Edition Based Redefinition.	180
	Add a calendar view in the Schema Browser for Scheduler Jobs—New "Run Times" tab displays the scheduled run times for the Schedule or Scheduler Job.	266
	Describe window (F4) stay open after pressing ESC—Toad has a new option under Options \| Schema Browser \| Describe Dialogs to control describe windows being closed by ESC or not.	268
	DB Admin Tablespaces—Double-click on the tablespace to open the data files tab.	279
	Do not collapse the tree view after a refresh.	308
	Group Package variables and constants in the left-hand side.	354
	Show virtual column information in the Columns grid.	359
	Remove Datatype length option.	380
	Include Column IDs in grid header.	383

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad.

Feature	Resolved Issue	ID
General	If you have McAfee Antivirus installed, it no longer causes issues in Toad's user interface.	ST63963
General	An "Out of Memory" error no longer occurs when querying a table with a BFILE datatype column.	ST82661
General	Sending indexes to the Rebuild Multiple Objects window only loads indexes from all of the selected schemas.	ST85250
General	Toad Security now restricts FTP.	ST81974
General	A specific Toad Advisor warning now displays the correct metalink note.	ST78745
General	The Last Analyzed and Num Rows now work correctly in the Object Palette.	ST76293
General	Multiple Object Rebuild of indexes no longer goes in to a loop update.	ST80770
General	You can now retrieve Named SQL when only a single query is saved in Named SQL.	ST68428
General	Administer/Tablespaces now displays tablespace datafiles in 8i.	ST79920
General	A defunct grid menu was removed.	ST68237
General	Shortcut keys for chained rows now work correctly.	ST81213
General	Column settings are now saved in the control file of the SQL*Loader Wizard.	ST82065
General	The Window menu now includes the name of the SQL open in each Editor window.	ST78625
General	Tabs no longer move to bottom after docking/undocking elements such as Object Palette and Code Snippets.	ST56850
General	Toad Security: The accepted number of characters for the Feature column has been increased.	ST79724
General	You can now set menu animations to "None".	ST56541
General	In the Trace File Browser, a "not a valid integer value" error no longer occurs with certain kinds of trace files.	ST66456
General	Toad windows now stay on top when you switch between Toad and an external application.	ST75860
General	Toad Advisor no longer displays "untested version" for Oracle 11g R2.	ST78038
General	In the Filter Builder, an error no longer occurs when using the IN operator.	ST68770
General	The Buffer Cache Hit Ratio now calculates correctly in the AWR Browser.	ST79509
General	The StatsPack Browser Report no longer requires the Begin Snapshot ID.	ST81095
General	Server-side object generated scripts no longer have incomplete SQL statements.	ST81967
General	Corrected issues that caused "Out of memory" errors while working with large files.	ST56751
Code Analysis	Issues with editing Code Analysis rules have been fixed.	ST85860
Compare	Compare Schemas: The "skip when null" option is now preserved when creating a dimension.	ST83562
Compare	Compare Schemas: The sync script now includes the drop queue.	ST83561
Compare	Compare Schemas: Issues causing an ORA-01451 error in the sync script have been fixed.	ST83483
Compare	Compare Schema: The comparison is now accurate when you are only comparing constraints.	ST83648
Compare	Compare Schemas: Now displays grants for 'MERGE VIEW' privileges.	ST83443
Compare	Compare Schemas: The sync script now creates grant statements for directories.	ST81540
Compare	Compare Databases: Corrected a discrepancy in displaying passwords.	ST80921
Compare	Compare Single Objects: The sync script now prefixes the schema name to indexes.	ST80883
Compare	Compare Schemas: The sync script now correctly populates the schema for triggers.	ST80769
Compare	Compare Schemas: The sync script no longer automatically creates tables when creating a queue table.	ST83704
Compare	Compare Schemas/Databases: Constraints for VIEWs are now included in the sync script.	ST83520
Compare	Compare Databases: In the sync script, the create directory statement now comes before the grant directory privilege statement to a user.	ST80139
Compare	Compare Schemas: Java keywords are no longer set to uppercase in the sync script.	ST83557
Compare	Compare Schemas/Databases: When the clusters tables option is selected, clustered tables are now included in the sync script.	ST83792
Compare	Compare Schemas: The status for Global Partitioned Index is now picked up.	ST84295
Connections	Starting Toad via a batch file correctly recognizes environment variables for instant clients.	ST82747
Connections	Numeric database names are now displayed correctly in the Database drop-down.	ST81664
Connections	An issue when switching sessions on Connection Bar has been fixed.	ST79805
Connections	A "Password must be saved in login screen" error no longer occurs when using a connection override.	ST75501
Connections	The New Connection window now works correctly with comma-separated TNS alias entries.	ST79542
Connections	There is now an Import/Export feature in Toad for the current database connection passwords.	ST57188
Data Grid	Modifying data in a grid now retains values when clicking in other cells.	ST87581
Data Grid	An "Access violation in user32.dll" error no longer occurs when the data grid is set on the right.	ST58073
Database Browser	The Hit Rates and Event Waits graphs in the Database Browser Overview now populate correctly.	ST81281
Database Browser	The Buffer Cache hit ratio now displays the appropriate value.	ST81280
Database Browser	The "Created" timestamp now displays correctly.	ST79970
Database Browser	The Overview graph now displays correctly.	ST79721
DB Health Check	The Dictionary Cache Hit Ratio now displays correctly.	ST80980
Debug	$$plsql_unit and $$plsql_line no longer cause issues in the Debugger.	ST82405
Debug	'Where' values are no longer moved to the 'Value' column when using "Execute PL/SQL with Debugger".	ST82140
Debug	The Debugger can now be started when there are PL/SQL warning compilation messages.	ST56558
Editor	Formatting is now applied to code containing multi-line strings.	ST84214
Editor	The Editor now loads large SQL files faster.	ST82628
Editor	The format when printing Explain Plan has been corrected.	ST60227
Editor	An issue that caused users to receive an access violation error after loading a script has been resolved.	ST81777
Editor	The ORA-01036 error no longer displays when editing certain variable names.	ST81183
Editor	Toad's Editor now preserves changes made in the external editor.	ST80215
Editor	Using the Ctrl+Enter shortcut now executes correctly when comments are present.	ST79921
Editor	The Editor supports creating procedures using CTRL+ENTER (SHIFT+F9).	ST79891
Editor	The "Trim string data in char and nchar columns" option now works correctly.	ST79395
Editor	SET TRIMSPOOL is now supported.	ST79317
Editor	The EDIT command now works over multiple lines.	ST78624
Editor	The Find and Replace keyboard shortcuts now work correctly.	ST78365
Editor	The Editor supports editing queries while running (F9) with threaded queries on.	ST78453
Editor	Typing in the Current Schema drop-down no longer results in an ORA-01435 error.	ST78828
Editor	The ANSI join syntax is now correct when sent from the Editor to the Query Builder.	ST85297
Editor	An issue that caused "Field type should be CLOB, BLOB, or File" errors while running a statement have been corrected.	ST83276
Editor	Optimize Current SQL now executes substitution variables.	ST79460
Editor	Selecting the ROWID from a table with no rows no longer causes Toad to hang.	ST77771
Editor	Toad no longer hangs when opening certain kinds of package bodies.	ST75035
Editor	Tab shortcuts now work correctly.	ST74744
Editor	Clicking the hex button in the popup editor no longer causes access violations.	ST74703
Editor	Optimize Current SQL now works when there is a date variable at the caret.	ST74452
Editor	The Undo option is no longer disabled after saving a file.	ST55904 ST59834
Editor	The Code Assist window no longer obscures the Named SQL list.	ST73447
Editor	Typing with Named SQL (CTRL+N) now displays the options correctly.	ST68151
Editor	Packages with REF CURSOR now display data in the Results tab when executed in the Editor.	ST57445
Editor	Expanded nodes no longer collapse when switching between tabs.	ST56833
Editor	A PLS-00103 error no longer occurs when compiling scripts with Chinese characters.	ST57011
Editor	Making text upper case now highlights the save icon in the Editor.	ST60771
Editor	An error no longer occurs when selecting "fieldn" from dual (F5 and F9).	ST56777
Editor	The Editor no longer executes more than the selection when it includes multiple queries and a syntax error.	ST59850
Editor	Insert/OVR mode no longer stops working after copying and pasting and backspace.	ST58215
Editor	The "show parameters archive" command now returns results.	ST73590
Editor	The execution time now displays independently for each tab.	ST57232
ER Diagram	The "Show more" icon now displays when exporting to the clipboard/graphic file.	ST80350
ER Diagram	Foreign keys and indexes now display graphically.	ST78482
Import/Export	Import table data: The date now displays correctly with rc_seed.xls.	ST87630
Import/Export	If you import from an .xlsx or .xlsm file and the environment is set to Korean, the data imports correctly.	ST63195
Import/Export	The internal data generation engine now obeys NLS parameters.	ST84606
Import/Export	Importing fixed width or delimited text now correctly saves AM/PM.	ST84553
Import/Export	Export Dataset no longer puts the line feed in the wrong place for inserts.	ST83805
Import/Export	Export Dataset now creates a new worksheet when Excel is open and contains a macro.	ST83485
Import/Export	Export File Browser: Now exports correctly when a filter is applied.	ST82098
Import/Export	Import Table Data: Importing now successfully stops when the user clicks Cancel.	ST79467
Import/Export	Export Dataset: Column headers now display correctly after exporting the LONG RAW data type.	ST77880
Import/Export	Import Table Data: An "Out of Memory" error no longer occurs when the user selects "show data" on an empty table.	ST77927
Import/Export	A tag stack error no longer occurs when exporting a large number of rows to Excel 2007.	ST84601
Import/Export	Importing table data from Excel 2007 is now faster.	ST56577
Import/Export	Toad's performance when importing to table with many records has been improved.	ST56066 ST59858
Import/Export	Import Table Data: The preview and actual data import now match.	ST76369
Project Manager	The Project Manager now displays an error message when trying to overwrite a read-only file.	ST81368
Project Manager	The FTP Folder Items (Select Files) window now populates correctly.	ST79502
Project Manager	"External" connections now work in the Project Manager.	ST71370
Quest Script Runner	Running Quest Script Runner standalone no longer prompts for login when it has already been supplied.	ST84506
Quest Script Runner	Pasted text now displays in the correct location.	ST79749
Schema Browser	Nested procedures now display source in the right-hand side after two levels.	ST83240
Schema Browser	The cursor now moves to the end of a word after double clicking a column name in the Describe (F4) window.	ST56638
Schema Browser	You can now view objects belonging to that schema when connected as SYSDBA.	ST68630
Schema Browser	An error no longer occurs when describing (F4) on a materialized view Explain Plan.	ST78275
Schema Browser	An ORA-02221 error no longer occurs when altering a materialized view.	ST80922
Schema Browser	LOB index table column names now display in the Indexes tab.	ST83162
Schema Browser	Favorites: You can now add synonyms from the Object Search window.	ST83155
Schema Browser	Favorites: When adding from the Object Search window with Show Schema cleared, it now displays the folder name.	ST83112
Schema Browser	The "Set Tablespace names as defaults for all User Creates" option now works correctly.	ST82040
Schema Browser	The Refresh button is now enabled when "Auto Refresh" is selected.	ST80742
Schema Browser	An error no longer occurs when recreating a sequence and entering a value in the "Start With" field.	ST80577
Schema Browser	The Tablespaces \| Objects tab now displays the tablespace name after refreshing.	ST80276
Schema Browser	Synonyms now display in the tree view mode.	ST80340
Schema Browser	The Script tab and original query are no longer different when creating a job with DBMS_SCHEDULER.	ST79843
Schema Browser	Partition information now displays for an indexed organized partitioned table.	ST79535
Schema Browser	The "Next refresh" property is now generated when creating a materialized view.	ST78462
Schema Browser	The table rebuild script now includes parameters for compression and parallel.	ST78423
Schema Browser	An "Out of memory" error no longer occurs when viewing a script for ORDSYS.	ST78066
Schema Browser	Loading a package to one tab now includes the spec.	ST78411
Schema Browser	"Copy Data to Another Schema" now works when multiple tables are selected and one of them does not have data.	ST77505
Schema Browser	The Describe's filter window is no longer obscured when switching between apps.	ST74910
Schema Browser	The available actions on Users \| Role Grants have been clarified.	ST57584
Session Browser	Adding the client_version column no longer causes the session to disappear.	ST83168
Session Browser	Blocking locks now display in a RAC environment.	ST82249
Session Browser	The current statement now displays for Oracle Apps R12 databases.	ST81943
Session Browser	An ORA-01435 error no longer occurs when used with a shared schema.	ST81371
Session Browser	The login information now displays for Oracle Apps R12 databases.	ST81075
Session Browser	Sorting in VARCHAR2 columns has been improved.	ST78512
Team Coding	Errors experienced with Microsoft Team Foundation Server 2010 have been resolved.	ST82082
Team Coding	"Failed to initialize VCS provider" errors have been resolved.	ST80681
Team Coding	The "Automatic Check In" option now works correctly in the Editor.	ST83042

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature	Known Issue	Defect ID
General	Database Probe does not work with Oracle version 8.1.5. Workaround: Upgrade to supported Oracle version 8.1.7	N/A
General	Viewing nested data object types on a 10g database with the 8i client closes Toad. Workaround: Use a newer client.	ST59490
General	Toad's help cannot be opened from an installation path that contains Unicode characters.	ST72966
General	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. Toad currently does not differentiate between indexes created explicitly on the snapshot and indexes created automatically when the snapshot is created. Workaround: 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 recreate 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.	N/A
General	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. Workaround: Upgrade to Oracle version 8.1.7.2.0 or later, or see Oracle Metalink Note:124671.1 for details of how to fix the package.	N/A
General	If you use 11g Oracle ODP.NET client or any other client that does not have the oci.dll in the BIN directory, Toad has the following problems: Client shows as invalid Client version is not detected As a result of #2, columns of the following datatypes are not shown in the Schema Browser table data: CLOB, BLOB, NCLOB, XMLTYPE, TIMESTAMP, INTERVAL, BINARY_DOUBLE, and BINARY_FLOAT	N/A
General	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 Editor in this manner and select "yes" to the Spec/Body file split prompt, your file will be split into two Editor tabs. At this point, selecting an occurrence node in the output window will only highlight the appropriate line in the 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. Workaround: When loading a package into the procedure edit in this manner, select "no" to the Package spec/body split prompt.	N/A
Code Analysis	Saving results to a database: When dealing with nested procedures, CodeXpert can only insert run data from procs one level deep.	N/A
Code Analysis	Saving PL/SQL results to a database may fail or save invalid data to the database for invalid PL/SQL objects. Workaround: To ensure PL/SQL results are saved to the database correctly, verify the validity of all objects before running CodeXpert.	N/A
Connections	If you have a custom column and the newer version of Toad is introducing a new column to the Database Login window, your grid customizations will not be retained (such as column order and grouping). Custom columns are retained.	N/A
Connections	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.	N/A
Connections	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. Workaround: 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.	N/A
Data Grids	You may receive an "ORA-00902 invalid datatype" error when editing an object, nested table, or varray data if you have redefined the data type for that data during the current session. Workaround: 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.	N/A
Data Grids	An ORA-21525 error may display in the data grid while editing a record in a nested table.	ST69178
Data Grids	The data grid may hang while scrolling data on Windows 2000.	ST56628
Data Grids	Pasting multiple rows of text into a cell will only register the first row of the data. Workaround: Paste multiple rows of text into the text editor (popup editor) instead of into the grid cell.	N/A
Debugger	An error may display in the Debugger if you select the "Load into grid from memory (strong and weak)" option in the Set Parameters window.	ST55847
Editor	When file splitting is used in the Editor, Code Analysis does not automatically check the code in the Editor. Workaround: Click the "Analyze Code in Editor" button.	ST85604
Editor	Toad errors when you query on a field of Oracle collection types. Workaround: Execute using SQL*Plus.	ST64373
Editor	When spooling to an unpinned output window, the window becomes unresponsive and errors are given when Toad is closed ("Canvas does not allow drawing"). Workaround: Keep the output window pinned.	ST68523
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. Workarounds:* Select Display large numbers in scientific notation on the Options \| Data Grid \| Data page. Upgrade to Oracle client 8.1.6 or later.	N/A
Editor	If you select object tables with nested VARRAYs, the statement is busy and cannot be aborted.	ST62336
Editor	Toad Insight (Code Assist) is activated in comments, which may decrease Toad's performance.	ST64254
Editor	If you use a non fixed-width font, the results are misaligned in the of Script Output tab in Editor after executing a SQL script. Workaround: Go to Options \| Scripts and select a fixed-width font for script output.	ST62234
Editor	Pressing CTRL and clicking a type object in the Editor does not open the object's code.	ST55866
Import/Export	Exporting data grid cells of over approximately 800 bytes could cause "OLE error 800A03EC" for Microsoft Office 2003 when using the "XLS Instance" option. Workaround: Save using the "XLS file" option instead.	N/A
Import/Export	Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause.	ST59228
Schema Browser	Sometimes on Oracle 8.1.7 or higher, after pressing "Compile invalid objects", you may get ORA-20000, ORA-06512, or ORA-06512 errors. This could mean that you do not 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. Workaround: 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.	N/A
Schema Browser	Viewing XML_TYPE data in the F4 Describe Objects window may cause memory leaks. Workaround: 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.	N/A
Schema Browser	For data in tables, 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. Workaround: Use drag-and-drop in the grid to change the column order.	N/A
Session Browser	Session Browser does not work with Oracle version 8.1.5. Workaround: Upgrade to supported Oracle version 8.1.7 or later.	N/A
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.	N/A
Session Browser	In RAC databases, version 10.1.0.3 (and possibly other 10.1 versions), the query used to 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. Workaround: Clear the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary.	N/A
Team Coding	When using Microsoft Team Foundation Server, customers may receive an "Unable to get revision from VCS repository" error followed by "VCS archive is empty". This error generally occurs if customers use different workspaces when logged in to TFS. Workaround: See Quest Support Solution SOL74899.	ST90025
Team Coding	Team Coding is disabled for mixed-case object names.	N/A
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 ''Create a new revision for existing objects'' option when exporting.	N/A
Team Coding	With CVS, Toad may fail to retrieve the list of projects for you to select from in the CVS browser or in the Code Control Groups configuration. Workaround: See "Missing CVS\Entries File Error" in the online help.	N/A
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.	N/A
Team Coding	Team Coding and PVCS: 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. Workaround: 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.	N/A
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)	N/A
Unicode	The following features in Toad do not support Unicode: ASM Manager CodeXpert Export File Browser Hex Editor Toad Group Policy Manager In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser.	N/A
Unicode	Connections to Service Names with Unicode Characters are not supported.	N/A
Unicode	The Editor does not fully handle Unicode words, and as a result highlight object names, CTRL + Click, and mousing over watch hints may not work. Workaround: The fix is to change a regular expression in the PL/SQL language parser. New installations will not have this issue, but the language parser is not applied for upgrading users (so you do not lose any language parser customizations). If you are upgrading, you need to modify the PL/SQL language parser and add "?r)" (without quotes) to the beginning of the “Any name" parser rule’s expression if you want full Unicode object name support. For detailed instructions, please see the Unicode Troubleshooting topic in the Help file.	N/A
Unicode	Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names.	N/A
Unicode	XML (Plain) format creates bad XML if Unicode string values and Unicode column names are exported through Export Dataset.	N/A
Unicode	Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean).	ST63221
Unicode	In Team Coding, objects with Unicode contents are supported, objects with Unicode names are not. Supported Version Control Providers do not support Unicode names.	N/A
Virtualization	An access violation error may display when you close Toad in a Citrix XenApp environment.	ST76354

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this Toad for Oracle release.

Feature	Known Issue	Defect ID
EurekaLog	Does not support Unicode characters in exception logging folder.	ST62140
E-Control (Editor component)	Odd word-wrapping behavior in some languages. Word wrapping may appear between symbols, with no space required to wrap, and some characters cannot be word-wrapped at all (for example, multi-byte characters in ANSI text).	N/A
ODAC	ODAC does not support Unicode in XMLTYPE.	ST62654
Oracle	When the OCI is in Unicode mode, an error occurs when querying XMLTYPE data that uses binary storage. Toad uses the OCI in Unicode mode, and there is no way to disable this. You should be able to view XMLTYPE data without errors using CLOB storage and an Oracle client version of 10.2 or later.	N/A

Upgrade and Compatibility

Upgrades for Toad install side-by-side with any previous versions you have installed. You can run the new and previous versions concurrently. The first time you run the new version of Toad you are asked to migrate previous settings files.

Note: Toad supports importing settings only if the new version is within two releases of the previous version. If your versions are more than two releases apart, you need to install an intermediate version to successfully import the files.

Deprecated Features

The following features have been removed from the menus in Toad 11. They will be permanently removed after Toad 11.

View Extents and Free Space Deficits—These features were created for dictionary-managed tablespaces, which are rarely used since Oracle 8i introduced locally-managed tablespaces.
Server Statistics—This information is generally available in the Session Browser.
View Dependencies—This information is available in Code Road Map and the Schema Browser | Used By tab.
Control Files—This read-only window provides information that is infrequently used.
UNIX Kernel Parameters and Windows Registry Parameters—These features are out-of-date and beyond the scope of Toad to maintain.
Session Information—This information is available in the Schema Browser | Users tab.
Archive Window—The archiving ability is available as a Toad Action.
Network Utilities—The TNSPing feature is available on the Database Login window. The REXEC/SSH feature is available as a Toad Action.
New Database Wizard—This feature is rarely used. You can create a new database with Oracle's wizard.
JDWP (Java) Debugger—Oracle 11g uses just-in-time compiling, and by default there is no debugging information in the Java stored procedures. Most users do not have the privileges to enable the Java debugging information. In addition, Oracle recommends that Java stored procedures are debugged before storing them in the database.

System Requirements

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

Memory

512 MB RAM required, 1 GB recommended

Note: The memory required may vary based on the following:

Applications that are running on your system
Size and complexity of the database
Amount of database activity
Number of concurrent users accessing the database

Hard Disk Space

75 MB

Operating System

Windows Server 2003 (32-bit and 64-bit)

Windows XP (32-bit and 64-bit)

Windows Vista (32-bit and 64-bit)

Windows Server 2008 (32-bit and 64-bit)

Windows Server 2008 R2 (64-bit)

Windows 7 (32-bit and 64-bit)

Note: When running on a 64-bit operating system, you must use the 32-bit Oracle Client.

Database Client

Oracle Client 8.1.7.4

Oracle Client 9.2.0.8

Oracle Client or Instant Client 10.2.0.3/10.2.0.4

Oracle Client or Instant Client 11.2.0.1

Note: Only the 32-bit Oracle client is supported.

Database Server

Oracle 8.0.6; 8.1.7; 9i; 9i R2; 10g R1; 10g R2; 11g R1, 11g R2

Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

Cloud Database Service

Oracle databases running on Amazon EC2

Additional Software

Microsoft Internet Explorer 6.0 or later (to view the Release Notes)

Adobe Acrobat Reader 7.0 or later (to view the Installation Guide)

Virtualization Support

Before installing Toad, review the following for virtualization support:

Application Virtualization	Citrix XenApp 5.0 has been tested.
Desktop Virtualization (VDI)	Quest vWorkspace 7.0 has been tested.
Server Virtualization	VMware ESX Server 3.5 has been tested.
Note: Toad may work in virtualization environments other than the ones listed.

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 is Unicode-enabled and supports any character set. 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: Toad is a Unicode application. As such, it has native support for any Oracle Unicode character set, such as UTF8 or AL32UTF8. There are some features in Toad which use or invoke Oracle Utilities or applications which are not themselves Unicode applications. Their functionality is therefore limited to the character set of the client on which Toad is running, and NLS_LANG must be carefully set to match the Windows character set.

We have also observed issues with US7ASCII when used with non-Latin characters.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

Toad for Oracle 11.0

Note: Toad is available in different editions. The release package includes the edition that you purchased.
Product Documentation, including:
- Installation Guide
- Beginner's Guide to Using Toad
- Online Help
- Release Notes

Installation Instructions

Refer to the Toad for Oracle Installation Guide for installation instructions.

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 or visit ToadWorld for more information about Toad.

Contact Quest Software

info@quest.com

Mail

Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656

USA

Web site

www.quest.com

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

Retrieve thousands of solutions from our online Knowledgebase
Download the latest releases and service packs
Create, update and review Support cases

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

This guide is available in English only.

This guide 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.

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.

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

Refer to our Web site (www.quest.com) for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, Knowledge Xpert, Quest vWorkSpace, Spotlight, Toad, T.O.A.D., Toad World, and vToad are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see

http://www.quest.com/legal/trademark-information.aspx