Morning Jim, As far as I remember, you cannot use bind variables for table names, index names, partition names - in fact, any object name - you can only use...
Hi Norm, Thanks for the response. This brings me back to the question, What do I really need to track and why? I think that once I figure that out, the rest...
Dear all, I've noticed an increasing difference beween the time response of the Browser window and the Editor window. If I click on Data in the Browser window...
Finally it's on the news (CNN). Here's the URL: http://www.cnn.com/2006/TECH/internet/01/31/kamasutraworm/index.html Gio ... looking ... Online ... Of ... is ...
Hai May I know is there any way of running profiler for runtime application? For ex. My application is running on server. What all queries fired at run time of...
click the filter button on the right hand side of the schema browser, data tab. It looks like a funnel. You have a filter or a sort set for that table,...
Also check that you do not have the "sort by Primary Key" checkbox checked. It is on the data tab down from the filter icon. That could slow things down on ...
I think I noticed an option (while surfing through the options) which in effect said "show data in primary key order". Try turning that off to see if it makes...
In a case like this one should always execute the query via SQL*Plus so that you can confirm if it is an Oracle problem, or a Toad problem or a programmer...
One of my users reported the following problem. I have duplicated it and can give more details. When the schema browser is first displayed, you have the...
You are good. I know that you can't replace parts of a SELECT like table name or column names with text strings. So often I have been forced to use EXECUTE...
Just as additional information. The limitation of using a bind variable to represent an Object is an Oracle limitation, not a Toad limitation. I'd personally...
rsimonea@...
Feb 1, 2006 6:18 pm
31102
Good Morning; As far as "runtime" is concerned, are you refering to a compiled executable such as Toad.exe? If so, you'd have to modify that application to...
rsimonea@...
Feb 1, 2006 6:28 pm
31103
1. Potential Bug: If I specify a file name in the file area... It doesn't appear to go to the default directory specified if I click on the "..." button. As a...
as easy way to get #2, if you have the "sort by primary key" in sb-tables-data, is to use the "save as" screen instead. will check on #1 when I get a chance. ...
Okay... you asked for it <smile> I'm running on TOAD 8.5.3.2: * If I specify "Save As" from the Detail Data panel (right side), I get an error message stating...
From the right side - I think it wants you to put the schema and table name in where it says "insert schema" and "insert table". If there is an "auto" button...
I have 10g and 9i on same server and is there a link to the best practises for setting up the listeners so that port 1521 (preferably single port for both) is...
... [Erwin Rollauer] I think the above statement from Norm is important. Saying something (even if wrong) is better than saying nothing. If what you say is...
Hello Vikas, you need only one Listener for all db instances. You should use the newest one (10g). You can create a separate directory for listener.ora,...
Ronald Breuer
rb@...
Feb 2, 2006 2:52 pm
31113
Greetings my fellow TOADsters, Oracle - 9.2.0.6 TOAD - 8.6.0.38 I have had my DBA run profload.sql and the dbms_profiler is now set up. execute permission has...
And greetings to you too, Abhijeet : I assume that you have a procedure named 'showemps' to actually run ? If so, then for some reason, Oracle cannot find it....
Now then Erwin, <QUOTE> ... [Erwin Rollauer] I think the above statement from Norm is important. Saying something (even if wrong) is better than saying...
Hello I'm using Toad 8.6.0.38. Oracle db version: 9.2.0.6.0 When I run "All rules by ..." review on a package, I get an error "9.2 is not a valid floating...
Tomas Straupis
tomasstraupis@...
Feb 2, 2006 3:55 pm
31117
Not always so. If you have 8i and 9i DBs on the same box, there will be problems with only a 9i listener. The older databases will attempt to register with...
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.
