Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by Anonymous on 26 Jun 2017 at 9:58am

How to get the most out of this forum – Best practices for what information...

Expand content
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,...

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:

-          http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/new-features

-           

-          Link to Download & Documentation:

-          https://support.software.dell.com/toad-for-oracle/12.9

-           

-          Link to Trial:

-          https://software.dell.com/products/toad-for-oracle/software-downloads.aspx

-           

-          Overview of new feature(s) (with link to the release notes)

-          http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/new-features

-          http://documents.software.dell.com/toad-for-oracle/12.9/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

  1. Video - How to make a database connection using Direct, TNS and LDAP in Toad for Oracle (205157) https://support.software.dell.com/toad-for-oracle/kb/205157
  2. VIDEO - How to install Toad for Oracle using the new Web Installer (178737) https://support.software.dell.com/toad-for-oracle/kb/178737
  3. Video - How to use the SQL Tracker tool? (193849) https://support.software.dell.com/toad-for-oracle/kb/193849
  4. VIDEO - Get more out of your Toad for Oracle investment with free training. (145507) https://support.software.dell.com/toad-for-oracle/kb/145507
  5. Video: Need help to download Toad for Oracle from the Support Portal. (108974) https://support.software.dell.com/toad-for-oracle/kb/108974

 Feel free to browse them. Remember to sign in to your account to view.

1875 1 / Create an account to join the discussion.
cezar_bd
Follow / 30 Aug 2017 at 11:15am / Toad for Oracle
Latest post by on 23 Oct 2017 at 6:50pm

No full description about New connection window

Expand content
Hi team, I'm trying to use the Direct connection, but can't find description about filed Instance Name and Protocol, what for they are used?
Hi team, I'm trying to use the Direct connection, but can't find description about filed Instance Name and Protocol, what for they are used?
Unanswered 134 1 / Create an account to join the discussion.
grotto123
Follow / 20 Oct 2017 at 12:46am / Toad for Oracle
Latest post by on 23 Oct 2017 at 2:43pm

TOAD for Oracle 12.12 Exporting to Excel File error

Expand content
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...

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.

Unanswered 140 8 / Create an account to join the discussion.
VinceR
Follow / 24 Apr 2015 at 1:54pm / Toad for Oracle
Latest post by on 23 Oct 2017 at 2:07pm

Very slow to open the Tablespace View

Expand content
When connecting to a brand new Oracle 12.1.0.2.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...

When connecting to a brand new Oracle 12.1.0.2.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 11.5.1.2 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?

thanks

Vincent

15445 10 / Create an account to join the discussion.
Guest
Follow / 7 Apr 2011 at 3:37am / Toad for Oracle
Latest post by on 23 Oct 2017 at 6:09am

TOAD Installation error

Expand content
Windows Vista Basic. When I install Toad in my laptop it sends me the following error and does not allow me to go I closed the tool Toad C:\Program Files\Quest Software\Toad For Oracle\user\Files\Lexlib...

Windows Vista Basic.

When I install Toad in my laptop it sends me the following error and does not allow me
to go I closed the tool Toad

C:\Program Files\Quest Software\Toad For Oracle\user\Files\Lexlib.lxl
was not found and is
needed please contact Quest Support...

17346 3 / Create an account to join the discussion.
Jorley
Follow / 4 Oct 2017 at 4:08pm / Toad for Oracle
Latest post by on 20 Oct 2017 at 3:57pm

Comparing procedures with case sensitive option on results in "No...

Expand content
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. ...

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?

Unanswered 270 12 / Create an account to join the discussion.
icarrasquedo
Follow / 11 Jan 2016 at 10:58pm / Toad for Oracle
Latest post by on 20 Oct 2017 at 3:45pm

Debug menu is gray

Expand content
Hi , I'm trying to debug a function , but the debug menu contains only gray options. How can I enable it and all the debunging options ?
Hi , I'm trying to debug a function , but the debug menu contains only gray options.
How can I enable it and all the debunging options ?
Unanswered 2647 2 / Create an account to join the discussion.
luckyfriends
Follow / 20 Oct 2017 at 1:35pm / Toad for Oracle
Latest post by on 20 Oct 2017 at 2:41pm

