Chat now with support
Chat mit Support

Toad for Oracle 16.0 - Release Notes

Resolved Issues

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

Toad for Oracle 16.0

The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.

Issue ID Link to Forum Post Resolved Issue
TOR-5740  

Editor: Unable to run unit tests created with Code Tester for Oracle


Schema Browser: Unable to view results of unit tests created with Code Tester for Oracle

TOR-5897  

Ping: Unable to use Ping tool when Toad's Internet access has been disable

TOR-5904 link

Export DDL: Trigger scripts omit DISABLE in some cases

TOR-5909  

Alter Job: ORA-01858 encountered when changing the next execution time when locale settings are set to Korean

TOR-5910  

Desktop: Dock panels set to auto-hide are not restored when restarting Toad

TOR-5917  

Dark Mode: Windows lack borders and shadows when connection colors are used

TOR-5920 link

Window Bar: Button order is incorrect when the Connection Bar option "Save positions" is enabled

TOR-5930 link

Schema Browser: The right side display when viewing a trigger is too small

TOR-5931 link

Dark Mode: Cursor output colors are not good

TOR-5944  

Administer Tablespaces: Access Violation occurs when refreshing the Objects tab quickly

TOR-5946 link

Log Miner: The final step in the wizard is missing its toolbar

TOR-5955  

Editor: Auto Replace may apply within strings and comments incorrectly when typing quickly

TOR-5958 link

Schema Browser: Out of Memory exception occurs when filtering synonyms to include both Private and Public

TOR-5962  

Editor: "Field not found" error occurs during execution with a cursor output variable in some cases

TOR-5967 link

Editor: Describe (F4) fails in the Navigator panel when the text is set to lowercase

TOR-5969  

Session Browser: Changing Current Statement subtabs cause a refresh when the "Refresh" option is unchecked

TOR-5972 link

Editor: Access Violation occurs when dragging files from Windows Explorer in some cases

TOR-5982  

Describe: Size and position are not remembered

TOR-6030 link

Editor: Applying Auto Debugger generates code that will not compile in some cases

TOR-6042  

Editor: Data Grid commits when it should not if the cached edits option is enabled (View | Options | Data Grids | Data)

TOR-6048 link

Alter Scheduler Job: Changes made to notifications are not committed

TOR-6049 link

Schema Browser: Caption changes made to scheduler object tabs are not remembered

TOR-6050 link

Schema Browser: Splitter between the left and right sides does not work when dark mode is in use

TOR-6052 link

Rebuild Table: Script excludes the backup table name when the source table name is longer than 30 characters

TOR-6053 link

Schema Browser: ORA-29275 is raised when selecting a scheduler job if data in the GLOBAL_UID column of DBA_SCHEDULER_JOBS is corrupt

TOR-6060 link

Explain Plan: Plan table is created in the login schema when selecting a schema other than TOAD or the login schema

TOR-6061  

Editor: The code section becomes inaccessible if the bottom splitter is positioned near the top and the Editor is resized smaller

TOR-6066 link

Alter Table: Cannot add a primary key constraint

TOR-6070 link

Editor: Save dialog uses .SQL extension instead of .sql

TOR-6076  

Compare Table Data: Error occurs when comparing external tables

TOR-6078  

Session Browser: Splitter position is lost after minimizing Toad when the form layout is oriented with the detail tabs at the bottom

TOR-6079  

Compare Multiple Tables: Unable to compare LOBs in different databases by LOB length

TOR-6080 link

Schema Browser: Quick filter does not allow selecting the only item in the dropdown

TOR-6082 link

Editor: Active tab text is lost when using the windows "pop out" feature

TOR-6083  

Schema Browser: Table columns tab does not allow adding a virtual column

TOR-6084 link

Data Grids: Popup Editor is slow to appear when using Dark Mode

TOR-6088 link

Schema Browser: Adding a constraint to the selected table causes the table to become deselected on the left side

