Toad for Oracle Forum - Toad for Oracle - Toad World
Danny Torres
Follow / 16 Jan 2017 at 8:21pm / Toad for Oracle

Hashtag game! Tomorrow, let's make #ToadTuesday trend!

Expand content
Hi All, Tomorrow, we are kicking off a new daily content feature in Social Media. We can show your Social Media presence with other Toad users tomorrow using the hashtag, #ToadTuesday This is the...

Hi All,

 Tomorrow, we are kicking off a new daily content feature in Social Media.

We can show your Social Media presence with other Toad users tomorrow using the hashtag, #ToadTuesday

 This is the tweet that will start the hashtag trending:

 

Hashtag game! Tweet out how long Toad has been a part of your life! Tag w/ #ToadTuesday.

You could be featured on next blog!

53 0 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 1:48pm / Toad for Oracle

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

436 0 / Create an account to join the discussion.
Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle

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.

997 0 / Create an account to join the discussion.
Moses
Follow / 19 Jan 2017 at 2:46pm / Toad for Oracle
Latest post by on 19 Jan 2017 at 9:03pm

Code Snippets have disappeared

Expand content
Hi, I'm using TOAD for Oracle 12.7 DBA Suite The Code Snippets Categories are visible but the code for the categories is not visible. I have not upgraded recently or made changes. This...
Hi,
I'm using TOAD for Oracle 12.7 DBA Suite

The Code Snippets Categories are visible but the code for the categories is not visible.
I have not upgraded recently or made changes.
This is an original install so there are no previous user settings to install.
There is a CodeSnippets.err file dated Jan 9 2017.
Text as follows:
TPF0
TCodeSnippets_1Categories.StringsCursor AttributesData Conversion FunctionsDate Format OptionsDate FunctionsDefined ExceptionsGroup FunctionsNumber Format OptionsOracle Pseudo ColumnsOther Misc. FunctionsRegular ExpressionsSingle Row Character FunctionsSingle Row Number FunctionsSql Optimizer hintsUser provided Function List Items

What do I need to do?

Thanks.
40 3 / Create an account to join the discussion.
dirk.mika
Follow / 19 Jan 2017 at 8:28am / Toad for Oracle

Database Monitor takes ages to load and to capture new values

