Just got this question from another user - why does it generate everything BUT the Create Database command? Things like the CHARSET and Database name are...
54259
Dunbar, Norman (Capge...
normandunbar
Jan 5, 2011 2:28 pm
Hi Jeff, ... everything BUT the Create Database command? I can't help with that one, but the attached might help? Run as SYS. One thing to beware of, I have an...
54260
Jeff Smith
toaddev
Jan 5, 2011 2:35 pm
They were using alter database backup controlfile to trace I showed them the 'Toad Way' and they loved the flexibility with the options, so it's all good. Like...
54261
John Dorlon
jdorlon...
Jan 5, 2011 2:49 pm
I think the reason was that I couldn't find everything I needed in the data dictionary. It's been a while since I did that though, maybe it's time to revisit...
54262
Norman Dunbar
normandunbar
Jan 5, 2011 3:06 pm
Afternoon Jeff, ... That works fine too! It may not be the easiest way to do it though, but useful on Toad-Free sites! ... Now you didn't think I wrote it...
54263
Jeff Smith
toaddev
Jan 5, 2011 3:07 pm
I'm guessing a lot of folks don't have privs to run an ALTER DATABASE, so the script comes in handy! ... From: toad@yahoogroups.com...
54264
Bartlett, Frederick H...
fhbartlett
Jan 5, 2011 5:14 pm
Hi! Just upgraded from a much older version (8.6) and find that pick lists no longer work. What's changed? I've selected every option in View | Toad Options......
54265
Michael Staszewski
mstaszew
Jan 5, 2011 5:18 pm
You can try closing Toad and renaming your User Files\Aliases.txt file and restarting Toad to see if there is some funk in there. This is what I see. As long...
54266
Rich Jesse
r2qti
Jan 5, 2011 5:20 pm
... Perhaps, but I'd question the practice/need of those without privs reverse-engineering the CREATE DATABASE statement. Just sayin'... Rich -- [TeamT] ...
54267
Jeff Smith
toaddev
Jan 5, 2011 5:21 pm
This came from a developer who owned his instance...so def not a standard practice I think. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf...
54268
marc.lafontaine_031
toadoraclebeta
Jan 5, 2011 6:01 pm
Message from: marc.lafontaine_031 Hi, I've got a SELECT statement and I clicked on OPTIMIZE SQL. The Optimize window opens and the Optimizer does it's...
54269
Zarzycki, Michael
mz_161
Jan 5, 2011 6:05 pm
I had the same problem. Try prefacing the table name with the schema. That worked for me, even though the synonym is valid. Select * from myschema.mytable t...
54270
Michael Staszewski
mstaszew
Jan 5, 2011 6:11 pm
In View|Options|Editor|Code Assist there is a tree where you can check the object types to be shown. Public Synonyms are unchecked by default. Have you...
54271
Jeff Smith
toaddev
Jan 5, 2011 6:14 pm
Did you press the rewrite or generate indexes button? It doesn't really do its thing until you hit one of those buttons. From: toad@yahoogroups.com...
54272
Michael Staszewski
mstaszew
Jan 5, 2011 6:14 pm
Which of the various optimizers are you using? There are 3 ways for you to optimize from Toad. Are you using the button to optimize current SQL? This method...
54273
marc.lafontaine_031
toadoraclebeta
Jan 5, 2011 6:34 pm
Message from: marc.lafontaine_031 Hi, This is how I use it, look at the files... Thanks, Marc _______________________________________ Historical Messages ...
54274
Jeff Smith
toaddev
Jan 5, 2011 6:38 pm
Click in the SQL Text field Then click on the 'Optimize' button. FYI - you're on an older version, so you may want to upgrade if that's available to you. From:...
54275
Zarzycki, Michael
mz_161
Jan 5, 2011 6:39 pm
Thanks, Michael. You are correct. The "Synonyms"; check box was off in the dialog. Turning it on eliminated the need to preface the table with the schema name....
54276
Bartlett, Frederick H...
fhbartlett
Jan 5, 2011 7:36 pm
I tried Michael Staszewksi's trick and removed my ALIASES.TXT file. That worked. Once. Now, nothing. Both 'Synonyms' and 'Public Synonyms' are checked. What...
54277
Michael Staszewski
mstaszew
Jan 5, 2011 7:44 pm
We'll need some very specific steps to reproduce. I can't reproduce this so a full description of exactly what you are doing and what the objects are will...
54278
Zarzycki, Michael
mz_161
Jan 5, 2011 7:46 pm
Does it work if you preface the table name with the alias? Best regards, Mike Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies, Inc....
54279
Zarzycki, Michael
mz_161
Jan 5, 2011 7:46 pm
Sorry, meant to say does it work if you preface the table name with the schema in which it belongs? Best regards, Mike Michael S. Zarzycki, MTS | Manager of...
54280
Bartlett, Frederick H...
fhbartlett
Jan 5, 2011 7:49 pm
Thanks! I'll do that. Not right away, I'm afraid, but Real Soon Now. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Michael Staszewski ...
54281
Michael Staszewski
mstaszew
Jan 5, 2011 7:51 pm
That's fine, take your time. Also, a first step may be to try this. In the Code Assist options there is an option to cache the results. Uncheck that and try....
54282
Bartlett, Frederick H...
fhbartlett
Jan 5, 2011 7:54 pm
No, it doesn't; I did try your suggestion as well. If you continue interested, I'll be posting a more complete description of the problem in the next day or...
54283
Michael Staszewski
mstaszew
Jan 5, 2011 8:03 pm
Please post what you have when you have time. Thanks, Michael From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bartlett, Frederick H. -...
54284
Pluim, Dick
pluim003
Jan 6, 2011 11:00 am
Hi, A while ago there was a problem with Toad and McAfee (with 10.5.1 if I'm not mistaken). This morning at our office, 'all' Toad-versions (confirmed with...
54285
Pete
real_fetchboy
Jan 6, 2011 2:32 pm
Ah, that explains it. I'm seeing the same thing this morning too. Will have to notify our systems support people. Anyone know why this is suddenly a problem? -...
54286
Bert Scalzo
bert.scalzo
Jan 6, 2011 2:35 pm
McAfee is supposed to be placing a support article on their site on why this happens and what to do. The problem is on their end. It’s very possible that...
54287
Pluim, Dick
pluim003
Jan 6, 2011 2:57 pm
________________________________ From: Pluim, Dick Sent: donderdag 6 januari 2011 12:54 To: 'toadbeta@yahoogroups.com' Subject: RE: [toadbeta] Toad and McAfee...