TOR-6091 link

Data Grids: Save dialog in popup editor opens in the background

TOR-6097 link

Data Grids: Posting edits to CLOB data visualizes the data as corrupt despite it being sent to the database properly

TOR-6098  

Editor: Automatic backups of tab text do not stay up to date as the text is modified

TOR-6104 link

Explain Plan: Error image is used incorrectly for some plan steps

TOR-6108  

Schema Browser: Expanding indexes in multiple schemas leads to Access Violation when the browser style is set to treeview

TOR-6116 link

Editor: "Operation aborted" error message is shown in cases where an ORA-06503 is the error returned by the database

TOR-6123 link

Login: The Database dropdown of the TNS tab is slow to load if the tnsnames.ora file contains thousands of entries

TOR-6128 link

Schema Browser: ORA-00904 is raised when editing data using the Foreign Key lookup feature if the column name requires double quotes

TOR-6131  

Generate Database Script: Including two databases produces incorrect script output for the second database.

Toad for Oracle 15.1

The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.

Issue ID Link to Forum Post Resolved Issue
TOR-4841  

Export Dataset: Exporting a new sheet to an existing Excel File which contains a pivot table causes file corruption

TOR-5129/TMB-3814  

Editor: Toad is truncating data when opening a file with an embedded 'NUL' character.

TOR-5135/TMB-1613  

Editor: Query Builder removes the 'connect by' in a sql statement when trying to reverse engineer a hierarchy statement.

TOR-5258 link

Toad Options: The Toad Improvement Program cannot be disabled if the internet connection is restricted.

TOR-5316 link

Connections: Oracle client version 12.1.0.1 corrupts data received via output bind variables because Toad for Oracle does not support Oracle client 12.1.0.1.

TOR-5379 link

Editor: The nested table dialog does not display the first character of VARCHAR2 nested tables.

TOR-5449 link

Editor: Executing a query that includes a table with an XMLTYPE column results in ORA-00904.

TOR-5457 link

Automation Designer: Using a system variable name in a query iterator does not work when scheduled.

TOR-5536 link

Export DDL: Toad creating incorrect scripts from PL/SQL objects which exist in different versions in container and pluggable databases.

TOR-5599 link

Connections: In the toolbar, Reconnect and Reconnect All use the same icon and have no tooltip.

TOR-5620 link

Rebuild Table: Script includes "ALTER TABLESPACE {Tablespace Name} COALESCE;" command even if user does not have the alter tablespace privilege.

TOR-5623  

Connections: The Transactions window auto-refresh fails if a connection is lost and then recovered.

TOR-5645 link

Editor: When an error occurs executing a script Toad highlights the first line of the statement instead of the line where the error actually occurs.

TOR-5649 link

Explain Plan: ORA-00905 is raised when PUBLIC is specified as the plan table schema in Toad options

TOR-5667 link

DBMS Output: Looks enabled after ORA-04068 is raised when it is actually disabled.

TOR-5669 link

Schema Browser: ORA-00904 is raised when trying to browse the "Data" tab for SYS, TABLES, SYSTEM_PRIVILEGE_MAP.

TOR-5670 link

Editor: HTML is incorrectly displayed in the error message when ORA-2000 is raised.

TOR-5671 link

Editor: Variables are incorrectly flagged as unused when utilizing Refactor - Find Unused Variables.

TOR-5673 link

Editor: When using an ANSI JOIN clause Code Assist is not listing the packages that are available.

TOR-5674 link

Editor: Navigating between procedures in the package spec using the keyboard shortcut: Ctrl+Shift+Up/Down fails in some cases.

TOR-5675 link

Editor: Ctrl+Click does not always find variable declarations.

TOR-5680 link

Schema Browser: Tables with identity columns are not found in "Sequences -Used By" tab.

TOR-5682  

Data Grids: The keyboard short cut Ctrl+X does not cut.

TOR-5684  

