Toad for Oracle - Search Global

Refine Your Search
Advanced Queries | | Increase Your Search IQ
Common Oracle connection issues in Toad for Oracle 10.x & above. Frequently asked questions. (64853)

How to troubleshoot connection errors when logging-in to a supported Oracle database using either a 32-bit or 64-bit Oracle Client. Common Oracle Connection errors: ORA-12154: TNS: could not resolve service name; ORA ...

Error ''Cannot focus a disabled or invisible window' when filtering in SQL Recall (186444)

When the SQL Recall window is not pinned, but allows you to mouse over it, when trying to filter by 'SQL Contains' in the SQL Recall Filter option, the following error appears: 'Cannot focus a disabled or invisible window' WORKAROUND ...

How to download and install Toad for Oracle in Simplified Chinese? (204845)

Full localization of Toad for Oracle, Spotlight on Oracle and SQL Optimizer for Oracle into Simplified Chinese are now available. How to download and install them in Simplified Chinese? The installers can be downloaded here ...

Export table data. When creating a Tab Delimited ANSI file, how to control the field positions? (204464)

Export table data records. Trying to create a Tab Delimited ANSI file, and need to control or specify the field positions. If it's Tab Delimited, there is one tab between each field, and position is irrelevant because tabs can have different widths for different users. ...

It is possible to define SET ROLE or ALTER SESSION SET EDITION commands to be run automatically for every session that Toad creates? (204860)

Using SQL PLUS there is an option for login into particular edition as: CONNECT USER/PWD@DATABASE EDITION = edition_name; It is possible to connect with a particular Edition In Toad? Is there way to manage this? WORKAROUND. None. STATUS. ...

Syntax error occurred in EDIT statement WHERE clause in TOAD (197119)

The below statement in Editor. And this will execute successfully. EDIT scott.emp WHERE e.sal > 1000; But if the EDIT command line is seperated into 2 lines eg, EDIT scott.emp WHERE e.sal > 1000; there will be a syntax error. Toad is using the parser to identify that statement. ...

Create Unit Test failed with ORA-06550 in Toad (199617)

Open a function in Editor and click on 'Execute PL/SQL with debugger'. And Set the Parameters and Execute it successfully. However, there were error when clicking on 'Create Unit Test' in the PL/SQL result tab. ORA-06550 ...

Launching Toad. "No valid Oracle Clients found" error message when opening or starting Toad. (71545)

When launching the Toad application or trying to connect to a database Toad for Oracle returns the following error: "No valid Oracle Client found. Please note that Toad only supports 32-bit Oracle Client installations.". OR. "No valid Oracle clients found. ...

Is there a function to Import / Export the database connections and passwords into/from Toad? (46462)

Is there a function to Import / Export the database connections and passwords into/from Toad? Connections and Passwords can be saved and migrated from within Toad. Starting in Toad 11.0, the Toad connection window toolbar ...

Video - How to use Toad for Oracle's SQL Tracker tool. (193849)

Video - How to use Toad for Oracle's SQL Tracker tool. This will show a basic How-To video on using Toad for Oracle's SQL Tracker tool. Diagnose why not all tables show up in the Schema Browser or the Editor. For example, no tables appear or some tables are missing. ...

Can an explain plan table be specified for use with ‘Auto Optimize SQL’? "ORA 00905: missing keyword" given when using Auto Optimizer. (64683)

How do you specify the explain plan table when using the embedded 'Auto Optimize SQL' feature in Toad's Editor? When trying to run 'Auto Optimize SQL', an error is given: "ORA 00905: missing keyword". and/or. "ORA-00904: Invalid Identifier". ...

SQL Optimizer takes a long time, or does not provide alternative SQL statements. (38385)

After the query is submitted to the SQL Optimizer to be optimized, the SQL Optimizer takes a long time or seems to hang while working to return alternative queries. The intelligence level of SQL Optimizer maybe set too high. ...

