The following is a list of issues addressed and enhancements implemented in this release of Toad for Oracle.
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-5157 | link |
Display Scaling: Tooltips/hints shown in the wrong location in a multiple monitor environment with differing resolutions. |
TOR-7140 | link |
Workspaces: When auto-loading a workspace fails, the workspace is saved in its partially loaded state. |
TOR-8203 | link |
Compare Databases: Profile differences are shown incorrectly. |
TOR-8530 | link |
Connections: "Net: error 99" error is shown is a TYPE is modified in between uses within a SELECT. |
TOR-8625 | link |
Workspaces: Editor tab shows that a file is both deleted and modified if it was temporarily unavailable when the workspace was loaded. |
TOR-8633 | link |
Single Record Viewer: Fields are not wide enough to show TIMESTAMP data. |
TOR-8665 |
Compare Files: When a comparison is shown as a result of a Compare Schemas the Run button's hint is "Reload and recompare files" which is misleading. | |
TOR-8667 | link |
New Version Dialog: A date/time conversion error is shown in the new version dialog when a new version of Toad has been released. |
TOR-8678 | link |
Editor: An Access Violation occurs when changing the active session in some cases. |
TOR-8693 | link |
Editor: An Access Violation occurs when opening the Editor when the desktop layout has been customized. |
TOR-8694 | link |
Connections: If a connection fails, Toad attempts to open an HTML document in your default text editor. |
TOR-8703 | link |
Object Palette: The columns panel does not remember its height between showings. |
TOR-8741 | link |
Connections: The Window Bar does not group connections correctly when multiple connections are made to the same user@db. |
TOR-8744 | link |
Instance Manager: Ping fails when a TNS entry uses 'localhost', and the database test does not continue after the ping fails. |
TOR-8746 | link |
Team Coding: The lock status may be incorrect if Toad was previously closed while objects were still checked out. |
TOR-8747 |
Workspaces: Workspaces fail to load with a "data error" in some environments, e.g. Chinese. | |
TOR-8850 |
Team Coding: An object can be dropped even when Team Coding is configured for Git and the user is not logged in. | |
TOR-8857 |
Connections: A "cannot open file" error occurs in clientless connection mode when WALLET_LOCATION is set to a path enclosed in double quotes. | |
TOR-8875 | link |
Editor: The Find Unused Variables feature incorrectly flags used variables in TRIGGER DDL statements. |
TOR-8882 | link |
Team Coding: Differences cannot be merged if the local package spec file contains a synonym statement. |
TOR-8889 |
Compare Schemas: The "Convert datatypes with DBMS_REDEFINITION" option does not work unless "Add/Reorder columns with DBMS_REDEFINTION" option is also used. | |
TOR-8892 |
Scripts: Toad generates an incorrect script for XML indexes. | |
TOR-8893 |
Compare Schemas: Toad generates an incorrect sync script for XML indexes. | |
TOR-8895 |
Schema Browser: The "Configure" option is missing from the object type right-click menu when all but one type are set to hidden. | |
TOR-8898 | link |
Schema Browser: Scheduled run times for scheduler jobs are sorted as strings instead of as dates. |
TOR-8904 | link |
Generate Schema Script: It's not possible to export a subset of constraint types; all constraints must be selected to generate the script. |
TOR-8931 | link |
Script Execution: Newlines in the script output differ from those produced by SQL*Plus in some cases. |
TOR-8932 | link |
Data Grids: If the connection is made in clientless mode, Access Violations occur when entering numeric data that uses a format different from the one configured in Toad Options. |
TOR-8968 | link |
macOS: Access Violation occurs when viewing formatter options in Toad Options, preventing any changes to the settings. |
TOR-9002 | link |
Editor: When the "Set modified flag off after compiling from database" option is enabled, edits made after compiling PL/SQL with errors do not update the tab caption to indicate the text is modified. |
TOR-9039 | link |
DBMS Output: An ORA-03120 error is raised when fetching output in some cases. |
TOR-9113 | link |
Alter Datafile: When setting the size using a decimal value (e.g., 1.5 GB), Toad briefly displays the incorrect unit (e.g., 1.5 MB) after clicking OK. |
TOR-9119 | link |
Team Coding: Reverting a checked-out table to its VCS version silently drops and recreates the table, resulting in unexpected data loss, without warning. |
TOR-9124 | link |
Automation Designer: The Connection Iterator action passes the connection only to its immediate child actions; deeper nested actions use the first connection instead. |
TOR-9125 |
macOS: On first run, a "Cannot update client files" error, and possibly others, may appear in certain cases. | |
TOR-9131 | link |
Connections: An Access Violation occurs when a connection fails and the TNS record is located in a file referenced through an IFILE directive. |
TOR-9142 | link |
Schema Browser: Subpartitions of hash partitions are unsupported in the Script tab and Create/Alter Table windows. |
TOR-9157 | link |
Automation Designer: If a connection fails, an error dialog is displayed but does not include any connection details. |
TOR-9173 |
Code Insight: Exception declarations are not shown. | |
TOR-9237 |
Connections: Connection to mounted, but not opened database results in errors. | |
TOR-9307 |
Document Recovery: After a crash, Toad displays the Recover Documents window; however, if a second crash occurs, Toad does not prompt to recover documents on the next restart. | |
TOR-9315 | link |
Alter Tablespace: When the window opens, the General tab briefly appears before automatically switching to the Files tab. |
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-5153 | link |
Editor: Wrong desktop is assigned after reordering tabs. |
TOR-6187 | link |
Code Insight: Join conditions based on referential integrity are not shown. |
TOR-6446 | link |
Editor: 'Load object at caret' does not respect the option to load package/type spec and body as a pair. |
TOR-7853 | link |
Connections: "Net: Invalid input arguments" error upon connecting to some databases in clientless mode. |
TOR-8187 |
Debugger: Stepping into Java Source throws an error. | |
TOR-8188 |
Extract DDL: Table scripts exclude the object_table_substitution clause. | |
TOR-8194 |
Schema Browser: Create user script excludes private synonyms if the script is generated for multiple, selected users. | |
TOR-8196 | link |
Compare Schemas: REVOKE ROLE command appears before its comment in the sync script. |
TOR-8205 |
Session Browser: Refreshing the page results in a brief flicker before the data fully loads. | |
TOR-8206 |
Schema Browser: ORA-01009 error is raised when selecting the SYSTEM tablespace. | |
TOR-8216 | link |
Add Login Record: TNS dropdown only populates when TNS_ADMIN environment variable is defined. |
TOR-8232 |
Schema Browser: Script tab for object table excludes NOT NULL constraints. | |
TOR-8233 | link |
Editor: EDIT command generates a read-only grid when the "OCI Array Buffer Size" option is set to "Manual". |
TOR-8245 | link |
Editor: Inline parameter assistance cancels and leaves artifacts when clicking elsewhere in the Editor while the assistance is showing. |
TOR-8247 | link |
Automation Designer: Export Dataset action shows "Parameters are out of sync" message in some cases. |
TOR-8299 |
Command Line: Running Toad.exe with the "-c" option to make a connection does not work if Toad is running and the "Allow multiple copies of Toad" option is unchecked. | |
TOR-8303 | link |
Editor: Filename paths shown as tab hints stop working in some cases. |
TOR-8305 |
Object Compare: The sync script tab is missing when comparing objects with identical schema and object names across two connections. | |
TOR-8314 |
Connections: An access violation occurs when connecting to a schema having an expired password if no Oracle clients are installed. | |
TOR-8330 | link |
Editor: Character and caret misplacement when using Windows scaling other than 100% with some font and size combinations, e.g. Consolas 14 pt and others. |
TOR-8331 |
Team Coding: Getting the latest revision fails if the character case of the file extension differs between the local and remote files. | |
TOR-8334 |
Database Browser: A "Password not supplied" error occurs when connecting as an externally authenticated user. | |
TOR-8335 |
Toolbars: The Window menu identifies the incorrect window as active in some cases. | |
TOR-8336 |
SQL Recall: Statements dragged to the Editor are missing the statement terminator. | |
TOR-8337 |
Login Window: The LDAP dropdown does not populate after unchecking "Connect using Oracle client". | |
TOR-8338 |
Session Browser: The splitter position is incorrect when using the left/right layout and switching to another window. | |
TOR-8382 |
Database Health Check: An error is shown when the "list segments which can't extend" option is used and there are tablespaces which cannot extend. | |
TOR-8387 |
DBMS Output: Fetching output results in an ORA-02005 error with some clients. | |
TOR-8390 | link |
Editor: The EDIT command occasionally triggers an unexpected ORA-00904 error. |
TOR-8396 | link |
Automation Designer: The Export Dataset action fails to replace substitution variables if there are comments or trailing whitespace on lines preceding them. |
TOR-8414 |
Editor: In some cases Toad hangs when selecting text when the Brace Highlighting option is set to 'Innermost pair in scope' | |
TOR-8417 |
Team Coding: Files with special characters in their filenames are not displayed in the Team Coding Manager's list of VCS files. | |
TOR-8437 | link |
macOS: Toad on macOS will not start with some locale settings, e.g. Korean. |
TOR-8445 | link |
Data Grid: Object Editor shows incorrect columns and throws an Access Violation after scrolling in some cases. |
TOR-8463 |
SFTP: Connecting with a private key that was created with a passphrase results in a "Logon failed 280: Error decoding key: The specified password is not correct" error. | |
TOR-8477 |
Compare Data: A "Cannot insert null" error is thrown in some cases. | |
TOR-8478 |
Schema Browser: An error occurs when expanding Unified Audit Policies in treeview mode. | |
TOR-8496 |
Report Editor: Buttons on the vertical toolbar in the FastReport Editor will disappear after mousing over them on Windows Server. | |
TOR-8497 |
Editor: Selecting text and replacing all occurrences of it using the Find & Replace dialog with the "from cursor" option excludes the selected text. | |
TOR-8499 | link |
Export DDL: Table scripts are incorrect with respect to automatic and interval partitions when the "Storage Objects | Partitions" option is set to ALL or DEFAULT/MAXVALUE. |
TOR-8521 | link |
Data Grids: The '...' button to choose a filename is disabled in the Export Dataset dialog when the Output selection is changed from Clipboard to File. |
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-6106 | link |
Connections: Timezone data is incorrect when querying some databases using "no client" mode. |
TOR-7625 | link |
Color Schemes: Some buttons on the login window lack a border when using color schemes on Windows Server 2016. |
TOR-7709 | link |
Toolbars: The window menu, shown to the left of the File menu for maximized windows, duplicates its menu items each time it is clicked. |
TOR-7768 | link |
Connections: The connection bar "Containers" menu is out of sync after an ALTER SESSION SET CONTAINER statement is executed in the Editor. |
TOR-7824 | link |
Script Execution: The elapsed time shown in the progress dialog is incorrect in some cases. |
TOR-7839 |
Execution: Access Violation occurs when using "no client" mode and selecting RAW datatype over a database link. | |
TOR-7868 | link |
Connection Bar: The "Reconnect all" menu item is disabled at times it should be enabled. |
TOR-7874 | link |
Editor: Compiling a package having an error indicates the wrong line as having the error. |
TOR-7880 | link |
Export Dataset: The default extension for Excel should be .xlsx and for Access it should be .accdb. |
TOR-7882 | link |
Mac: Editor takes a long time to load if CAPS lock is enabled. |
TOR-7888 | link |
Editor: Goto Line (Ctrl+G) throws an exception in some cases. |
TOR-7906 |
Data Grids: ORA-00903 error is raised when updating data of a LONG RAW field. | |
TOR-7909 | link |
Schema Browser: Tab key does not advance through all fields properly in the Filter/Sort dialog. |
TOR-7912 |
Debugger: Access Violation occurs in some cases if the background session is disconnected. | |
TOR-7955 | link |
Connection Bar: Opening a window from the "Frequently used" menu of an inactive session's connection bar button opens the window for the active session, instead. |
TOR-7963 |
Export Dataset: Exporting to Excel does not include data for CLOB fields exceeding 32767 characters. | |
TOR-7969 | link |
Workspaces: Access Violation occurs when loading a workspace in some cases. |
TOR-7971 | link |
Automation Designer: The Compare Schemas action uses CREATE instead of CREATE OR REPLACE in the sync script when executed using a parameter file that was created with Toad for Oracle 16.3 or older. |
TOR-7982 |
Code Analysis: Running Code Analysis with the SQL Scan option enabled causes Toad to disappear in some environments. | |
TOR-7988 | link |
Schema Browser: The Alter Table dialog includes the schema in ALTER TABLE RENAME COLUMN statements when the "Show SQL without schema" menu item is chosen. |
TOR-7989 | link |
Toolbars/Menus: Setting a custom shortcut for Print Preview does not work. |
TOR-7996 | link |
Workspaces: Creating a new Editor tab after opening a workspace does not always activate the new tab. |
TOR-7997 | link |
Editor: The Load DB Object window has an empty, gray panel when the "Show source" checkbox is unchecked. |
TOR-8002 |
Connections: The Reconnect button is unavailable on the dialog shown for ORA-00045 errors. | |
TOR-8006 |
Automation Designer: The Format Files action modifies reserved word character case and does not format the code | |
TOR-8007 | link |
Automation Designer: Variable substitutions are not made to the Export Dataset action's SQL text if the SQL has been modified after mapping substitution variables to Automation Designer variables. |
TOR-8012 | link |
Session Browser: Quickly clicking on nodes in the left side navigator causes the Session Browser to process each click and slow down for a bit as it catches up. |
TOR-8040 |
General: Long error message text is truncated in error dialogs if using a dark color scheme. | |
TOR-8044 |
Schema Browser: The Tables Script tab truncates constraint text longer than 4000 characters. | |
TOR-8047 | link |
Master-Detail Browser: An error occurs when setting a filter having a comment on the first line. |
TOR-8056 |
Schema Browser: Filters set on the Invalid Objects tab do not affect indexes. | |
TOR-8063 |
Connections: Connecting to an Oracle Cloud database without a client raises an ORA-12506 in some cases. | |
TOR-8081 | link |
Statspack Browser: Copying a SQL Summary row to clipboard causes Toad to freeze for a while.. |
TOR-8083 | link |
Data Import Wizard: Custom date format does not accept dot or dash as date separator. |
TOR-8086 | link |
Script Execution: DESC PACKAGE excludes functions and procedures without parameters. |
TOR-8093 | link |
Data Grids: Saving a blob to file omits the extension if it is not specified in the filename. |
TOR-8096 | link |
Data Grids: CTRL+F to find data selects wrong columns. |
TOR-8103 |
Project Manager: Files loaded in external application always use the default association from Windows instead of the association defined in the Project Manager settings. | |
TOR-8116 | link |
Login Window: Connection made to the wrong database after editing a previously used connection's alias in the grid and selecting a different database from the right side dropdown and clicking Connect. |
TOR-8117 | link |
Data Grids: Record Count does not respect filtered records. |
TOR-8172 | link |
Automation Designer: Changing the output file extension of an Export Dataset action using Excel file format from .xlsx to .xls will change the extensions of other Export Dataset actions also exporting to Excel file format. |
TOR-8178 |
Automation Designer: Format Files action introduces a mix of CRLF and LF end of line characters. |
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.
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:
|
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 |
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 |
Queries that return fields with a BOOLEAN datatype result in a 'Datatype is not supported' error when using the Oracle 23ai client. Workaround: Use an older Oracle client or make the connection without using a client. |
N/A |
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:
For 32-bit applications on a 64-bit machine:
Apply settings to your own account: HKEY_CURRENT_USER\Software\Quest Software\Internet Settings:
Notes for use:
|
72966 |
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. |
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 |
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 |
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 |
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 |
Known Issue | Issue ID |
---|---|
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. |
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.
|
N/A |
Known Issue | Issue ID | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Changing the default Editor font when Windows high DPI settings are in use, i.e. scaling greater than 100%, may result in negative effects, including:
Advanced options for controlling Editor rendering have been introduced in Toad for Oracle 2024 R2 to help alleviate these issues. See the Editor | Behavior page in Toad Options.
If you see high DPI issues and wish to use the Default technology, there are a few workarounds:
|
N/A | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
Known Issue | Issue ID |
---|---|
The "Allow multiple copies of Toad to be loaded" option is nonfunctional. The option allows multiple copies of Toad to be opened on Windows, but does not work on macOS. The option has been disabled. Workaround: Review macOS documentation for instructions on how to open a new instance of an app on Mac. |
N/A |
The "File | Fast Exit" feature is nonfunctional. The feature allows for quickly closing Toad without prompting to save work. It has been disabled. |
N/A |
The Quit menu item from Apple's Toad for Oracle menu is nonfunctional if an Editor is open. |
N/A |
Editor is slow to open if CAPS lock is enabled. Workaround: Turn off CAPS lock before opening Editor. |
N/A |
Bold text and other UI painting issues after installing Team Coding database objects. Workaround: Restart Toad. |
N/A |
TNSPING is unavailable in the Login window. It is available in Toad for Oracle on Windows. |
N/A |
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 |
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.
Requirement |
Details |
---|---|
Processor |
|
Memory |
Note: The memory required may vary based on the following:
|
Hard disk space |
|
Operating system |
|
Requirement |
Details |
---|---|
Database client |
An Oracle client is optional. Connecting to a database without an Oracle client has the following considerations:
The following Oracle clients are supported:
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:
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 |
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.
Requirement |
Details |
---|---|
Additional Software |
|
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. |
In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.
Operating System |
Requirements |
---|---|
Windows non-Server Windows Server |
|
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. |
To activate a trial
To activate a purchased commercial license
Notes:
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
Create a new Quest.com account
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
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
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center