Workspaces: When a window is minimized and the Workspace is then saved and re-loaded the window is no longer minimized.

TOR-5685 link

Unit Test: The right click menu for entries in the tree view of UTPLSQL Manager is prevented from displaying by a tooltip.

TOR-5686 link

Schema Browser: Hidden columns still display after they are unchecked via the "Scheduler Jobs - Run Log" tab.

TOR-5700  

Compare Data: In specific cases when comparing data, Toad incorrectly identifies rows as "source only" and "target only".

TOR-5701 link

Unit Test: If a database's decimal separator does not match Toad's, then UTPLSQL's execution time incorrectly displays as zero after the test is complete.

TOR-5710 link

Connections: TNSNames entries with leading spaces do not appear in the login window

TOR-5714  

Editor: The [F3] Shortcut for find is not highlighting the correct text if Greek letters are present.

TOR-5716  

General: When copying and pasting the clipboard fails in some cases.

TOR-5718  

Schema Browser: When logged into a database using Team Coding the refresh option is not visible in Materialized View.

TOR-5719 link

Connections: The login window does not always remember the last connection.

TOR-5722 link

Schema Browser: Execute Procedure returns "Invalid field size" error when "Scientific Notation" is unchecked.

TOR-5723 link

SGA Trace/Optimization: SGA/Trace is missing some fields in newer Oracle versions.

TOR-5725 link

Trace File Browser: The new trace file browser transfer mode (compress, transfer, decompress) sometimes fails.

TOR-5728 link

Compare Schemas: Views are showing differences in column size when they should be identical.

TOR-5730 link

Export Dataset: "Excel Instance" is not exporting strings as strings, which affects the exported data in some cases.

TOR-5731 link

Rebuild Multiple Objects: ORA-00900 is raised when rebuilding LOB Segments via "Load LOB Segments of Checked Tables".

TOR-5737  

Administer Tablespaces: Files tab incorrectly shows 0 free space for some datafiles.

TOR-5743  

Editor: Auto-replace only replaces whole words.

TOR-5752  

Editor: Large NUMBER bind variables are incorrectly converted to scientific notion.

TOR-5755 link

Datagrids: BLOB editor dialog has no "Clear" button.

TOR-5758  

Session Browser: Nothing happens when filtering parallel slaves.

TOR-5759  

Copy data to another schema: Number precision is lost if Scientific Notation is checked.

TOR-5760  

Session Browser: ORA-00029 is raised when clicking "​Cancel SQL for selected session" for parallel processes.

TOR-5761 link

Editor: Ctrl+PgUp/Down does not navigate correctly to package bodies.

TOR-5765 link

QSR: Q-quotes do not work in QSR.

TOR-5770 link

Import Table Data: Using expressions when importing table data fails in some cases.

TOR-5771  

Editor: The "replace" functionality in the "Find/Replace" dialog is case sensitive even if the case sensitive box is not checked.

TOR-5774  

Automation Designer: Multiple connections cannot be selected after using the "Change Connections" option.

TOR-5777  

Automation Designer: The Query Iterator forces its connection on child actions.

TOR-5782 link

Editor: Ctrl+D always launches Quick Describe from Editor even when Ctrl+D is configured for other shortcuts.

TOR-5800  

Schema Browser: Using a Foreign Key look up on large tables sometimes causes out of memory errors.

TOR-5804 link

Connections: Sometimes when an Oracle DB is connected the Connection Bar Icon shows it as disconnected.

TOR-5817 link

Schema Browser: Alter Table displays incorrect values for PCTFREE and PCTUSED in some cases.

TOR-5863 link

Editor: Toad Script Runner (TSR) throws an error when substitution variables are used.

TOR-5864 link

SQL Recall: The [F8] keyboard shortcut briefly displays the Right Hand Side Dock panels when opening the SQL Recall dialog.

TOR-5868  

