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...
31089
Booth.Steve
stevebooth8739
Feb 1, 2006 1:20 pm
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...
31090
Karen Wright
karenmhwright
Feb 1, 2006 1:38 pm
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...
31091
Giovanni Jaramillo
jaramill99
Feb 1, 2006 1:38 pm
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 ...
31092
vvetri74
Feb 1, 2006 1:42 pm
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...
31093
John Dorlon
jdorlon3
Feb 1, 2006 2:23 pm
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,...
31094
Ed Klinger
eklinger
Feb 1, 2006 2:36 pm
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 ...
31095
Erwin Rollauer
erwinrollauer
Feb 1, 2006 4:30 pm
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...
31096
Erwin Rollauer
erwinrollauer
Feb 1, 2006 4:30 pm
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...
31097
REED-D-A@...
dareed51
Feb 1, 2006 4:31 pm
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...
31100
Adamski, Jim
adamskijl
Feb 1, 2006 4:36 pm
OK! Seems a pity though! Jim Adamski Bothell Office: (425) 288.7913 -*New Mobile Office: (425) 501.0391 -*New E-mail: mailto:jim.adamski@... ......
31101
rsimonea@...
Feb 1, 2006 6:18 pm
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...
31102
rsimonea@...
Feb 1, 2006 6:28 pm
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...
31103
Booth.Steve
stevebooth8739
Feb 1, 2006 8:18 pm
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...
31104
John Dorlon
jdorlon3
Feb 1, 2006 8:24 pm
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. ...
31105
Booth.Steve
stevebooth8739
Feb 1, 2006 8:59 pm
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...
31106
John Dorlon
jdorlon3
Feb 1, 2006 9:15 pm
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...
31107
Norman Dunbar
normandunbar
Feb 2, 2006 8:38 am
Morning Jim, dunno if these are any help - or just insulting your intelligence ! http://www.jlcomp.demon.co.uk/faq/variable.html ...
31108
Norman Dunbar
normandunbar
Feb 2, 2006 8:41 am
Morning Erwin, Norman Dunbar. Contract Oracle DBA. Rivers House, Leeds. Internal : 7 28 2051 External : 0113 231 2051 ... Thanks for the compliment. I'm afraid...
31109
Vikas Gautam
vgautam_99
Feb 2, 2006 1:35 pm
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...
31110
Norman Dunbar
normandunbar
Feb 2, 2006 2:42 pm
Afternoon Vikas, Norman Dunbar. Contract Oracle DBA. Rivers House, Leeds. Internal : 7 28 2051 External : 0113 231 2051 ... practises ... port for ... I don't...
31111
Erwin Rollauer
erwinrollauer
Feb 2, 2006 2:52 pm
... [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...
31112
Ronald Breuer
rb@...
Feb 2, 2006 2:52 pm
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,...
31113
Nikte, Abhijeet S. ...
anikte
Feb 2, 2006 3:32 pm
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...
31114
Norman Dunbar
normandunbar
Feb 2, 2006 3:46 pm
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....
31115
Norman Dunbar
normandunbar
Feb 2, 2006 3:47 pm
Now then Erwin, <QUOTE> ... [Erwin Rollauer] I think the above statement from Norm is important. Saying something (even if wrong) is better than saying...
31116
Tomas Straupis
tomasstraupis@...
Feb 2, 2006 3:55 pm
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...
31117
Jesse, Rich
r2qti
Feb 2, 2006 4:51 pm
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...