How to disable the thousand / comma separator for the decimal numbers when exporting the dataset (61324)

How to disable the thousand or comma separator for the decimal numbers when exporting the dataset to an Excel File? RESOLUTION 1. When choosing export format as "Excel File", select the 'Use only "General" cell formatting ...

SYS objects, instead of users objects, showing in dropdown list of Database | Export | Table as Flatfile (203795)

When logged in as a user (non SYS), and try to select a table for Database | Export | 'Table as Flatfile' | Options tab, the drop-down table list displays tables owned by SYS, rather than the logged on schema. Connection was ...

How to uninstall Toad for Oracle (36982)

How is it possible to uninstall Toad for Oracle? There are no uninstall.exe or uninstall option in the Toad for Oracle setup. Use the Windows' Control Panel | Programs and Features tool to select and remove the desired Toad for Oracle version and follow the on-screen prompts.

Toolbar missing from the Editor window | Data Grid section (203620)

In the Editor window, within the Data Grid section (and associated tabs), the secondary toolbar that appears below these tabs is missing. Close Toad and go into the C:\Users\username\AppData\Roaming\Dell\Toad for Oracle\12.8\User Files folder on your machine. ...

Tips to avoid or lessen Out of Memory errors in Toad. (203417)

Tips or suggestions to avoid, minimize or lessen 'Out of Memory' or 'There is not enough resources to complete this command' or 'Not enough storage is available to process this command' errors in Toad. For Out of Memory errors ...

Toad for Oracle 10.6 and 10.6.1 read-only versions allow running SQL through SQL*Plus (201695)

In Toad for Oracle 10.6 and 10.6.1 read-only versions, it is possible to execute write SQL statements via the Editor | Execute SQL via SQL*Plus. This should not be possible in a read-only installation. This issue is caused by a defect. WORKAROUND: None. STATUS: ...

Access Violation error when changing the application data directory folder in Toad for Oracle (193675)

This issue occurs after installing Toad for Oracle 12.8 on a system where a previous installation of Toad for Oracle 12.1 is present . In this scenario, the application data directory of the 12.1 version was previously changed from ...

How to get or obtain an older version of SQL Navigator or Toad for Oracle? (17533)

Dell Support website only has the past few versions of SQL Navigator and Toad for Oracle available for download. How can a download for an older version of a product be obtained? How and where to find older versions? Contact Dell Support for assistance. ...

Predefined SQLs are not successfully pasted to Toad Editor from Word file. (194215)

Some SQLs are imported with forward quotes and some with backward quotes. Problem in source (eg Word file). Check quotes in source file. Use for example Notepad where differences between forward and backward quotes are better visible.

TNSNames Editor erases progress when performing syntax check from Text Editor (202904)

When using the TNSNames Editor, if you enter a new entry in the Text Editor screen, then click the green Syntax Check icon, the new changes will be erased. WORKAROUND: None. STATUS: Waiting for a fix in a future release of Toad for Oracle.

Error "ORA-06598: insufficient INHERIT PRIVILEGES privilege" when clicking on certain objects in Schema Browser (202820)

In a 12c database, when selecting an object from Schema Browser (tables or procedures selection gets same error), the following error occurs: "ORA-06598: insufficient INHERIT PRIVILEGES privilege". which requires the 'OK' be pressed to continue. ...

Formatter options are not being applied to the Generate Statements tool when copied to clipboard (202698)

After using the "Generate SQL Statement" tool on a table and when it's copied to clipboard, pasting the statement puts 3 columns per line: SELECT. "Adjust", "SLevel", "Access",. "MaxAmount", "LimitedTo". FROM MyTable; It's possible ...

After Toad crashes or is unexpectedly shut down, connection history and passwords are lost when re-opening Toad. (131710)

After Toad crashes or is unexpectedly shut down, when Toad is restarted, the connection information is gone. All the saved connections and their passwords are no longer there. A message may be given, noting that the "connectionspwds ...