Schema Browser: ORA-00904 is raised when accessing the Schema Browser Favorites "Data" tab after altering a view.

TOR-5871  

Export DDL: Toad produces an incorrect script when creating a table on 11gR2 in some cases.

TOR-5879 link

Connections: The Transaction window is not displayed correctly after being resized, closed and then re-opened.

Toad for Oracle 15.0

The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.

Issue ID Link to Forum Post Resolved Issue
TOR-1344 link

Editor: Caret position is not retained after formatting in some cases

TOR-5321  

Schema Browser: Identify columns cannot be modified in the data grid

TOR-5370  

Desktop: A floating dock panel returns to a docked state when it is closed and re-opened

TOR-5371  

Team Coding: PL/SQL objects that are already in VCS are re-added when compiled

TOR-5372  

Data Grids: Duplicating a row inserts the new row before the selected row which makes it appear as though nothing happened if the selected row is the last visible row in the grid

TOR-5373  

Team Coding: VCS client configuration options cannot be modified without the TC_ADMIN_ROLE

TOR-5377 link

Editor: Toad hangs when canceling a compile with debug operation if the object is in use and locked by another process

TOR-5384  

Schema Browser: Unable to toggle Object/Collection Type visibility when the browser style is set to "Treeview"

TOR-5385  

Editor: Clicking "Next" on the Replace dialog performs a replace instead of advancing to the next occurrence of the search term

TOR-5391  

Schema Browser: Statistics tab is blank for Queues having an object ID greater than 2147483648

TOR-5394  

Workspaces: Transactions window is not restored when loading a workspace

TOR-5409  

Debugger: When connected to a pluggable database in Oracle RAC using TNSNAMES connection the debug session incorrectly connects to the container database in some cases

TOR-5410  

Debugger: When connected to a pluggable database in Oracle RAC using direct connection the debug session fails to establish a connection

TOR-5411  

Connections: Selecting a closed connection from the Change Session button does not prompt for password if it has been changed since the connection was last used; also affects restoring workspaces having connections with new passwords

TOR-5414  

Data Grids: Posting a null value for a column with a NOT NULL constraint throws an error even if the column is populated by a BEFORE INSERT trigger

TOR-5416  

Database Health Check: Misleading Feature Usage results when run against a pluggable database

TOR-5417  

Create Table: Incorrect script may be generated after renaming a column

TOR-5418  

Data Grids: Modifying date values results in a date conversion error if the data grid "Date format" option is set to YDM

TOR-5420  

Import Table Data: File preview record numbering does not reflect the file line numbers when the "First Row" option is configured to something other than 1

TOR-5450 link

Schema Browser: Data filter name is cleared when adding new criteria to a saved filter

TOR-5451 link

Editor: Auto Replace does not take the "Additional Word Chars" option into account when looking for word boundaries

TOR-5453  

Editor: Find dialog does not move out of the way to reveal search matches

TOR-5454 link

Code Insight: Tables related through referential integrity are not shown when the SQL qualifies the table reference with the schema name

TOR-5456 link

Workspaces: Editor tabs are restored incorrectly when the "One/Connection" option is used for the Editor window

TOR-5459 link

Editor: ORA-00942 is encountered when executing SQL having leading tabs in some cases

TOR-5461 link

Master Detail Browser: Access Violation occurs when sorting a detail dataset

TOR-5463  

Editor: Auto Replace does not work when Tab key is pressed if the "Tab Mode" option is set to "Spaces" or "Smart"

TOR-5466  

Workspaces: DBMS Output polling options are not restored

TOR-5470  

Trace File Browser: Errors occur when loading trace files 2 GB or larger

TOR-5484 link

General: Slow load times in environments without internet access

TOR-5486  

Editor: Access Violation in module SciLexer.dll in some 64-bit installations

TOR-5489  

Schema Browser: Double clicking an object does not open the Alter window when the right side detail area is hidden and browser style is set to "Treeview"

