Ian, Great request. You are correct that the server passwords are just as critical (sometimes more so) as the Oracle passwords. Unfortunately, we're nearing...
I use the MDB often with a filter on the master table. Problem is that fubaring the filter syntax effectively locks up the MDB and the MD relationship cannot...
ok, this will be fixed next beta. The filter was being removed on ora-00904 for the master dataset, and pretty much any error on the detail datasets. This...
oh, by the way, as a workaround - after you save the relationship, you can edit the .MD file with notepad. It's an XML file. Look for the QueryText node. ......
Hello Rob, Your statement shows a "syntax error", due to 10gR2 syntax not supported by the formatter. (we're addressing that in toadbeta) Kind regards, Andre...
I feel kind of stupid asking this, but is TOAD licensed on a Per User or Per PC Basis? I looked in the Help and on the Website and the Licensing agreement ...
I have been told it is per user so that if you can prove that you are not at home and at the office at the same time you can put it on your office and home...
PER USER ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Erwin Rollauer Sent: Tuesday, October 02, 2007...
Jeff, am I correct in assuming that I can legally put Toad on my home machine also? I have not put on my home machine yet. This is not because of license ...
Hi, I am performing some testing prior to a rollout of TOAD v.9.1.0.62. Users are currently on v.8.5.3.2 and have invested a lot of time configuring their TOAD...
We are in the process of tuning a function. In reading Oracle PL/SQL Programming, Steve mentions DBMS_Profiler. I'm wondering if TOAD has a more automated...
Good morning, When we upgrades to 8.6 I was informed by Quest that is was a per seat license, and I assume nothing has changed for the 9.x client ... -- ...
per seat and per user are synonymous i believe each person using constitutes a seat if you have shift work, 8hrs, 3 people using the same pc - that requires 3...
Toad has an interface to the profiler. Enable profiling - click on the clock button next to the debug toggle on the main toolbar. Load your procedure. Execute...
Since most of your users are on 8.5 this will be a piece of cake. All you need to do is backup the "user files" directory under the 8.5 install. Install 9.x ...
I've created a synonym and it doesn't display in the schema browser. My table is in schema BASE and is called suppliers. My synonym was created in schema AIM...
Not the way the EULA reads to me. "2. Use. This License allows LICENSEE to: (a) For the number of copies purchased, use one copy of the Software on a single...
Do you see a RED filter button? That means that Toad is trying to help you by hiding synonymns that may get in your way. Click on the filter to change the...
There's nothing in the filter. i tried what you suggested and get the following Select s.owner, s.synonym_name, s.table_name, s.table_owner, s.db_link from...
I have a 6 year old version of toad. Still works, but with some unfortunate ordering problems (Table names are no longer ordered alphabetically) I have...
AIM is the synonym owner BASE is the object owner. So, in the filter dialog... In the "Synonym Owner" group box, you need to check PRIVATE. Uncheck public, or...
Not sure what the defaults are for the filter but you have to change it so it will show you what you are looking for. If you are logged in as AIM and you...
I agree with Jeff. Whenever the synonyms list does not look right, it is because of the filter. I have run into similar problems and changing the filter to ...
the usual answer is "polish", and "all the little things that aren't strictly results of sql statements". E.g. exporting to excel *directly* with nice...
Speaking only for myself... I just use Toad. It gets the job done for me. I've heard both good and bad things w/r/t Oracle SQL Developer. I don't have enough...
For a sanity check I do look at other tools or have looked at other tools and I do have SQL Developer on my machine. What I have found that Toad offers over...
Along these same lines, if I have a synonym that is owned by a table owner that does not exist, how do I get rid of it? Can I just delete it from the...
Ack! You should never attempt to edit the data dictionary. please find the nearest ruler and give youself a good whack on the knuckles even thinking such a...
Exactly what I was thinking. Never ever delete anything directly out of a SYS table. In any event you can't delete directly from DBA_SYNONYM because it is a...
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.
