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!

267 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

652 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.

1191 0 / Create an account to join the discussion.
geir.k.edland
Follow / 8 Dec 2016 at 12:51pm / Toad for Oracle
Latest post by on 25 Mar 2017 at 3:23am

Loosing color and formatting when copying queries from TOAD to Word...

Expand content
Hi This may be TOAD-related - but might as well be something else: I recently had to set up a new laptop with TOAD - this time on Windows 10. Now I realise I can not copy a formatted (and...
Hi

This may be TOAD-related - but might as well be something else:

I recently had to set up a new laptop with TOAD - this time on Windows 10.
Now I realise I can not copy a formatted (and colored) SQL-statement from the TOAD editor into a word-document or an email (set up with HTML format). When pasting it from clipboard - it just comes out as plain text.
I have a collegue with the same setup Windows 10 and Toad 12.9 64 bit. She does not have this problem. And I did not have it on my previous laptop running Windows 8.1 Update and TOAD 12.9
I have now upgraded to TOAD 12.10 - but it did not help.
When copying from other sources (like a web-page) - I do not loose color or format.

I did find some very old discussions on the net - on the same issue - but from back in 2005-2007. They said it had something to do with Skype - but that is not my case.

Anyone got i solution? It is very annoying!


Geir K. Edland

Answered 493 4 / Create an account to join the discussion.
theresatrx
Follow / 24 Mar 2017 at 9:15pm / Toad for Oracle

Cold Folding "Fold/Unfold" all Editor Option missing?

Expand content
I recently discovered a really handy feature in one of my code editors that enabled me to Fold/Unfold all code folds. Started looking into this in Toad and I see it was a documented feature in release...

I recently discovered a really handy feature in one of my code editors that enabled me to Fold/Unfold all code folds. Started looking into this in Toad and I see it was a documented feature in release 12.7 according to the 12.7 User Guide, you should be able to right click in the editor and the option would be there. Unfortunately I don't see this available in the latest release, 12.10.0.30. Was it intentionally removed or maybe now controlled with a setting that I haven't found yet? It would be really handy to have, I've been using the /*startfold*/ /*endfold*/ manual comments to work around the default folding behavior and it's very time consuming manually collapsing everything individually. Thanks in advance for any recommendations!

33 0 / Create an account to join the discussion.
paul.sousa
Follow / 24 Mar 2017 at 11:48am / Toad for Oracle
Latest post by on 24 Mar 2017 at 7:44pm

How to get Script to work?

Expand content
Hello, I was wondering if someone could please help me out in getting the below script to work since I'm not an expert in SQL What I need is to also get the Description of the EAC .......
Hello,

I was wondering if someone could please help me out in getting the below script to work since I'm not an expert in SQL

What I need is to also get the Description of the EAC ...... the same as the ACTDES.  

If this helps this is the script that pulls in the EAC + Description so I need to add this someway to the script below?

select flex_value, substr(t.description,0,50)
from apps.fnd_flex_values_vl t
where t.flex_value_set_id =  1009148



This is the script that I'm trying to get to work:

select  
j.period_name MTH,
g.segment1 CO,
g.segment2 OU,
(g.segment3||' - '||substr(t.description,0,50)) ACTDES,

substr(j.attribute3,1,6)  EAC,       --- How do we add the EAC + Description

to_number((nvl(j.accounted_dr,0)-nvl(j.accounted_cr,0))) VALUE
from apps.gl_code_combinations g,
       apps.gl_je_categories_tl c,
       apps.gl_je_lines j,
       apps.gl_je_headers h,
       apps.gl_je_sources_tl s,
       apps.fnd_flex_values_vl t
where j.status='P'
and t.flex_value_set_id = 1009133
and t.flex_value = g.segment3  
and  h.actual_flag = 'A'  
and h.je_category = c.je_category_name  
and  h.je_source=s.je_source_name
and g.code_combination_id = j.code_combination_id
and j.period_name in ('Jul-16')
and h.ledger_id=326
and j.je_header_id = h.je_header_id    
and(g.segment3) = ('70050')


If somone could please help out that would be greatly appreciated

Thanks



Unanswered 88 5 / Create an account to join the discussion.
Aleksandr Shamrai
Follow / 24 Mar 2017 at 7:39am / Toad for Oracle
Latest post by on 24 Mar 2017 at 2:49pm

Team Coding and TFS Work Item Link Issue

Expand content
Hi! We are trying to sync Toad for Oracle with TFS 2015. Source control (TFVC) works fine but we can not add work item link. We got the error: "11:01:09 Error: Failed to initialize Work Item store...

Hi!

We are trying to sync Toad for Oracle with TFS 2015. Source control (TFVC) works fine but we can not add work item link.

We got the error: "11:01:09 Error: Failed to initialize Work Item store for URI: https://myserver:443/tfs/MyCollection : Failed to intiatialize Team Foundation Server URL in TFSWorkItemLin.dll"

Unanswered 53 1 / Create an account to join the discussion.
prakash.chada
Follow / 23 Mar 2017 at 3:10pm / Toad for Oracle
Latest post by on 23 Mar 2017 at 3:16pm

Getting a "There is not enough storage to run this request"...

Expand content
Oracle 11 g Linux. Running a large report in TOAD, on Windows. It gets about1.2 Mil records and gives me a message that it cannot complete the request. "There is not enough Storage to complete the...

Oracle 11 g
Linux.

Running a large report in TOAD, on Windows. It gets about1.2 Mil records and gives me a message that it cannot complete the request.
"There is not enough Storage to complete the Request"

Is TOAD using local storage to process records? On the client PC?
Or is it the storage on the server?

If it using space on the server which storage space?

Thank you

50 1 / Create an account to join the discussion.
ogden921
Follow / 23 Mar 2017 at 2:15pm / Toad for Oracle
Latest post by on 23 Mar 2017 at 2:28pm

DBA set Database Session Limit to One

Expand content
I am looking for verbiage to help our DBA understand the level of impact to our Toad users because he has set the Session Limits to One per user. While it is understandable he made this decision in order...

I am looking for verbiage to help our DBA understand the level of impact to our Toad users because he has set the Session Limits to One per user. While it is understandable he made this decision in order to secure the database. We need to make him understand how it has impacted the developers and analysts who use the Toad tool. So, I'm hoping someone with extensive knowledge of Toad can describe that impact in terms easy to understand.

Thanks in advance!! 

49 1 / Create an account to join the discussion.
bilon
Follow / 7 Feb 2017 at 1:47pm / Toad for Oracle
Latest post by on 22 Mar 2017 at 4:54pm

Stop sending me emails!

Expand content
I'm permanently getting irritating emails, despite I've turned it off in my account setting. Could you stop it!

I'm permanently getting irritating emails, despite I've turned it off in my account setting. Could you stop it!

517 13 / Create an account to join the discussion.
jtajo
Follow / 22 Mar 2017 at 5:25am / Toad for Oracle
Latest post by on 22 Mar 2017 at 4:39pm

ADDM/AWR Reports

Expand content
Hi, I am new to TOAD and have explored the ADDM/AWR . Is there a way to make this in Automation designer, so that I could get a weelky report regarding the production system. Awaiting for your...
Hi,

I am new to TOAD and have explored the ADDM/AWR . Is there a way to make this in Automation designer, so that I could get a weelky report regarding the production system.

Awaiting for your reply and thank you in advance.


Unanswered 71 1 / Create an account to join the discussion.
skontaddi
Follow / 23 Feb 2017 at 6:30pm / Toad for Oracle
Latest post by on 21 Mar 2017 at 3:39pm

Code Insight pick list in Toad 12.10.0.30

Expand content
I'm using Toad for Oracle EBS, Previous version 12.1 is much quicker in displaying the table list and its associated columns, but in 12.10 there is a delay in the drop down list to show the tables...

I'm using Toad for Oracle EBS, Previous version 12.1 is much quicker in displaying the table list and its associated columns, but in 12.10 there is a delay in the drop down list to show the tables and columns. I exported Application Data directory folder from 12.1  and imported to 12.10 to keep my Toad options as is, but still the results are same.

In 12.10 

under toad insight objects;  I selected (synonyms,tables,users and views) only.

Under Toad insight group box ; I selected Enable Code Insight Pick list, Cache code insight results, Show object types as text in pick list and delay popups as 50 milliseconds.

I heavily rely on toad for my day to day development due to slow code insight response I had to switch back to my older version. Any help is highly appreciated.

Thank you!

Unanswered 208 3 / Create an account to join the discussion.
stececco
Follow / 21 Mar 2017 at 12:13pm / Toad for Oracle
Latest post by on 21 Mar 2017 at 3:07pm

Materialized view creation with Toad wizard

Expand content
Hallo, I'm using Toad Freeware 12.10, and when I create a new materialized view from Schema Browser (Create button) the wizard window appears with the Ok Button disabled. This button remains disabled...

Hallo, I'm using Toad Freeware 12.10, and when I create a new materialized view from Schema Browser (Create button) the wizard window appears with the Ok Button disabled.

This button remains disabled even if I write the view name and I compile the Query tab with the correct query parsing done.

So actually I can create a mat.view only with a ddl script. I DON'T have the same problem with creation of a normal view or a table, the Ok button appears enabled with the wizard window.

Creation of a mat.view with a ddl script completes normally without any kind of errors.

I wait for your feedbacks please.

Thanks to all,

Steve

71 2 / Create an account to join the discussion.
bozworthy
Follow / 21 Mar 2017 at 1:54pm / Toad for Oracle
Latest post by on 21 Mar 2017 at 2:41pm

Export data

Expand content
Up until yesterday I could peridiodically Export Data to Access Database format. Today I get "driver specified in output filename does not exist". I thought maybe the MS Access app was corrupt...
Up until yesterday I could peridiodically Export Data to Access Database format. Today I get  "driver specified in output filename does not exist".  I thought maybe the MS Access app was corrupt or something as can happen.  I opened it and a component installation
process did take place. I tried again and still no go. Stopped/started Toad and no go.  Rebooted, no go. Even trying the other output formats such as Excel, XML, and Plain text give the same error.  
Please advise how I can resolve.
Unanswered 70 2 / Create an account to join the discussion.
Balajiram
Follow / 27 Feb 2017 at 8:26am / Toad for Oracle
Latest post by on 21 Mar 2017 at 12:52pm

Unable to view package list in schema brower for particular schema...

Expand content
Hi All, I am Unable to view package list in schema brower for particular schema only. While login into the schema am getting an below error. Error :- ORA-06550: line 40, column 9: PLS-00302: component...

Hi All,

I am Unable to view package list in schema brower for particular schema only.

While login into the schema am getting an below error.

Error :-

ORA-06550: line 40, column 9:
PLS-00302: component 'DBMS_APPLICATION_INFO' must be declared
ORA-06550: line 40, column 5:
PL/SQL: Statement ignored

Regards

Balaji.R

209 3 / Create an account to join the discussion.
Brian Keegan
Follow / 14 Mar 2017 at 6:38pm / Toad for Oracle
Latest post by on 20 Mar 2017 at 6:06pm

Unwanted query in generated Alter code

Expand content
Can't figure this one out on my own. Toad 12.8.0.49 Professional 64-bit w/DB Admin Module Win 7 64-bit I start the in Schema Browser, click Alter (an index), I make a change to the index. In...

Can't figure this one out on my own.

Toad 12.8.0.49 Professional 64-bit w/DB Admin Module

Win 7 64-bit

I start the in Schema Browser, click Alter (an index), I make a change to the index. In this example I renamed a partition. When the SQL code is generated, along with the RENAME query it includes an Alter Index NO INMEMMORY query. How do I get it to leave out that query?

EX:

ALTER INDEX ACTUARY.MR_RUN_TIME
 MODIFY PARTITION MRT_FUTURE_YEARS NO INMEMORY;

ALTER INDEX ACTUARY.MR_RUN_TIME
 RENAME PARTITION MRT_FUTURE_YEARS
 TO MRT_FUTURE_YEARS3;

Thank you sincerely for any assistance.

Best Regards,

 

Brian Keegan

Sr Oracle DBA

Farmers Insurance Group

Answered 156 7 / Create an account to join the discussion.
jason.camp.ctr
Follow / 17 Mar 2017 at 3:22pm / Toad for Oracle
Latest post by on 20 Mar 2017 at 2:23pm

Use Toad Code Analysis to ensure code is formatted in schema

Expand content
Is it possible to use Toad Code Analysis to ensure that all objects in a schema comply with Toad Formatting rules?

Is it possible to use Toad Code Analysis to ensure that all objects in a schema comply with Toad Formatting rules?

72 2 / Create an account to join the discussion.
Dave In Naptown
Follow / 17 Mar 2017 at 8:40pm / Toad for Oracle
Latest post by on 20 Mar 2017 at 12:34pm

Lost area above data grid...

Expand content
Hello - I'm a newbie to the forum. I'm using Toad for Oracle 12.1.0.22. I recently noticed that I no longer see the area above the data grid where I could drag a column header and group by that...

Hello - I'm a newbie to the forum. I'm using Toad for Oracle 12.1.0.22.

I recently noticed that I no longer see the area above the data grid where I could drag a column header and group by that column. Can anyone tell me how to restore that feature?

Thanks!

Answered 89 2 / Create an account to join the discussion.
sajjadnajam
Follow / 19 Mar 2017 at 10:14am / Toad for Oracle

Make Diagram Using Toad

Expand content
how can I draw database diagram using toad?
how can I draw database diagram using toad?
60 0 / Create an account to join the discussion.
S-Toad
Follow / 21 Feb 2017 at 3:51pm / Toad for Oracle
Latest post by on 15 Mar 2017 at 5:10pm

"Range check error" received while opening Toad.

Expand content
Hi, I've a Toad installation that worked for 2 weeks. Now, when I am opening the Toad for Oracle, I get the below error. Is there a fix for this? The toad version is 12.1. I can open the spotlight...

Hi,

I've a Toad installation that worked for 2 weeks. Now, when I am opening the Toad for Oracle, I get the below error. Is there a fix for this?

The toad version is 12.1. I can open the spotlight and Toad for MySQL without issues. I tried opening Toad for Oracle while the Spotlight and Toad for MySQL is running, but still is getting the same error below.

-- Attached the pic of the error.

---------------------------
EurekaLog 7.0.3.0 crash report
---------------------------
Range check error

ExceptionLog7.Init (Location: (000000000{Toad.exe }018E23F) [000000000431F23F] EModules.TEurekaModulesList.AddModuleFromFileName (Line 625, "EModules.pas") + $20)

(report generated by EDebugInfo.DebugInfoInitDoneErrorHandler)

Press Ctrl + C to copy report to clipboard
---------------------------
OK
---------------------------

309 4 / Create an account to join the discussion.