TOR-5490  

Schema Browser: Unable to expand package spec/body to view package members when the right side detail area is hidden

TOR-5491  

Schema Browser: Double clicking a package to load it in the Editor does not obey the "Load spec/body as a pair" option

TOR-5493  

Editor: Clicking the Save button will prompt to export the Data Grid contents if the Data Grid has focus

TOR-5495  

Data Grids: Records do not scroll at the same rate as mouse wheel rotation when scrolling quickly

TOR-5496  

Team Coding: Double clicking a Package or Type spec/body does not load both the spec and body in the Editor

TOR-5497  

Rebuild Table: ORA-32795 is raised when rebuilding a table having an IDENTITY column

TOR-5498  

Schema Browser: When Browser Style is set to "Treeview" the tree does not scroll at the same rate as mouse wheel rotation when scrolling quickly

TOR-5499  

Compare Data: Differences report incorrectly identifies the source and target tables when the two tables have a primary key column of the same name

TOR-5502  

Document Recovery: Some Editor shortcuts are mapped incorrectly after recovering a document

TOR-5503  

Workspaces: Access Violation occurs when restoring a workspace that has the Schema Browser opened and navigated to the Favorites tab

TOR-5504  

Alter Tablespace: Numeric conversion error occurs when using a decimal value for Size and/or Next Extent fields


Alter Tablespace: Max Size field does not accept decimal values and instead removes the decimal separator, e.g. 1.5 becomes 15

TOR-5507  

Login: Add/Edit Login Record dialog is missing Protocol and Instance Name fields when configuring a direct connection

TOR-5508 link

Code Insight: The query that searches for referential integrity relationships is not optimal and takes a long time to execute in some environments

TOR-5511  

Schema Browser: Package navigation does not work properly when the "Default EOL Mode" option for files is set to "Unix (LF)" line endings

TOR-5516  

Workspaces: Restoring workspaces saved in older versions of Toad may create more connections than it should

TOR-5518 link

Editor: Bookmark positions are lost or moved after formatting code

TOR-5520  

Editor: Auto Replace options exclude the pipe character as an activation char, but since it's part of the concatenation operator it should be present by default

TOR-5526  

AWR Browser: Date conversion error occurs in some locales

TOR-5527  

Connections: A race condition when closing a connection results in an Access Violation

TOR-5529  

Team Coding: DDL operations against an uncontrolled object are blocked and an error message is shown if the object was previously controlled

TOR-5539  

Workspaces: File modifications that are not saved to disk are not retained as part of the workspace


Workspaces: Files that have been deleted from disk since saving a workspace are not restored; the contents of the file as it was when the workspace was saved should be restored and the tab caption updated to indicate that the file has been deleted

TOR-5541 link

Automation Designer: The Connection Iterator action loops over each connection, one nested action at a time; it should be running each nested action against the current connection before advancing to the next connection like a traditional loop construct

TOR-5588  

Schema Browser: A race condition when invoking a drop, canceling the query, and closing the window may result in an Access Violation

TOR-5592 link

Schema Browser: Switching between saved filters on the Data tab does not reflect the active filter properly in the status bar

TOR-5595 link

Tablespaces: Viewing datafiles results in an ORA-00904 error when connected to a multitenant container database if the "Include Pluggable Databases" option is checked

TOR-5596  

Session Browser: Activating an inactive, unmaximized Session Browser window by clicking on its title bar does not change the active connection to be that of the window in some cases

TOR-5597  

Schema Browser: ORA-01460 occurs if the "Enable value lookup for foreign key constraints" option is checked when browsing data on databases using a non-Unicode character set

TOR-5609  

Trace File Browser: Some large trace files suffer from an unnecessary performance hit

TOR-5614  

Editor: Unable to retrieve trace file after execution

TOR-5635  

AWR Reports: ORA-01406 occurs in some cases

Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist in this release line at the time of the current release.

General known issues

