Toad for Oracle - Search Global

Refine Your Search
Advanced Queries | | Increase Your Search IQ
Rebuilding an index versus dropping and recreating it (187030)

Is using the Rebuild Index feature the same thing as dropping and recreating the index? Rebuilding an index has the same overall effect as dropping and recreating it, but rebuilding is faster. Rebuilding also requires more storage ...

No drop statement is included in table script to drop indexes on that table (187029)

When building a script for a table, the options are selected to include a drop statement and to include indexes. A statement to drop the table is include, as well as create statements for the indexes associated with that table, but ...

How to Run Toad for Oracle on a Citrix System? (134662)

How to Run Toad for Oracle on a Citrix System? Toad must be installed on the Citrix server by the Citrix administrator. Users then connect to this instance through their Citrix login. Note: Toad for Oracle 12.1 has been tested on Citrix XenApp 6.5 on Windows Server 2008 R2. ...

Installation, error message; 剏ⵁ㈱㔱㨴吠华挺畯摬渠瑯爠獥汯敶猠牥楶散渠浡 (132116)

It seems as if the link to download the English version is actually downloading the Chinese version. Clicking on the download link for Toad for Oracle 12.5.1 Installer (for 32 bit Oracle client) shows the address https://support.software.dell.com/toad-for-oracle/12.5.1#. ...

Toad: No option to export all insert statements to one file for multiple tables (126958)

The option, "Create one file for all tables" in the Export Dataset tool is grayed out for all export formats except "Access Database File". Would it be possible for Toad to enable this feature for the "Insert Statements" format too? WORKAROUND: None. STATUS: ...

Temp Tablespaces, data files with autoextend causes max size is to be displayed less than tablespace (104052)

In the Toad for Oracle schema browser, the Temp tablespace Max size is less than tablespace size. (See attached screenshot) After tracing the SQL to extract the tablespace, the SQL to extract Temp tablespace is incorrect. You ...

How are licenses defined by seat or by User? (117376)

How are licenses defined by seat or by User? A "User" is a named individual or unique login identity. Software licensed by User may be used by the User on an individual computer, on a network storage device, or in a virtualized or shared environment (such as a Citrix server). ...

'Open File' no longer has Tree View or File Preview after upgrading (128816)

In version12.1, clicking Open File in Editor would bring: On the left side a Tree View of Favorites and other File Folders, in the middle - list of files in the selected folder,. and on the right side, a preview of the selected file contents. ...

File | Open Toad compresses the favorites list as C:\... in Toad for Oracle 12 (109971)

When using Toad for Oracle 12 when you navigate to File|Open where you are directed to existing files. On the left side you see "favourites". However, in Toad for Oracle 12 the full path of the file in the favourites section is not ...

What are the differences between how F5 and F9 works in running or executing scripts / statements? (109882)

What are the differences between how F5 and F9 works in running or executing scripts / statements? F9: - Executes within Toad. - Fetches a limited number of rows (500 by default) in initial execution. - Does not support SQL Plus Commands. ...

Use automation to print a report to on multiple Databases to one file (111001)

How to create an automation app to query multiple connections and send the results to one file as per Quest Backup reporter? This enhancement request has been submitted. Vote on this idea at the Idea Pond. Idea Pond is ...

Error report - eurekalog.com, another process is accessing it (101532)

A box popped up saying something about a file can't be accessed because another process is accessing it. Send the error report to support@eurekalog.com Version of Eureakalog is out of date. There is a patch applied to V11.6..1 to fix this issue. ...

Toad for Oracle 11.0. The FTP Utility text type search is not functioning or is not working. (100868)

Toad for Oracle 11.0. The FTP Utility text type search is not functioning or is not working. Issue fixed in version 11.5 and higher. The latest version of Toad for Oracle can be downloaded here.

Receiving an "Ora-01400: cannot insert NULL into (Schema.Table.Column)" error importing (104678)

When trying to enter a NULL into a not null column with a default, using Import Table Data, an error message is returned that says, "Ora-01400: cannot insert NULL into (Schema.Table.Column)". Prior to v11.5, this worked correctly. ...

Database | Administer | Tablespaces error: "The number of items cannot be greater than 64, if the EditValueFormat is cvfInteger." (136036)

Go to Database | Administer | Tablespaces | “Space History” tab or “Objects” tab will get the error below. Also, the Tablespace drop-down list does not show all the existing Tablespaces. Error: “The number of items cannot be greater than 64, if the EditValueFormat is cvfInteger.”. ...

Can you set the date format on an Export to Excel for a data grid? (112106)

When exporting a data grid to an Excel file or Excel instance is it possible to set the date format? Enhancement Request has been submitted to Development for consideration in a future release of Toad for Oracle. Click here.

The Display Pick List either does not show and/or it shows the column names from the wrong table. (135573)

The Display Pick List either does not show and/or it shows the column list from the wrong table. STEPS TO REPLICATE: 1) Open a new SQL Editor. 2) Manually type: Line 1: SELECT * FROM customer <--- do not put semi-colon. ...

How to defragment or coalesce an Oracle Tablespaces? (117197)

How to defragment or coalesce an Oracle Tablespaces? The Coalesce feature in Toad can be accessed by going to the Schema Browser | Tablespaces Tab | right-click a Tablespace | click on “Coalesce tablespace“. You can ...

Errors "Access violation at address 61DCE86B in module 'OraClient10.Dll'" and ORA-12592 (126456)

The following errors are occurring frequently within Toad. Access violation at address 61DCE86B in module 'OraClient10.Dll'. Write of address 00000000. ORA-12592: TNS:bad packet. ORA-12569 TNS:packet checksum failure. ...

"ORA-01031: insufficient privileges" when trying to connect in Toad. (115212)

"ORA-01031: insufficient privileges" when trying to connect in Toad. SQL Plus can connect without issue CAUSE 1: "Connect As" setting in Toad connection window not set correctly. If the user account is a NORMAL user, trying ...

DB2 client version 7 is causing an issue on installation. (68510)

I am getting an error staying that Toad for Data Analysts (TDA) cannot be installed with my current DB2 client version 7 that I have on my PC. WORKAROUND: Please contact IBM to download DB2 client version 8. Once you ...

Install, Range Check Error, ExceptionLog7.Init (Location: (0010E13C){Toad.exe } [0429F13C] EModules.TEurekaModulesList.AddModuleFromFileName (101542)

Error message during the Toad for Oracle installation OR during the startup / launch of Toad: "Range Check Error". ExceptionLog7.Init (Location: (0010E13C){Toad.exe } [0429F13C] EModules.TEurekaModulesList. AddModuleFromFileName (Line 625, “EModules.pas”) + $14). ...

Is it possible to save data grid (Export Dataset) to OpenOffice Calc format? (69128)

Is it possible to save data grid (Export Dataset) to OpenOffice Calc format? Toad cannot export datasets directly in OpenOffice calc format, however OpenOffice Calc can open a wide variety of formats including .xls, .xlsx, .txt, .csv so any of these could be used in Toad to export. ...

Using Team Coding Editor becomes read-only after selecting different object in Schema Browser (102921)

Team Coding is enabled in one schema (Schema A). The user connects to a different schema (Schema B) that is not controlled and is not a part of team coding. In Schema B, this package can be opened and edited in the Editor. ...

Bigfile Tablespace datafiles over 1TB, Datafile Size is blank (106796)

User has a couple of Bigfile tablespaces that are very large (over 1TB). When altering the Tablespace and trying to make the maxsize even larger, Toad can't handle a current size over 1TB. The Datafile Size is blank. One has to change the maxsize in GB which is a pain. ...