Expand content
Hi, I'm using TOAD Version 12.10.0.30 and all of a sudden since yesterday I'm unable to use the database monitor. After selecting the menu entry it takes several minutes (while the application...

Hi,

I'm using TOAD Version 12.10.0.30 and all of a sudden since yesterday I'm unable to use the database monitor. After selecting the menu entry it takes several minutes (while the application is completely unresponsive) for the monitor to load.

And both an automatic and a manual refresh takes just as long.

I've no clue what has caused this. I was able to use the database monitor without any issues till then.

Is there any old data I can clear?

Dirk

24 0 / Create an account to join the discussion.
Deandyno
Follow / 18 Jan 2017 at 4:13pm / Toad for Oracle
Latest post by on 18 Jan 2017 at 6:17pm

ORA-12557: TNS: Protocol Adapter not loadable

Expand content
I have both the 64bit and 32bit Oracle clients installed, our other tools are working fine but when we try using Toad for Oracle we get the ORA-12557 error. This setup is on Windows 2012 R2, there is...

I have both the 64bit and 32bit Oracle clients installed, our other tools are working fine but when we try using Toad for Oracle we get the ORA-12557 error.

This setup is on Windows 2012 R2, there is no ORACLE_HOME defined as an environment variable, within toad it appears the correct Oracle 32bit home is recognized, is there a way for me to force only toad to leverage the 32bit client in an ini, registry setting, or config file somehow.

188 9 / Create an account to join the discussion.
geir.k.edland
Follow / 18 Jan 2017 at 3:31pm / Toad for Oracle
Latest post by on 18 Jan 2017 at 5:38pm

Has F8 (View Recent SQL Statements) been removed from TOAD 12.10?

Expand content
My F8 (View Recent SQL Statements) does not work - And I can not find any Recall (F8) under Views either - as the Help -> Content suggests. Has it been removed or replaced, or have I unintentionally...
My F8 (View Recent SQL Statements) does not work - And I can not find any Recall (F8) under Views either - as the Help -> Content suggests.
Has it been removed or replaced, or have I unintentionally removed it somehow?
Answered 138 4 / Create an account to join the discussion.
madavis_us_375
Follow / 17 Jan 2012 at 10:52pm / Toad for Oracle
Latest post by on 18 Jan 2017 at 2:00am

SQL Developer vs toad for oracle

Expand content
I have a client site where the customer is thinking of switching from Toad for Oracle Suite to SQL Developer because SQL Developer has all the tools needed. Before I could argue that schema diff were one...

I have a client site where the customer is thinking of switching from Toad for Oracle Suite to SQL Developer because SQL Developer has all the tools needed. Before I  could argue that schema diff were one reason to stay with TOAD but now SQL Developer has it and the tool is free. What are some of the strongest cases to use to persuade my client to stay with TOAD. I am partial too, I love the tools but a certain group of consultants are pushing for SQL Developer.

24208 11 / Create an account to join the discussion.
abdullah.tariq
Follow / 12 Jan 2017 at 9:21am / Toad for Oracle
Latest post by on 12 Jan 2017 at 12:50pm

oracle database restore and patching

Expand content
Hello, I want to know, can we perform database restore and patching through toad? Thanks, Abdullah.
Hello,

        I want to know, can we perform database restore and patching through toad?
Thanks,
Abdullah.
       
Unanswered 114 1 / Create an account to join the discussion.
matthew.school
Follow / 11 Jan 2017 at 1:29pm / Toad for Oracle
Latest post by on 11 Jan 2017 at 2:04pm

GUI Problems

Expand content
Can someone tell me how to reset my data grid and query editor back to the default positions? Every time I open a SQL document or execute a query, it expands the data grid to cover up all the other windows...
Can someone tell me how to reset my data grid and query editor back to the default positions? Every time I open a SQL document or execute a query, it expands the data grid to cover up all the other windows.  Furthermore, It is  difficult to even find the query editor.                                                                
Unanswered 82 1 / Create an account to join the discussion.
matthew.school
Follow / 11 Jan 2017 at 1:30pm / Toad for Oracle
Latest post by on 11 Jan 2017 at 1:53pm

Is it possible to schedule queries

Expand content
I would like to dispatch toad queries on a recurring basis to a file directory. Is this possible? Does Toad need to be open in order to accomplish it?
I would like to dispatch toad queries on a recurring basis to a file directory.  Is this possible? Does Toad need to be open in order to accomplish it?
Unanswered 102 1 / Create an account to join the discussion.
matthew.school
Follow / 11 Jan 2017 at 1:25pm / Toad for Oracle
Latest post by on 11 Jan 2017 at 1:45pm

Server Name?

Expand content
How can I view the name of the backend server in my current connection?
               How can I  view the name of the backend server in my current connection?                                
Answered 95 2 / Create an account to join the discussion.
chazamania
Follow / 10 Jan 2017 at 5:01pm / Toad for Oracle
Latest post by on 10 Jan 2017 at 8:27pm

Toad 12.10 Schema Compare Inclusion Options NOT Like Filter with SDXML...

Expand content
I have a bunch of tables prefixed with CPY that I'm trying to exclude from comparison even when they are in the SDXML source. I see the database queries excluding them properly in the destination....

I have a bunch of tables prefixed with CPY that I'm trying to exclude from comparison even when they are in the SDXML source. I see the database queries excluding them properly in the destination. Shouldn't the filter exclude them on both sides regardless of database or file?  

Unanswered 146 3 / Create an account to join the discussion.
Edgar Allan Bayron
Follow / 5 Jan 2017 at 3:48am / Toad for Oracle
Latest post by on 9 Jan 2017 at 3:14pm

Import Views only

Expand content
As the subject suggests, is there a way to import only views from a database to another? Thanks !

As the subject suggests, is there a way to import only views from a database to another? Thanks !

143 3 / Create an account to join the discussion.
a.droge
Follow / 6 Jan 2017 at 9:29am / Toad for Oracle
Latest post by on 9 Jan 2017 at 12:43pm

Editor tabs

Expand content
Suddenly I can only open 1 single tab in the Editor, and its name tag had disappeared. Which option should I change, to be able open several tabs again? we use Toad for Oracle 12.6.0.53, Thanks for...

Suddenly I can only open 1 single tab in the Editor, and its name tag had disappeared. Which option should I change, to be able  open several tabs again?

we use Toad for Oracle 12.6.0.53,

Thanks for your help!

Answered 231 6 / Create an account to join the discussion.
j.milz
Follow / 5 Jan 2017 at 5:18pm / Toad for Oracle
Latest post by on 5 Jan 2017 at 7:59pm

How to disable grid popup editor?

Expand content
When I double click a cell in grid view to edit it's content and I'm too fast the grid popup editor window opens. Can I disable this? I don't need the popup editor. Cheers, Jan

When I double click a cell in grid view to edit it's content and I'm too fast the grid popup editor window opens.

Can I disable this? I don't need the popup editor.

Cheers,

Jan

Unanswered 132 1 / Create an account to join the discussion.
je-marie-s.nasayao
Follow / 5 Jan 2017 at 11:08am / Toad for Oracle

How to Download Old Version TOADORACLE_FREEWARE_121_X64.MSI?

Expand content
Hi Toad Experts, I have a freeware Oracle Toad installed on our server, however I'm unable to uninstall it as it is looking for TOADORACLE_FREEWARE_121_X64.MSI. Can you please kindly tell me where...

Hi Toad Experts,

I have a freeware Oracle Toad installed on our server, however I'm unable to uninstall it as it is looking for TOADORACLE_FREEWARE_121_X64.MSI.

Can you please kindly tell me where to download this old version?

Or can you please help me how to uninstall my old freeware version?

Thank you in advance

Unanswered 93 0 / Create an account to join the discussion.
chazamania
Follow / 4 Jan 2017 at 1:43pm / Toad for Oracle
Latest post by on 4 Jan 2017 at 5:50pm

Trace File Browser Issues

Expand content
All of this is 12.10 32bit on Win7. 1. The default Directory on 'Select file from database server...' Can the Directory default be the last selected vs. what seems to be the greatest T% named...

All of this is 12.10 32bit on Win7.

1. The default Directory on 'Select file from database server...'

Can the Directory default be the last selected vs. what seems to be the greatest T% named directory? The TOAD% generated one was always right and my default until I installed SQLT which adds three TRCA$S% directories. Now it defaults to the last T%.

2. Filter default

Is there a way to preserve the filter? My logon trigger embeds my username in the trace file name. It would be nice to fix it as *char*.trc.

3. Open file in external editor

It never launches or opens anything. It did many releases ago. Navigating 20 directories to get to it is painful...almost enough to get me to finally make a shortcut.

123 2 / Create an account to join the discussion.
stat.gv1975_906
Follow / 19 Jul 2011 at 1:25pm / Toad for Oracle
Latest post by on 4 Jan 2017 at 12:55pm

toad sdk

Expand content
Hi , Is there some kind of sdk/api for TOAD? Is it possible to develop an extension or plugin for TOAD?
Hi ,

Is there some kind of sdk/api for TOAD?
Is it possible to develop an extension or plugin for TOAD?
9415 4 / Create an account to join the discussion.
agrady
Follow / 6 Mar 2014 at 3:22pm / Toad for Oracle
Latest post by on 4 Jan 2017 at 8:30am

How do I alter the width of script output in Toad (output from running...

Expand content
I'm new to Toad and the script output is set at 80 columns so there's all kinds of wrapping. Need to widen it. I changed the "Visible right margin" but apparently that applies to the...

I'm new to Toad and the script output is set at 80 columns so there's all kinds of wrapping.  Need to widen it.

I changed the "Visible right margin" but apparently that applies to the editor, not script output.

Help!

Answered 13112 5 / Create an account to join the discussion.