Known Issue Issue ID
Toad's help cannot be opened from an installation path that contains Unicode characters. 72966

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

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:

  1. Client shows as invalid
  2. Client version is not detected
  3. 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

Debugger

If there is an exception during debugging on a 10Gr2 or greater database, REFCURSOR output and DBMS output will not be available when debugging is completed. This is due to the target session not being available.

Workaround: To see REFCURSOR output and DBMS output, execute the procedure without the debugger.

N/A

Connections

While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly, such as Toad Script Runner (TSR).

N/A

Schema Browser

Sometimes 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

Virtualization

An access violation error may display when you close Toad in a Citrix XenApp environment.

76354

Import/Export

Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause.

59228

Data Modeler:

  • Generation of HTML reports of large diagrams may fail during generation of an image of the ER Diagram.
  • Comparison of large models may consume too much memory.
N/A

Oracle client known issues

Known Issue Issue ID

In some cases, connecting to an 11g database using a 19c or 21c client may result in a hang when cancelling a query or when using Code Insight.

Workaround: Use an 18c or older client when connecting to an affected database.

N/A

All versions of Oracle client 19c leak memory when working with LOB types. This includes simple SELECT statements against a table containing LOB types.

N/A

Proxy server known issues

Known Issue Issue ID

Toad does not support Proxy Automatic Configuration (PAC) scripts; however, Toad does allow you to specify Quest-specific proxy settings to work around this limitation. By default Toad will use non-PAC proxy settings configured within Windows automatically.


Apply settings system-wide:


HKEY_LOCAL_MACHINE\Software\Quest Software\Internet Settings:

  • ProxyEnable (DWORD): 1 = enable proxy override at this level, 0 = don't enable proxy override at this level
  • ProxyServer (string): semicolon-delimited "<protocol>=<server>:<port>" entries
    • For a shared proxy server across multiple protocols:
      • a single "<server>:<port>" entry is all that's needed (ex: "127.0.0.1:8888")
    • For individual proxy servers by protocol, specify multiple entries:
      • ex: "https=127.0.0.1:8888;http=127.0.0.1:8080;ftp=127.0.0.1:6300"

For 32-bit applications on a 64-bit machine:

  • Key: HKEY_LOCAL_MACHINE\Software\WOW6432Node\Quest Software\Internet Settings:

Apply settings to your own account:


HKEY_CURRENT_USER\Software\Quest Software\Internet Settings:

  • Same keys as above

Notes for use:

  1. Override proxy settings will only be included if the corresponding ProxyEnable value is set to "1". Otherwise, it's ignored.
  2. HKLM (system-wide) server settings will override Windows settings.
  3. HKCU (local) server settings will override HKLM and Windows settings.
  4. Users can also edit both the system proxy settings (existing in Toad 14.0) and now their user-specific proxy settings (from HKCU) within Toad's Proxy Settings dialog (View | Options | Online); however, system-wide settings (from HKLM) will not be editable inside of Toad since they're more for administrators in silent installs or system-wide configs.
72966

Data Grids known issues

Known Issue Issue ID

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

Full table data is not displaying in the live data grid (results from F9) if the data contains "zero" characers (ACII 0). In this case, all data after the zero character will not show in the grid.

Workaround: Double click on the data cell in the data grid to view full contents of data in a popup editor.

 

Code Analysis known issues

Known Issue Issue ID
Saving results to a database: When dealing with nested procedures, Code Analysis 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 Code Analysis.

N/A

Editor known issues

Known Issue Issue ID

Toad errors when you query on a field of Oracle collection types.

Workaround: Execute using SQL*Plus.

64373

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.

68523

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.

62234

Session Browser known issues

Known Issue Issue ID
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.

N/A

Team Coding known issues

Known Issue Issue ID

