thanx 4 all the help i got export via MS Access was successfull ... well .... Susanne _________________________________________ Bayer CropScience GmbH Research...
susanne.stippler@...
Apr 1, 2005 1:09 pm
26310
I created user TOAD with connect, resource, dba. I installed Space Manager Tables from the Space History tab. The TOAD_SPACEMAN package does not compile. It...
ensure you have GRANT SELECT on it..I also suggest using server side wizard to create toad schema for these modules, to ensure necessary permissions _____ ...
Thanks Mark. That was the trick. I did not create TOAD using the Server Side Wizard. Thanks a lot. ________________________________ From: Mark Lerch...
Oracle 10g Release 2 is in its third and final beta - and should release this summer ... Found my first interesting Oracle 10g Release 2 issue that will effect...
Thanks. Great info. This will break some of my scripts too. I guess it is finally time to create our own roles ;-) ________________________________ From: Bert...
I usually have to create accounts where the user should be able to create their own tables, procedures,packages, functions, views, indexes, senonyms, sequences...
Since you've so eloquently identified exactly what you want your users to have, why not create your own role and grant those privs. Because if Oracle has...
Just FYI, I have successfully exported queries to XLS that had well over 64000 rows, with no loss of data. Nigel. _____ From: John Dorlon...
Bennington, Nigel
Nigel.Bennington@...
Apr 4, 2005 12:57 pm
26318
if you guys want to keep using CONNECT, etc, the same old way, just grant privileges to CONNECT, etc right after you create your database and before you create...
One minor addition - you do not need to do this before creating users, it can be done really at anytime. The security is checked only upon connection, not user...
I was interested in finding out if there is something specific I could set in TOAD to keep the message '0.0' is not a valid time stamp from occurring. When I...
It's a problem we had with our data layer component. Its fixed for 8.5. You can expect a new release in May '05. I forget on this one, does using F5 give you...
I can sort of understand their reasoning for removing all of the "create" grants, but why on earth would they remove alter session? ... From: Bert Scalzo...
ALTER SESSION SET SORT_AREA_SIZE=1000000000; Hey, my SELECT...GROUP BYs run much faster now! :) I like the idea of giving nothing by default. If it's by...
Hi all, I have a strange problem with my client connection to an oracle database. I can connect to the database fine and work with the database ok, but if I...
Talk to your DBA(s). My guess is that either you have a timeout set in your local SQLNET.ORA file (more likely) or the profile for each of your connections on...
I've also seen a kill TOAD trigger posted on Oracle's metalink web site - I've attached the code below for peoples' amusement (because only someone at Oracle...
To go Below The Line(tm), that's half-arsed! Even *I*, with no knowledge of nearly anything Microsoft, know that the trigger can easily be circumvented by a...
I never meant to imply it was a good implementation. I merely wanted to share an interesting find with the rest of TOAD land. To think of all the real problems...
... except, of course, the Oracle employees that USE Toad. :-) ... From: Bert Scalzo [mailto:bert.scalzo@...] Sent: Tuesday, April 05, 2005 3:08 PM To:...
Considering I've been using TOAD beta to debug several problems in Oracle's 10g EM Grid Control (I'm not so cranky today), I'd imagine there's at least some...
I can certainly understand having an onlogon trigger to kill sessions created from programs other than a desiginated application. So for instance, if you have...
Funny you should say this. I just went to an "Oracle Technology Day" presentation yesterday. Primary focus was grid computing, but they also showed off the...
hi all... when i create themes on ctxsys scheme i found error. my syntax is : begin ctx_doc.themes('dlsdocuments_idx','3','tes_ctx_themes',1,full_themes => ...
Dls
delis@...
Apr 6, 2005 1:27 pm
26335
That last sentence is nice :) By the way, we intend to address new technologies like XML DB, HTML DB, Xquery, Xpath, etc ... Bert ... From: Nibeck Mike...
I have 3 packages 2 of which populate data into GLOBAL TEMP tables. The 3rd package does an insert to a table via a insert...select from these global temp...
Starting QSR gives the following message : failed to create empty document. Using windows 2000 , service pack 3. Within file drwtsn32 there is errorcode...
I had the same problem recently.. One of the DLL's it uses is out of sync with it apparently, though I don't know which one.. I ended up replacing about half 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.
