Morning Michael, ... 9.5GA seems ok when files are saved in Unix format, "\r" cannot be found, "\n" can. "\n\n" does indeed find two contiguous linefeeds. ...
True, you cannot create a tablespace without data-/tempfiles. But when you clone a database by copying the datafiles and then create a new controlfile this...
Hi, I'm hoping you someone can assist. On using the action palette, on the Misc tab, the execute script option. I created a execute script. On going to...
Does it appear in dba_tablespaces? If so, go into the SB Filter, and uncheck "Include Usage Info." That will get the tablespace listed in the SB, and from...
This works very well in 9.6. John's directions are also right on. One thing to check. If you want the entire grid selected make sure that EXPORT SELECT ROWS...
When exporting to EXCEL, the header row is patterned in grey. However, when exporting to an EXCEL instance, this does not happen. Please modify this export so...
Hello! Thanks for you response! Our computers are on a domain, so we can log into any computer on our institution. I tried to open Toad on another computer...
John / Erwin thanks for the replies: I'll try and explain what I'm trying to do. I'm trying to actually automatically(via a scheduled job) send a report...
OK, now I understand. Unfortunately, there is no way to completely automate what you are after. You can use the export dataset action to save data to an...
When you had the old version installed, where were your user files? There is an option in View-->Options-->General to specify an alternate location. Is this...
The checkbox is remembered in 9.7. The only exception is when your dataset has already fetched all rows into the grid, then it is checked. -John From:...
Thanks for the info! I'll pass it on. ... There is an option in View-->Options-->General to specify an alternate location. Is this pointing to someplace other...
Hey Norm; ... You indicate it's good when the files are saved with the Unix format selected. Could you confirm just an open tab with the Unix settings set?...
Simoneau, Roger
rsimonea@...
Oct 1, 2008 4:36 pm
44132
thanks for the reply and suggestion. CJ ... From: John Dorlon <john.dorlon@...> Subject: RE: [toad] Action Palette, Execute script To:...
I had the same problem and worked with Quest support for about a week. Opening Toad multiple times caused the folder number to increase (example 9.7(1), then...
This behavior is observed when Toad can't find registry entries that it creates in HKEY_CURRENT_USER to map the installation path to the client data path. It's...
seen those issues when the user had insufficient permission to either create or write to that folder.. chmod or chown fixed the problem.. thanks, Martin ...
Martin Gainty
mgainty@...
Oct 1, 2008 7:07 pm
44137
No, I haven't been into the registry or run any type of cleaner or optimizer against it that would remove entries. ~bp ... that it creates in HKEY_CURRENT_USER...
One of our guys here (Jeff) mentioned that he has seen cases where user's PCs were regularly wiped and reinstalled from an image. The only thing preserved was...
No, we only image new machines before they are delivered to a user. Once in place they are not scrubbed. ~bp ... user's PCs were regularly wiped and...
Morning Roger, ... Opening a package from the database results in Windows format with the "\r\n\r\n" being required to find two consecutive end of lines....
Morning all,
I'm using an Action Set to run three separate actions which run a
statement and save the results. All three actions should write to the
same...
I'm afraid I don't know. Yesterday I had one freshly cloned database still without a tempfile. I checked the "alter tablespace"-syntax by using it, and after...
John, Just created a new cloned database. The TEMP tablespace *does* appear in DBA_TABLESPACES. Your suggestion indeed worked. Unchecking "Include Usage Info"...
... Unfortunately, it can't be done in an action. At least not by command line. If you want to do it while Toad is running interactively, select 3 tables...
Hi John, ... Ok, that's a bit of a PITA, but not to worry. I know it can be done interactively, but it is three separate queries I want to extract into excel...
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.