Creating a new revision or attempting to force a check-in to Visual Studio Team Services may result in a "404: Not Found" error. The current version of Team Foundation Server used by Visual Studio Team Services compares the source being uploaded with the source already in the repository. If the source has not changed, it may incorrectly return an error rather than allowing the forced revision. This appears to be a Microsoft issue. As a result, these two commands may fail.

N/A

When using the Team Foundation Server internal client and Team Foundation Server 2012 or 2013 alternate Team Project Collections, workspaces created outside of Toad are not visible from within Toad. A workspace may be created from Toad by clicking the ‘New’ button during the Team Foundation Server log in.

This is not an issue when using the Team Foundation Server external client.

114334
Team Coding is disabled for mixed-case object names. N/A

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 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 known issues

Known Issue Issue ID

The following features in Toad do not support Unicode:

  • ASM Manager
  • Export File Browser
  • Hex Editor

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

Editor options to highlight object names may not work for object names that contain Unicode characters.

N/A
Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names. N/A
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).

63221
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

The OCI option ORA_NCHAR_LITERAL_REPLACE affects the NCHAR String Literal Replacement behavior when connected to non-Unicode databases. The option can be enabled or disabled. See the "Enable ORA_NCHAR_LITERAL_REPLACE" option (View | Options | Oracle | General). The option has adverse behavior regardless of its value.

  • Enabled - ORA-01756 error when executing SQL using the Q-quote operator where the end delimiter appears within the string literal and is followed by a single quote that is also part of the string literal. The single quote does not have to immediately follow the delimiter.
  • Disabled - NCHAR string literal corruption when connected to non-Unicode database.

N/A

High DPI known issues

Known Issue Issue ID

Toolbars

(Affects Windows Server 2019 only)

Toolbar button images may disappear when you mouse over them if the "High DPI scaling override" option is set to "System (Enhanced)" in the Windows file properties dialog for Toad.exe

N/A

Third-party known issues

Known Issue Issue ID

Help

(Affects the 64-bit version of Toad only)

If IE9 is installed, clicking a link in the Help file may crash Toad 64-bit, even if IE9 is not the default browser.

Workaround: Users who have IE9 installed can open Help from outside of Toad.

N/A

System Requirements

This section contains the hardware, software, and privileges required to run Toad for Oracle, as well as the database and virtual environments that Toad for Oracle supports.

Hardware requirements

Requirement

Details

Processor

1 GHz processor

Memory

  • 1 GB RAM - Toad for Oracle 32 bit
  • 2 GB RAM - Toad for Oracle 64 bit

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

  • 120 MB - Toad for Oracle 32 bit
  • 150 MB - Toad for Oracle 64 bit

Operating system

  • Windows 8.1
  • Windows 10
  • Windows 11
  • Windows Server 2012 R2 - 2 CPU required
  • Windows Server 2016
  • Windows Server 2019
  • Windows Server 2022

Database requirements

Requirement

Details

Database client

An Oracle client must be installed and configured on the system where you are running Toad. The following are supported:

  • Oracle Client or Instant Client 10.2.0.5
  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3
  • Oracle Client or Instant Client 12c Release 1 and 2
  • Oracle Client or Instant Client 18c
  • Oracle Client or Instant Client 19c
  • Oracle Client or Instant Client 21c

Note: You must use the 32-bit version of Toad with the 32-bit Oracle client, and the 64-bit version of Toad with the 64-bit Oracle client.

Database server

Oracle versions:

  • 10g Release 2
  • 11g Release 1 and 2
  • 12c Release 1 and 2
  • 18c
  • 19c
  • 21c

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 Database as a Service on Amazon EC2 and Oracle Cloud

