I saw Norman's post last Friday for a different issue offer this for 9i: DVBMS_STATS.GATHER_SCHEMA_STATS('SYS'); If this works let us know so we can update...
Mark, dunno if that was your typo or mine (I'll take the blame though!), it should be : DBMS_STATS.GATHER_SCHEMA_STATS('SYS'); and only for 9i and above. ...
Whilst type in sql editor, auto complete works after typing the table name. Is there a way to get it to autocomplete or in other bring up a list after a delay...
Ellison, David
david.ellison@...
Sep 7, 2006 12:42 pm
33848
I would like to have easy configure to be able o connect toad to oracle database. Thank you....
... Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. Yahoo! Messenger with Voice. Make PC-to-Phone Calls...
See http://support.quest.com/eSupport/Solution.asp?WAid=268459528&itemID=15631 As an essence: To use SQL Tuner, you have to buy a special TOAD option called...
i am develop form n i am using form builder. then i running this form but have some error. the message error is FRM-40735: ON-ERROR trigger raised unhandled...
enike nikawati
enike.nikawati@...
Sep 7, 2006 12:43 pm
33854
Hi, I want to sql command,sql*plus command,isql*plus command.And what's difference betweeen these commands. what's useage of substitution variable in...
Hi, I have same problem on Oracle 9.2 database. What can be done there ? David ... Od:Mark.Lerch@... Komu:<toad@yahoogroups.com> Datum:04/11/06 3:03 odp....
David Krotil
david.krotil@...
Sep 7, 2006 12:44 pm
33856
Hi Norman and Mark, I gathered stats with below command, it ended successfuly, but no change on Database Probe. I´m waiting now 10 minutes and still get...
David Krotil
david.krotil@...
Sep 7, 2006 12:44 pm
33857
Does that mean that SQL Tuner is available in Standard? ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of ...
Ellison, David
david.ellison@...
Sep 7, 2006 12:45 pm
33858
Hi, In TOAD SUITE, there is a tool called Benchmark Factory, in that i just want to know, in what basis performance of database has calculated. when you look...
Hi all, I have been using both Oracle9i and Oracle 10g. In TOAD's TNSnames Editor i have added the both tnsnames.ora file. Now i could work with both version....
Hi all, When we write SQL statement(after typing table name and dot symbol), popup window will appear and it show all the attribute of the table what you have...
Hi all, By using TOAD, i want to create table which includes TIMESTAMP datatype. But in the list i could't find TIMESTAMP datatype. I am using TOAD 8.6.1 and...
Thanks for oyur response. the thing is that I do not see a first tab in the SQL editor. I see it in the procedure editor but not in the SQL editor. Thanks, ...
Neelam Thakur
thakur_neelam@...
Sep 7, 2006 12:51 pm
33864
The tool will show you the actual performance metrics as your benchmark test is being ran. When its finished it will show you reports for the test scenario....
ORA-06508: PL/SQL: could not find program unit being called I would recheck what object you are calling from your form to make sure you can see it and it is...
David, what version of Toad are you running? Next, are the queries being displayed in the status bar of the window while it is running (I don't recall when I...
I would start looking for your answers to your questions on this site http://www.oracle.com. There is a wealth of documentation and demo's on there to keep...
Toad only allows you to work with one Oracle Home. Once you connect with one oracle home you cannot connect using another Oracle Home. What issue do you have...
Look in your Options under Editors-->"Toad Insight" - Delay pop-up. Increase the delay time to 2000 which is the max. That is 2 seconds. So that means if ...
Please read the FAQ: http://asktoad.com/DWiki/doku.php/faq/answers/datagrid#how_can_i_see_timestamp_and_interval_data ... From: toad@yahoogroups.com on behalf...
unless some users are getting errors about not being able to create (or extend) temp segments, I wouldn't worry about it. If you are getting messages like...
Toad 9 will allow you to connect with the Easy Config format. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of oikhleif Sent: Thursday,...
also go to options -> datatypes and make sure "include timestamp/interval datatypes" is checked. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