the compared results show 0 objects exist between different pdb(like...

Expand content
I installed toad for oracle 12.11.0.95 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...

I installed toad for oracle 12.11.0.95 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.

It's strange.

48 2 / Create an account to join the discussion.
rbarri
Follow / 20 Oct 2017 at 12:53am / Toad for Oracle
Latest post by on 20 Oct 2017 at 4:45am

How can I resize the data grid?

Expand content
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...

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 12.12.0.39

72 1 / Create an account to join the discussion.
grotto123
Follow / 20 Oct 2017 at 12:25am / Toad for Oracle

TOAD 12.12 export to excel file doesn't work (freezes client)

Expand content
delete

delete

59 0 / Create an account to join the discussion.
lhernandez_75862
Follow / 17 Oct 2017 at 11:03pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 9:31pm

Format for date query

Expand content
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 :...

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 ?

Thanks.

161 14 / Create an account to join the discussion.
holgatekyle
Follow / 18 Oct 2017 at 4:21pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 9:04pm

Importing code sytax highlighting styles to Toad 12

Expand content
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...

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?

54 1 / Create an account to join the discussion.
stefan.graf
Follow / 18 Oct 2017 at 7:09am / Toad for Oracle
Latest post by on 18 Oct 2017 at 8:59pm

Schema compare in Toad 12.12

Expand content
Hi, 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...

Hi,

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.

89 3 / Create an account to join the discussion.
john.ouimette
Follow / 17 Oct 2017 at 10:04pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 7:54pm

Text highlighting in TOAD 12.12

Expand content
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?

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?

102 5 / Create an account to join the discussion.
donald.wilson
Follow / 8 Jan 2016 at 8:00pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 6:00pm

Export the Data to Excel via the Automation Designer

Expand content
Group, 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...

Group,

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 found
1/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.

Don

Answered 5600 13 / Create an account to join the discussion.
Srivathsava
Follow / 18 Oct 2017 at 3:16pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 4:57pm

How to use a PIPELINE in plsql

Expand content
Hi Experts, 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...

Hi Experts,

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,

Sri

71 2 / Create an account to join the discussion.
AJM57
Follow / 18 Oct 2017 at 3:31pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 3:53pm

License question version 11 vs 12

Expand content
OK, so I ordered version 12.10.0.30 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...

OK, so I ordered version 12.10.0.30 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 11.5.1.2 which is not the current version?

Where do I go from here!!!! Refund the purchase and start the process over???

Please advise.

Thanks.

64 2 / Create an account to join the discussion.
AlexP1
Follow / 17 Oct 2017 at 11:30pm / Toad for Oracle
Latest post by on 18 Oct 2017 at 3:02pm

Script export to file without data grid

Expand content
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...

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.

90 5 / Create an account to join the discussion.
PaulZip
Follow / 28 Sep 2017 at 4:38pm / Toad for Oracle
Latest post by on 17 Oct 2017 at 11:42pm

Block operations in editor incredibly slow.

Expand content
TOAD for Windows v 12.11.0.95 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...

TOAD for Windows v 12.11.0.95

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.

169 4 / Create an account to join the discussion.
CBH53
Follow / 17 May 2011 at 2:44am / Toad for Oracle
Latest post by on 17 Oct 2017 at 11:39pm

Grid export limits

Expand content
I need to export over 13M rows of data from a select statement into a .txt file. I would like to generate the single .txt file export. My physical memory won't take it. I usually create the SQL query...
I need to export over 13M rows of data from a select statement into a .txt file.  I would like to generate the single .txt file export.  My physical memory won't take it.  I usually create the SQL query and export from the grid.  What is the best way to deal with it other than trying to limit the size of the export and doing multiple files?  The final file will be around 500Mb size.

Thank you.
10924 1 / Create an account to join the discussion.