You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
The better a problem is described, the better the assistance tends to be.In order to better assist with your issue at hand, please include the following information in your initial post.
- Product, Version, and relevant environment details.
- Include a screenshot of the problem
- Describe the problem fully. What result was expected?
- Can the issue be created on demand or is it intermittent?
- If the problem can be generated faithfully, what are the exact steps to recreate the problem?
- Any other pertinent information (see below)
How to create Support Bundles
The support bundle window provides information about several aspects of your Oracle and Toad setups. In addition, the Support Bundle lets you easily report problems to our peer-to-peer mailing lists or directly to Support.If Toad itself fails, the Error dialog box displays. This type of an error creates a log, saved as toad.elf. This Eureka LogFile (.elf) contains both the application information and the callstack of the error created, and can be very helpful to Support in solving issues you are having with Toad.
To create a support bundle:Select Help | Support Bundle.
Review the following for additional information:
Email Dell Support
This opens the "Email Dell Support" window with instructions and links to contact Support, and to open a new case or service request.
Dell Web Support
This opens Dell Software's award-winning Support portal in your default browser, with access to Licensing Assistance, the searchable Knowledge Base, product downloads and more.
Attach TOAD.INI (or SQL Tuning Support details) to emails
If selected, this attaches the details to any email sent through the support bundle, whether it is to the peer-to-peer Toad list or to Support.
*Note: Please refrain from including private data in your posts. Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you.
Latest Release Information:
This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features. This way you can stay as informed as possible:
- "What’s New" Section:
- Link to Download & Documentation:
- Link to Trial:
- Overview of new feature(s) (with link to the release notes)
Top 5 Knowledge Base Articles:
On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.
This month’s Top Knowledge Base Articles
Feel free to browse them. Remember to sign in to your account to view.
Is anyone else having issues with exporting to excel file? It seems to crash my client for datasets with over 50k rows, but exporting as excel instance works in those cases. There are 8 queries I need to run and save as individual excel files so it would be great to get it work. I'm hoping to ultimately use the automation designer to automate running the queries/saving to excel files.
When connecting to a brand new Oracle 18.104.22.168.0, opening the tablespace view is really slow (1min) but the rest is fine.
- the slow tablespace view is opened either by clicking Database-> Administer -> Tablespace or SchemaBrowser-> Tablespace
- It is the same problem with Toad 22.214.171.124 with OraClient 11g on Win7 and with Toad 12.1 with OraClient 12c on Win7
- Toad Advisor only interesting remark is "Auto-detect Oracle utilities is off" but I am not sure what it means.
- The problem does not exist with Oracle9i, Oracle10g or Oracle11g.
- The Oracle12c database does not use the new feature CDB/PDB => no container / no pluggable db
- I have no other Oracle12c database to test this behavior
Any idea why it is slow? Do I need the latest Toad 12.6?
Windows Vista Basic.When I install Toad in my laptop it sends me the following error and does not allow meto go I closed the tool ToadC:\Program Files\Quest Software\Toad For Oracle\user\Files\Lexlib.lxlwas not found and isneeded please contact Quest Support...
We are working with multiple users on the same procedures and some of us have different toad settings/formatting.
Whenever we compare we like to see what the changes are with our production server.
In comparing with the case sensitive option on it gives some procedures that are different, but when trying to see the differences, Toad gives the message "No more differences" found.
How can I make sure that Toad shows me differences?
I installed toad for oracle 126.96.36.199 in my laptop. I want to using compare schema to get ddl difference. Database is 12 c.
Source db and target db is different pdb, but have same schemas. Now I choose different pdb(like source pdb1, target pdb2) and same schema(c##test1), but the compared results show 0 objects exist in source and target pdb.
Actually, exist objects in pdb. However, If I choose different pdb(like source pdb1, target pdb2) and different schema( like c##test1, c##test2), it will show compared results and there are some different objects.
My data grid is pinned to the application to where it covers up the sql in my editor. I can either click the X to close the grid, or click the pin button next to it to collapse the grid down to a tab that raises if I hover over it. It was not like this before a few days ago. I usually type my sql and then run the query. The grid will come up to about half of the screen, allowing to still see the code. I could also drag the top of it to resize if I wanted. I must have clicked something by mistake.
I am using Toad for Oracle 32 bit 188.8.131.52
Hi , My Toad update at version 12.12 them don't execute querys like :
select * from my_table where campo_fecha >= to_date('01/10/2017') ( first query )
now nedd complete like this : select * from my_table where campo_fecha >= to_date('01/10/2017','dd/mm/rrrr') ( second query )
How config TOAD for support first query ?
I'm trying to migrate from Toad 11 to Toad 12.10.
In Toad 11, there was a very straightforward import/export button for syntax highlighting. In Toad 12.10 it looks like my only option is to import styles from an Oracle server?
I have the .lcf file from Toad 11, how can I use this in Toad 12?
please can we get back the old version - Toad 12.10 an later - of the schema compare. The new one is unusable!
Several compare options don't work - ignore case sensitive, ignore schema names -, so there are more differences then it is.
In the tree there is no option to deselect an group or all differences.
In the differences overview there is no popup menu - lost in delphi object inspector ? ;-) - but ^F for search works. Jump to the next differences or a detail view and copy and past is not available.
In 12.11 it was highlighted like this:
In 12.12 it is like this:
Is there a setting somewhere I need to alter so I don't see a yellow block?
I'm using Automation Designer to run a query and then export the data as an Excel file. I've used the "If..Then..Else" to start the run.
My first step is to connect to the server. This is working fine with no problems. In the next step, it's attempting to run the query via the "Export Dataset" which I've named "PDA Update". The properties look like this:
Using this method, this always fails. I can run it manually with no issues, But if it is scheduled at a specific time, it fails. The error message says:
1/7/2016 6:15:11 AM: PDA Update (Export Dataset) started.1/7/2016 6:15:16 AM: ERROR: The path %1 could not be found1/7/2016 6:15:16 AM: PDA Update (Export Dataset) finished.
Can you help me determine why this is failing?
For the record, I have other automated processes that are running with no issues. The only difference is these are using the "Execute Script" method. Any thoughts as to why it is failing?
In advance, thanks for your help.
We have a requirement where the 'select person_id from TABLE(abc_pkg.abc_fun(:transactionId)) ORDER BY emp_level' should be used where it returns more than one person (we are using this query in Oracle Apps AME to fetch the list of approvers. So we need to use in this format only).
We have XX_EMP_APPRVR_TBL table where it has list of all employees. So, we need to fetch all person_ids from XX_EMP_APPRVR_TBL using abc_pkg.abc_fun. Here, we heared that we need to use PIPELINE command to achieve the result.
Can anyone please help me on how to create function using PIPELINE
Thanks and Regards,
OK, so I ordered version 184.108.40.206 from my company AppStore!
The ordering process went fine!
I got all the approvals. Got the PO. Got an invoice with the License information; ready for install by the IT install team....
At the 11th hour, the install team advised that the installation would not happen due to installing version 220.127.116.11 which is not the current version?
Where do I go from here!!!! Refund the purchase and start the process over???
First off, apologies for the basic post. I'm new to toad coming from SQL management studio. I'm trying to export to .txt the results from a query (F5) but I keep getting the message "You have reached your low memory threshold" is there a way to run the script with a straight output to txt? I've tried database-> spool sql to file and then pressing F5 but still get the error. The query is a join among three tables for about 60K records and about 25 columns so given the data types nothing that shouldn't be too hard to handle. Any help is greatly appreciated. Thanks.
TOAD for Windows v 18.104.22.168
If I select a fairly decent sized block of code (maybe a page or so) in the TOAD editor, for example, in the middle of a fairly large package and press TAB to increase the indentation or DELETE to lessen it, it takes an absolute age to do so. The same things happens if I ALT + Mouse drag a caret section and say use SPACE or DELETE.
When developing we're doing this all the time as part of code formatting, so it's a great hindrance and a weakness that could do with being addressed.