James It has been a while since we discussed this, but I recently downloaded the TOAD 9 beta and the JDWP debugger looks like it works just fine. I think I'll...
Hi All, When you do tunning, it does optimization. I just want to know whether it is cost based optimization or rule based optimization. Can we change the...
Hi all, As per your instruction, I compiled my procedure, but still it's showing the same error. ORA-04068: existing state of package has been discarded ...
Ditto on that thought Dan If your tasked to write alot of procs it certainly provides alot of features to make the task easier and more efficient The easy...
Martin Gainty
mgainty@...
Jun 1, 2006 12:44 pm
32910
Greetings, I need to move about 10,000,000 rows from one schema.table to another in the same database. It will be all records with a date prior to 1/1/2005. ...
In the same database, the fastest way to do this would be insert into <destination table> select * from <source table> where .... You can right-click a table...
As a note: you should be able to accomplish it in Toad or SQL/Plus equally. Depending on your circumstances one of the following may work. A) Scenario: Most of...
rsimonea@...
Jun 2, 2006 12:45 pm
32914
James John has already suggested using an insert statement. This will work as long as none of the records you're moving already exist in your destination ...
McAllister Michael Co...
Michael.McAllister.ct...
Jun 2, 2006 12:45 pm
32915
I would think that the more you do in the cursor so as to reduce the rows returned the better. Erwin Rollauer, ISR, McGill, 514 398-5023 ex 00626 ...
Second reply - the first seems to have gone missing :o( ... Ok, login to TOAD as user scott (or the owner of the package) and : run up the schema browser ...
Hello, Its friday I have a keyboard problem in TOAD (8.6) My keyboard works totally fine in Word and Excel. In the SQL Editor all my keys work except for :...
Your first stop - www.AskToad.com Enter "keys" into the Search box. Get results. It's Friday. The backspace, up, and down arrow keys don't work in my TOAD....
Morning Mark, ... I've been over to AskTOAD to update the above FAQ - it's a wee bit out of date for 8.0 as there are now lots of parsers whereas 7.5 only had ...
Hi all, Can you please tell me the comparision of TOAD tuning with OEM tuning? I want to know which one is best. Thanks in advance. Regards Vetrivel...
Hi, Thanks for your mail. It is working fine when i login to TOAD User. But it is not working for SCOTT user. Please let me know what i have to do to work with...
Hi All, Can you please let me know how do change the instance from rule based optimization to cost based optimization.I am keenly expecting your mail. Regards ...
Hi all, By Using TOAD I can tune my sql Statement. But I need to tune my stored procedure.Is there any feature to do this?. Second thing I have combination of...
toad's code xpert feature will scan code for many things - including ineffficient SQL ... From: toad@yahoogroups.com on behalf of vvetri74 Sent: Fri 6/2/2006...
My MySQL database was written as... schema_name.TABLE_NAME In TOAD's SQL Modeler, it always writes the SQL as... schema_name.table_name. Problems... 1) I can...
Try the MySQL group. Here's info on how to subscribe: http://www.toadsoft.com/maillist.htm ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On...
Good Morning Vetrivel- There are a series of steps you must perform in order to achieve the optimisation goal more specifically 1)set optimizer_mode parameter....
Martin Gainty
mgainty@...
Jun 5, 2006 5:44 pm
32928
For some reason today, even though I've changed no options, my TAB key is acting strangely in the Editor. All I want it to do is insert 4 spaces every time I...
You can also use Toad's Profiler functionality to check how well your stored program is performing. ... From: Bert Scalzo [mailto:toad@yahoogroups.com] On...
Patrick McGrath
Patrick.mcgrath@...
Jun 5, 2006 5:47 pm
32930
I have just started using TOAD for debugging and need some help. The user enters two variables in a procedure. I need to track those variables as they change...
I have a question regarding the reports that CodeXpert generates - particuarily the CRUD matrix. I have a package with some select statements that join tables,...
My TAB key, too! Haven't yet recognized a pattern, but it sure doesn't tab to the same place every time. :-( Dan -- Dan Madvig dbm at nwc dot edu...
DBMadvig@...
Jun 5, 2006 9:21 pm
32933
Morning all, ... Some of these may not be suitable for some versions of Oracle, so beware, and check the docs for your version before changing them. ... most ...
Dear Vetrivel, if u want Stored Procedure Tuning , This is auto In 10 g OEM. Nitin Varshney ... -- Nitin Varshney..... Keep In Contact...... Cal me at :...
Version: 8.6.0.38 Options: DBA + Tuning Problem: All of a sudden each time I restart Toad - pressing F8 - all my old SQL's are gone - the history has been...
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.
