Toad® for Oracle
September 30, 2011
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:
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.
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.
Review the following sections for new features in this release.
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 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.
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 . 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 .
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.
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 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.
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.
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.
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.
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.)
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 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.
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.
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.
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 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 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 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.
|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.
|Grid||Sort within memory—After all rows are fetched, you can right-click and select Memory Sorting.||19|
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.
|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.
|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.
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.
|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|
The following is a list of issues addressed and enhancements implemented in this release of Toad.
If you have McAfee Antivirus installed, it no longer causes issues in Toad's user interface.
|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|
The Window menu now includes the name of the SQL open in each Editor window.
|General||Tabs no longer move to bottom after docking/undocking elements such as Object Palette and Code Snippets.||ST56850|
Toad Security: The accepted number of characters for the Feature column has been increased.
|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|
Issues with editing Code Analysis rules have been fixed.
|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 Databases: In the sync script, the create directory statement now comes before the grant directory privilege statement to a user.
|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|
An issue that caused users to receive an access violation error after loading a script has been resolved.
|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.||
|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|
The Editor no longer executes more than the selection when it includes multiple queries and a syntax error.
|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.||
|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|
An error no longer occurs when describing (F4) on a materialized view Explain Plan.
|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|
An error no longer occurs when recreating a sequence and entering a value in the "Start With" field.
|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|
The Script tab and original query are no longer different when creating a job with DBMS_SCHEDULER.
|Schema Browser||Partition information now displays for an indexed organized partitioned table.||ST79535|
The "Next refresh" property is now generated when creating a materialized view.
|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|
The login information now displays for Oracle Apps R12 databases.
|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|
The following is a list of issues known to exist at the time of this release.
Database Probe does not work with Oracle version 8.1.5.
Workaround: Upgrade to supported Oracle version 8.1.7
Viewing nested data object types on a 10g database with the 8i client closes Toad.
Workaround: Use a newer client.
|General||Toad's help cannot be opened from an installation path that contains Unicode characters.||ST72966|
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.
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 220.127.116.11.0 and 18.104.22.168.0.
Workaround: Upgrade to Oracle version 22.214.171.124.0 or later, or see Oracle Metalink Note:124671.1 for details of how to fix the package.
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:
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.
|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|
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.
|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|
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 126.96.36.199 and Oracle 188.8.131.52 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.
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.
|Data Grids||An ORA-21525 error may display in the data grid while editing a record in a nested table.||ST69178|
The data grid may hang while scrolling data on Windows 2000.
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.
|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|
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.
Toad errors when you query on a field of Oracle collection types.
Workaround: Execute using SQL*Plus.
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.
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.
|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|
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.
|Editor||Pressing CTRL and clicking a type object in the Editor does not open the object's code.||ST55866|
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.
|Import/Export||Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause.||ST59228|
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.
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.
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.
Session Browser does not work with Oracle version 8.1.5.
Workaround: Upgrade to supported Oracle version 8.1.7 or later.
|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|
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.
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.
|Team Coding||Team Coding is disabled for mixed-case object names.||N/A|
Team Coding and SourceSafe:
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.
|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 and PVCS:
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.
|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|
The following features in Toad do not support Unicode:
In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser.
|Unicode||Connections to Service Names with Unicode Characters are not supported.||N/A|
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.
|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|
Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean).
|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|
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 does not support Unicode in XMLTYPE.
|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|
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.
The following features have been removed from the menus in Toad 11. They will be permanently removed after Toad 11.
Before installing Toad, ensure your system meets the following minimum hardware and software requirements:
512 MB RAM required, 1 GB recommended
Note: The memory required may vary based on the following:
|Hard Disk Space||
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.
Oracle Client 184.108.40.206
Oracle Client 220.127.116.11
Oracle Client or Instant Client 10.2.0.3/10.2.0.4
Oracle Client or Instant Client 18.104.22.168
Note: Only the 32-bit Oracle client is supported.
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
Microsoft Internet Explorer 6.0 or later (to view the Release Notes)
Adobe Acrobat Reader 7.0 or later (to view the Installation Guide)
Before installing Toad, review the following for virtualization support:
Citrix XenApp 5.0 has been tested.
|Desktop Virtualization (VDI)||
Quest vWorkspace 7.0 has been tested.
VMware ESX Server 3.5 has been tested.
Note: Toad may work in virtualization environments other than the ones listed.
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.
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.
Refer to the Toad for Oracle Installation Guide for installation instructions.
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.
Quest Software, Inc.
5 Polaris Way
Aliso Viejo, CA 92656
See our web site for regional and international office information.
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:
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.
© 2011 Quest Software, Inc.
ALL RIGHTS RESERVED.
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
5 Polaris Way
Aliso Viejo, CA 92656
Refer to our Web site (www.quest.com) for regional and international office information.
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 seehttp://www.quest.com/legal/trademark-information.aspx