Network

  • Internet Protocol Version 6 (IPv6) is being adopted by the US Federal Government and industries around the world. In its most basic format, the new protocol uses 128-bit addresses instead of 32-bit addresses, which are used by the current IPv4 to route packets over the Internet. Toad for Oracle features, such as FTP, access the Internet through third-party vendors that are IPv6 compliant, such as /nSoftware's IP*Works. For access to Web sites by way of the Toad Online window, Toad simply invokes the user-defined or default Web browser.
  • Toad for Oracle Subscription editions require the user to sign in when using the product. This enables the product to verify the user's identity and to check that they are entitled to use the subscription. To complete this entitlement check internet access is required to connect to Quest Software's Licensing Servers.

  • Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Quest Auto Update requires internet access and must be able to reach the cloud service at https://autoupdate.toadworld.com.

Additional requirements

Requirement

Details

Additional Software

  • Microsoft Internet Explorer 6.0 or later (to view video from the Jump list within Toad, and to view the product documentation in HTML format).
  • Microsoft Office 2016 and recent earlier releases are supported for Word and Excel output.
  • Adobe Acrobat Reader 7.0 or later (to view the product documentation in PDF format).
  • Microsoft .NET Framework 4.0 to support the Toad for Oracle Editions Installer.

Virtualization support

Type

Details

Application virtualization

Citrix® XenApp

Desktop virtualization (VDI)

vWorkspace™ 7.0 has been tested.

Server virtualization

Oracle VM 3.1 has been tested.

VMware ESX Server 3.5, 4.0, and 5.5 have been tested.

Note: Toad may work in virtualization environments other than the ones listed.

Windows Privileges

In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.

Operating System

Requirements

Windows 8.1 and 10

Windows Server 2012 R2, 2016, 2019, and 2022

  • Read access to the Oracle client folder
  • Read/write privileges on the Oracle Home directories that you use for your connections

Note: Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Installation requires administrator privileges on all supported operating systems.

Note: Other functionality in Toad may require additional privileges.

Product Licensing

Legacy Toad for Oracle with offline license keys

To activate a trial

  1. Go to the trial download web page: https://www.quest.com/products/toad-for-oracle/software-downloads.aspx, accessed through the product page.
  2. Select the Toad for Oracle Edition that you want to try.
  3. Log in to your account or register.
  4. Accept the license terms.
  5. Download the trial file.

To activate a purchased commercial license

  1. Go to the Quest Support website: https://support.quest.com/
  2. Type the name of the product that you want to activate in the Enter your product to find support field.
  3. Select Download New Releases.
  4. Download the installer file.

Notes:

  • License keys compatible with Toad for Oracle 9.7 and earlier versions are no longer supported.
  • Only the newer 48-character license keys are supported.
  • If you have an older license type, the Editions installer points you to the license web page where you can update it.
  • Toad supports cumulative licensing. You can add multiple licenses, including those for add-ons like Sensitive Data Protection, to Toad. Toad will use the licenses providing the highest degree of features.

Toad for Oracle Subscription with online licensing (including Editions)

Toad for Oracle Subscription requires you to sign in with your Quest.com account. Licenses are tied to your account giving you the flexibility to use Toad from multiple computers without having to move your license.

Sign in with existing Quest.com account

  1. Enter your account email address and password when prompted
  2. If you already have a Toad for Oracle Subscription license, no further action is needed
  3. If you do not have a Toad for Oracle Subscription license, see Activating a new license below

Create a new Quest.com account

  1. Select Sign up for a new account
  2. Enter your account details and select Sign Up
  3. A confirmation email is sent containing a verification code
  4. Enter the code from the email and select Verify

    NOTES:

    • It may take a few minutes for the verification email to arrive

    • Check your spam/junk folders for the email sent from supportadmin@quest.com if you do not receive it

    • For additional assistance, please contact Quest support

Activating a new license

  1. Toad for Oracle Subscription automatically provides a fully functioning, 30-day Trial license
  2. To purchase a new license, click Buy Now from Toad's title bar
  3. After completing your transaction, restart Toad and your license is automatically detected
  4. To manage licenses, select Account Settings beneath your account shown at the top-right of Toad

    NOTE: You can view your licenses from within Toad by selecting Help | Licensing

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen