RE: Opinions sought on possible TOAD replacement
Many thanks to everyone who responded! Looks like the outcome will be PL/SQL Developer licenses for our developers, while I get to keep my Toad Xpert / DBA module. Thanks again for the useful insights! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
Paul, I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs, packages and it's fine including a well featured de-bugger. I believe that a site licence costs $3,000. As to it being a DBA tool I'd have to say it's not in the same league as TOAD Xpert with DBA module. Chris Dunscombe Accenture Worthing Unit Internal: 71-3558 External: 01903-283558 Email: [EMAIL PROTECTED] -Original Message- Sent: 15 October 2003 16:59 To: Multiple recipients of list ORACLE-L Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Opinions sought on possible TOAD replacement
Hi, I'll second Chris' statement. I found PL/SQL Developer to be a great and inexpensive PL/SQL development tool. Its debugger is especially good. In fact from a development perspective I found it to be far superior to TOAD. Have no idea about support and consideration of user suggestions as I had no issues to report. However as its name suggests it is purely a PL/SQL development tool and not an administration tool, but then I don't think its trying to be the latter. Would recommend you stick with TOAD for administration, I don't know of anything else significantly cheaper out there to replace TOAD and any small licensing savings will be lost to lower productivity during the learning curve anyway. Regards, Mark. From: Dunscombe, Chris [EMAIL PROTECTED] Date: Thu, 16 Oct 2003 07:50:30 +0100 Subject: RE: Opinions sought on possible TOAD replacement Paul, I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs, packages and it's fine including a well featured de-bugger. I believe that a site licence costs $3,000. As to it being a DBA tool I'd have to say it's not in the same league as TOAD Xpert with DBA module. Chris Dunscombe Accenture Worthing Unit Internal: 71-3558 External: 01903-283558 Email: [EMAIL PROTECTED] -Original Message- Sent: 15 October 2003 16:59 To: Multiple recipients of list ORACLE-L Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Opinions sought on possible TOAD replacement
Title: Message We do something similar here. Developers gets Golden (from Benthic). Which has a nice little PL/SQL Editor and SQL spreadsheet. DBAs get TOAD. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message-From: Rich Gesler [mailto:[EMAIL PROTECTED] Sent: 2003-10-15 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement You are correct in that it is very developer centric. As far, as hidden charms...I'd have to say the Reports capabilities. You can easily incorporate your DBA scripts into this little tool. Still not as good as TOAD (or even TORA) for a DBA but a nice, cheap addition to the arsenal. Download it and give it a try, Rich -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul VincentSent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
Title: Message FYI... Golden is a query tool (and a damn good one)... In my opinion, it's what SQL Worksheet should be... Simple to use and fast... The PL/SQL editor from Benthicis separate tool called PLEdit... It's ok but not great... Like Golden it is quick and simple... But, if you are looking for advanced functionality then I would definitely go with another solution... I took a peek at PL/SQL Developer a few months agoand thought it was a nice tool... Especially for the price... That being said, I use PLEdit for my own use...I buy my own tools and don't do enough to justify the cost... Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 3:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement We do something similar here. Developers gets Golden (from Benthic). Which has a nice little PL/SQL Editor and SQL spreadsheet. DBAs get TOAD. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message-From: Rich Gesler [mailto:[EMAIL PROTECTED] Sent: 2003-10-15 1:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Opinions sought on possible TOAD replacement You are correct in that it is very developer centric. As far, as hidden charms...I'd have to say the Reports capabilities. You can easily incorporate your DBA scripts into this little tool. Still not as good as TOAD (or even TORA) for a DBA but a nice, cheap addition to the arsenal. Download it and give it a try, Rich -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul VincentSent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k A procedure return with no errors Priceless g FWIW for a nice sql editor golden is nice. Others on this list sold me on that bob Paul Vincent [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 08:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
I forgot to include years of troubleshooting and debugging experience the techniques to go with it. :) Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 01:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Opinions sought on possible TOAD replacement TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k A procedure return with no errors Priceless g FWIW for a nice sql editor golden is nice. Others on this list sold me on that bob Paul Vincent [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 08:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
Title: Message Management wants to standardize to a single tool for support and maintenance purposes. At least that's the story here. I have heard good things about PL/SQL Developer. If it's an option, you could checkout TOra (http://www.globecom.se/tora/) which is comparable to TOAD and $100 a license on Windows. This option offers some middle ground anyway. -Original Message-From: Paul Vincent [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
You are correct in that it is very developer centric. As far, as hidden charms...I'd have to say the Reports capabilities. You can easily incorporate your DBA scripts into this little tool. Still not as good as TOAD (or even TORA) for a DBA but a nice, cheap addition to the arsenal. Download it and give it a try, Rich -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul VincentSent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
You may also want to consider OraEdit Pro by DKG Advanced Solutions Inc. (www.dkgas.com) Shamita Shamita Singh Mohawk College Hamilton, Ontario --- Rich Gesler [EMAIL PROTECTED] wrote: You are correct in that it is very developer centric. As far, as hidden charms...I'd have to say the Reports capabilities. You can easily incorporate your DBA scripts into this little tool. Still not as good as TOAD (or even TORA) for a DBA but a nice, cheap addition to the arsenal. Download it and give it a try, Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Vincent Sent: Wednesday, October 15, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England = Shamita __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shamita Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Opinions sought on possible TOAD replacement
Have you looked at Toolkit for Oracle (TOra)? http://sourceforge.net/projects/tora/ I've heard rather good things about it. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Paul Vincent [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
RE: Opinions sought on possible TOAD replacement
TORA -Original Message-From: Paul Vincent [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying "fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!". But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
Re: Opinions sought on possible TOAD replacement
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k Jared Paul Vincent [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 08:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Opinions sought on possible TOAD replacement Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink Corporation at $150 a pop). Now, I've been to the product website, and read up on all its features, and it basically looks like a nice enough product, but aimed squarely at PL/SQL developers, rather than including all the DBA-oriented goodies we find in TOAD. My first reaction is to respond by saying fine, give it to the developers to replace their copies of TOAD, if they find it adequate for development, but it's not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very much!. But if anyone on the list has tried both products, I'd be interested to know what you think. Is it as usable as TOAD Professional for developers? Does it have hidden charms which would make it a suitable replacement for DBA use? How responsive are the product developers to requests for enhancements? Any input is very welcome! Paul Vincent DBA University of Central England
toad on linux
Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: toad on linux
Tora. You can get a copy for Linux free of charge, although the Windoze version has a commercial license charge. For more info: http://www.globecom.se/tora/ For the Linux/Oracle 9 rpm: http://prdownloads.sourceforge.net/tora/tora-1.2.4-1oracle9.i686.rpm HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 03 October 2003 17:24 To: Multiple recipients of list ORACLE-L Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: toad on linux
Title: RE: toad on linux TORA you'll love it. search on sourceforge.net ... Raj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 03, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Subject: toad on linux Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: toad on linux
Bill. There is a TOAD like producty called TORA that runs on linux. Google for it and download the tar file. The new EM 4.0 ( due out with 10G) is suppose to be browser based allowing you to run it from and os browser. Ron [EMAIL PROTECTED] 10/03/03 12:24PM Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: toad on linux
Tora http://www.globecom.se/tora Works great. On Fri, 2003-10-03 at 11:24, [EMAIL PROTECTED] wrote: Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: toad on linux
I agree that TOra (http://www.globecom.se/tora/) is a fine program and the best Linux alternative to TOAD, but it still lacks a lot of the spit-n-polish of TOAD that makes it more usable to me. Try it out and see. And after further review, the Bears still suck... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Subject: toad on linux Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs. SQL Navigator
I'm a dedicated TOAD user, so would steer you in that direction. We used SQL Navigator years ago, before we moved to TOAD. SQL Navigator is not a bad product; and I haven't kept up on the new releases. I'm sure it's grown a lot since I last used it. But overall, I just prefer TOAD's user interface and way of doing things. TOAD has a very active and dedicated user community, and a beta program that's open to any registered TOAD owner. If you suggest a new feature in the beta program, it may literally appear in the next beta version (released twice a week). All of TOAD's developers are active participants on the list. TOAD is very much a user-driven product. (I don't see any equivalent activity for SQL Navigator.) But it should be easy to decide for yourself. Both TOAD and SQL Navigator have fully-functional limited-time demos available on their web site (www.quest.com). Download them both and have at it! Dave -Original Message- From: Gorden-Ozgul, Patricia E [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 10:30 PM To: Multiple recipients of list ORACLE-L Subject: TOAD vs. SQL Navigator I'm looking for information about the differences between Quest's TOAD and SQL Navigator. Specifically, which would be better for an Oracle web application developer. I am more interested in development features; I am less interested in the DBA functions, although they are nice to have. Any information would be helpful to me in making an educated choice. Thanks. Patricia Gorden-Ozgul [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gorden-Ozgul, Patricia E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs. SQL Navigator
Just a brief word to everyone who took the time to provide their 2-cents. Thank you. Pat Gorden-Ozgul -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 2:24 PM To: Multiple recipients of list ORACLE-L I'm a dedicated TOAD user, so would steer you in that direction. We used SQL Navigator years ago, before we moved to TOAD. SQL Navigator is not a bad product; and I haven't kept up on the new releases. I'm sure it's grown a lot since I last used it. But overall, I just prefer TOAD's user interface and way of doing things. TOAD has a very active and dedicated user community, and a beta program that's open to any registered TOAD owner. If you suggest a new feature in the beta program, it may literally appear in the next beta version (released twice a week). All of TOAD's developers are active participants on the list. TOAD is very much a user-driven product. (I don't see any equivalent activity for SQL Navigator.) But it should be easy to decide for yourself. Both TOAD and SQL Navigator have fully-functional limited-time demos available on their web site (www.quest.com). Download them both and have at it! Dave -Original Message- From: Gorden-Ozgul, Patricia E [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 10:30 PM To: Multiple recipients of list ORACLE-L Subject: TOAD vs. SQL Navigator I'm looking for information about the differences between Quest's TOAD and SQL Navigator. Specifically, which would be better for an Oracle web application developer. I am more interested in development features; I am less interested in the DBA functions, although they are nice to have. Any information would be helpful to me in making an educated choice. Thanks. Patricia Gorden-Ozgul [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gorden-Ozgul, Patricia E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gorden-Ozgul, Patricia E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
Jared, Snip from my original post However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. /Snip from my original post The question is, is it TOAD that uses the LAST_HOME entry, or is it Oracle itself? TOAD documentation suggests it's Oracle. Reading LAST_HOME entry to decide which version of SQLNet to use just doesn't sound right (can't see any logic). I think DEFAULT_HOME setting should always be used. I read note Note:73963.1 regarding this but it doesn't mention this behaviour. Maybe I will look for a higher version of TOAD and see how it goes. Regards, Charu. -Original Message- Behalf Of Jared Still Sent: Thursday, July 31, 2003 9:02 PM To: Multiple recipients of list ORACLE-L You may find it easier to just run the Oracle Home Selector that appears in the Startup-Programs-Oracle Installation Products menu. It has the benefit of also modifying the PATH variable. Jared On Thu, 2003-07-31 at 07:54, Charu Joshi wrote: RE: ORA-03115 (TOAD question!!)Hi, It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation and found out this piece of information: ** When Oracle connects, it will look in ALL_HOMES for the LAST_HOME value, which in this case is zero 0. It appends zero to HOME to produce HOME0, then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME value. ** I modified the LAST_HOME key to point to the 8i HOME and restarted TOAD and was able to query CLOBs successfully. Thanks a lot!! Best wishes, Charu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jamadagni, Rajendra Sent: Tuesday, July 29, 2003 8:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ORA-03115 (TOAD question!!)
Sorry, I must have been shooting from the hip. Not taking enough time to read more carefully. The LAST_HOME is likely being read by TOAD. Could be that TOAD stores the Oracle home it was last initialized with, compares it to the current on on subsequent startups, and tries to revert by using LAST_HOME. Take a look at any ini files or TOAD registry entries. Jared On Fri, 2003-08-01 at 02:09, Charu Joshi wrote: Jared, Snip from my original post However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. /Snip from my original post The question is, is it TOAD that uses the LAST_HOME entry, or is it Oracle itself? TOAD documentation suggests it's Oracle. Reading LAST_HOME entry to decide which version of SQLNet to use just doesn't sound right (can't see any logic). I think DEFAULT_HOME setting should always be used. I read note Note:73963.1 regarding this but it doesn't mention this behaviour. Maybe I will look for a higher version of TOAD and see how it goes. Regards, Charu. -Original Message- Behalf Of Jared Still Sent: Thursday, July 31, 2003 9:02 PM To: Multiple recipients of list ORACLE-L You may find it easier to just run the Oracle Home Selector that appears in the Startup-Programs-Oracle Installation Products menu. It has the benefit of also modifying the PATH variable. Jared On Thu, 2003-07-31 at 07:54, Charu Joshi wrote: RE: ORA-03115 (TOAD question!!)Hi, It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation and found out this piece of information: ** When Oracle connects, it will look in ALL_HOMES for the LAST_HOME value, which in this case is zero 0. It appends zero to HOME to produce HOME0, then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME value. ** I modified the LAST_HOME key to point to the 8i HOME and restarted TOAD and was able to query CLOBs successfully. Thanks a lot!! Best wishes, Charu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jamadagni, Rajendra Sent: Tuesday, July 29, 2003 8:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message
RE: ORA-03115 (TOAD question!!)
rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
Where can we get a list of the bugs in freeware TOAD? Patrice. -Original Message- Sent: Thursday, July 31, 2003 10:50 AM To: Multiple recipients of list ORACLE-L rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
http://www.toadsoft.com I still think that the freeware version is excellent, just lacking in some features found in v7. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) Where can we get a list of the bugs in freeware TOAD? Patrice. -Original Message- Sent: Thursday, July 31, 2003 10:50 AM To: Multiple recipients of list ORACLE-L rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
Title: RE: ORA-03115 (TOAD question!!) Hi, It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation and found out this piece of information: ** When Oracle connects, it will look in ALL_HOMES for the "LAST_HOME" value, which in this case is zero "0". It appends zero to "HOME" to produce "HOME0", then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME value. ** I modified the LAST_HOME key to point tothe 8i HOME and restarted TOAD and was able to query CLOBs successfully. Thanks a lot!! Best wishes, Charu -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Tuesday, July 29, 2003 8:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
You may find it easier to just run the Oracle Home Selector that appears in the Startup-Programs-Oracle Installation Products menu. It has the benefit of also modifying the PATH variable. Jared On Thu, 2003-07-31 at 07:54, Charu Joshi wrote: RE: ORA-03115 (TOAD question!!)Hi, It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation and found out this piece of information: ** When Oracle connects, it will look in ALL_HOMES for the LAST_HOME value, which in this case is zero 0. It appends zero to HOME to produce HOME0, then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME value. ** I modified the LAST_HOME key to point to the 8i HOME and restarted TOAD and was able to query CLOBs successfully. Thanks a lot!! Best wishes, Charu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jamadagni, Rajendra Sent: Tuesday, July 29, 2003 8:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03115 (TOAD question!!)
Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
Title: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: ORA-03115 (TOAD question!!)
Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
It's a TOAD issue. It's fixed in one of the v7.x versions. The current supported version is 7.5. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-03115 (TOAD question!!)
I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03115 (TOAD question!!)
7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
. ;) -Original Message- From: Jesse, Rich Sent: Tuesday, July 22, 2003 11:27 AM To: '[EMAIL PROTECTED]' Subject: RE: TOAD vs BMC's XRAY I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD vs BMC's XRAY
Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. Thanks in advance, . Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
Try DevPartnerDB from us (Compuware). You can create profiles of execution and compare one profile to another to optimize all of your code. Quite a cool product. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject:TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. Thanks in advance, Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
For development, take a look at Allround Automations Pl/Sql Developer. Nice functionality and an affordable price (~$50 in bulk). http://www.allroundautomations.nl/ AM PST Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). American Express made the following annotations on 07/22/2003 10:23:05 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you. Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for Spotlight, but for $2500/user, DBXray has a LOT to be desired. I've apparently been spoiled by Quest's Spotlight interface. After a 15-minute trial of DBXray (granted, that's a little slim), here's what my kneejerk of what I see to be the advantages of Spotlight on Oracle (SoO) over DBXray (DBX): 1) It's in freakin Java. 60MB of mem to launch and it's slw, even on a 2.4Ghz w/512MB. Half of this is a Java Windohs service. 2) It doesn't understand ONAMES, so I would need to manually maintain yet another repository of Oracle Network connections. 3) SoO's color scheme is configurable. DBX seems to be fixed on a scheme of light gray on light blue. Very low contrast and I can't imagine this is viewable by color-blind folk. 4) SoO's interface is scalable. DBX's main dashboard is fixed in size. 5) No menu access to drilldowns in DBX. Difficult for neophyte or occasional users to locate the correct image map on the main dashboard of DBX. 6) Session drilldown has fixed set of columns in DBX. Tune button only provides weak text-only explain plan. SoO provides two different methods for doing explain plans out-of-the box, and is expandable with optional software like the-product-formerly-known-as-SQLab. 7) Very few options for data display in DBX. SoO, for example, allows you to turn off BCHR collection as well as configure which columns to return from V$SESSION for the session drilldown (see #6). Man, there's so much more I don't want to take more time on it. SoO is clearly a *far* superior product when it comes to instance monitoring and tuning. I tried thinking of a single advantage of DBX over SoO, and I can't come up with one. Now to see if DBX will actually uninstall... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA p.s. Jacques, you can tell Steve N (Quest Monitoring Product Manager) that I'm a large for Quest t-shirts, polos, and/or jackets. ;) -Original Message- From: Jesse, Rich Sent: Tuesday, July 22, 2003 11:27 AM To: '[EMAIL PROTECTED]' Subject: RE: TOAD vs BMC's XRAY I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD vs BMC's XRAY
I don't think Rich likes DBXray. looks like he's gonna pass on it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 22, 2003 2:49 PM To: Multiple recipients of list ORACLE-L OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you. Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for Spotlight, but for $2500/user, DBXray has a LOT to be desired. I've apparently been spoiled by Quest's Spotlight interface. After a 15-minute trial of DBXray (granted, that's a little slim), here's what my kneejerk of what I see to be the advantages of Spotlight on Oracle (SoO) over DBXray (DBX): 1) It's in freakin Java. 60MB of mem to launch and it's slw, even on a 2.4Ghz w/512MB. Half of this is a Java Windohs service. 2) It doesn't understand ONAMES, so I would need to manually maintain yet another repository of Oracle Network connections. 3) SoO's color scheme is configurable. DBX seems to be fixed on a scheme of light gray on light blue. Very low contrast and I can't imagine this is viewable by color-blind folk. 4) SoO's interface is scalable. DBX's main dashboard is fixed in size. 5) No menu access to drilldowns in DBX. Difficult for neophyte or occasional users to locate the correct image map on the main dashboard of DBX. 6) Session drilldown has fixed set of columns in DBX. Tune button only provides weak text-only explain plan. SoO provides two different methods for doing explain plans out-of-the box, and is expandable with optional software like the-product-formerly-known-as-SQLab. 7) Very few options for data display in DBX. SoO, for example, allows you to turn off BCHR collection as well as configure which columns to return from V$SESSION for the session drilldown (see #6). Man, there's so much more I don't want to take more time on it. SoO is clearly a *far* superior product when it comes to instance monitoring and tuning. I tried thinking of a single advantage of DBX over SoO, and I can't come up with one. Now to see if DBX will actually uninstall... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA p.s. Jacques, you can tell Steve N (Quest Monitoring Product Manager) that I'm a large for Quest t-shirts, polos, and/or jackets. ;) -Original Message- From: Jesse, Rich Sent: Tuesday, July 22, 2003 11:27 AM To: '[EMAIL PROTECTED]' Subject: RE: TOAD vs BMC's XRAY I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat
Re: TOAD vs BMC's XRAY
great review :) I told them the same thing, but they're developer driven. The customer using the product comes 2nd. A flashing widget is more important to them than useful data to the DBA. The slowness has a been an issue since web dba. That required 256mb of ram. I asked if they were going to include memory and they said everybody runs their desktop with 500meg of ram or even better They'll need to upgrade. :)) my 2¢ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 1:49 PM OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you. Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for Spotlight, but for $2500/user, DBXray has a LOT to be desired. I've apparently been spoiled by Quest's Spotlight interface. After a 15-minute trial of DBXray (granted, that's a little slim), here's what my kneejerk of what I see to be the advantages of Spotlight on Oracle (SoO) over DBXray (DBX): 1) It's in freakin Java. 60MB of mem to launch and it's slw, even on a 2.4Ghz w/512MB. Half of this is a Java Windohs service. 2) It doesn't understand ONAMES, so I would need to manually maintain yet another repository of Oracle Network connections. 3) SoO's color scheme is configurable. DBX seems to be fixed on a scheme of light gray on light blue. Very low contrast and I can't imagine this is viewable by color-blind folk. 4) SoO's interface is scalable. DBX's main dashboard is fixed in size. 5) No menu access to drilldowns in DBX. Difficult for neophyte or occasional users to locate the correct image map on the main dashboard of DBX. 6) Session drilldown has fixed set of columns in DBX. Tune button only provides weak text-only explain plan. SoO provides two different methods for doing explain plans out-of-the box, and is expandable with optional software like the-product-formerly-known-as-SQLab. 7) Very few options for data display in DBX. SoO, for example, allows you to turn off BCHR collection as well as configure which columns to return from V$SESSION for the session drilldown (see #6). Man, there's so much more I don't want to take more time on it. SoO is clearly a *far* superior product when it comes to instance monitoring and tuning. I tried thinking of a single advantage of DBX over SoO, and I can't come up with one. Now to see if DBX will actually uninstall... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA p.s. Jacques, you can tell Steve N (Quest Monitoring Product Manager) that I'm a large for Quest t-shirts, polos, and/or jackets. ;) -Original Message- From: Jesse, Rich Sent: Tuesday, July 22, 2003 11:27 AM To: '[EMAIL PROTECTED]' Subject: RE: TOAD vs BMC's XRAY I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby. For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface. If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others. -Original Message- From: Fermin Bernaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Problem with TOAD is solved !!
Hi List ! My problem with TOAD was fixed.I do not call it great. Solution Obtained: 1. Reverted back to TOAD 7.2 (IT still did not work even though I was able to connect thru SQL *PLUS) 2. I took a back-up of my database and ran the catexp.sql script. I got a few warnings but all my data dictionary objects were re-created. 3. I am able to connect to my 9.2 db thru TOAD !! Thanks one and all! Regards, Satya Prakash -Original Message- Sent: Thursday, May 29, 2003 8:16 PM To: Multiple recipients of list ORACLE-L You will want to repost this to [EMAIL PROTECTED] Many users as well as the TOAD development team are on this list. Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could try http://www.quest.com/support/ HTH! GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Satya Prakash Viswanath [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:10 PM To: Multiple recipients of list ORACLE-L Subject: Problem with TOAD Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya Prakash Viswanath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem with TOAD is solved !!
Sorry it is the catalog.sql script -Original Message- Sent: Tuesday, June 03, 2003 11:30 PM To: Multiple recipients of list ORACLE-L Hi List ! My problem with TOAD was fixed.I do not call it great. Solution Obtained: 1. Reverted back to TOAD 7.2 (IT still did not work even though I was able to connect thru SQL *PLUS) 2. I took a back-up of my database and ran the catexp.sql script. I got a few warnings but all my data dictionary objects were re-created. 3. I am able to connect to my 9.2 db thru TOAD !! Thanks one and all! Regards, Satya Prakash -Original Message- Sent: Thursday, May 29, 2003 8:16 PM To: Multiple recipients of list ORACLE-L You will want to repost this to [EMAIL PROTECTED] Many users as well as the TOAD development team are on this list. Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could try http://www.quest.com/support/ HTH! GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Satya Prakash Viswanath [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:10 PM To: Multiple recipients of list ORACLE-L Subject: Problem with TOAD Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya Prakash Viswanath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya Prakash Viswanath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with TOAD
Cause: The synonym used is based on a table, view, or synonym that no longer exists. Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym. looks to me like one of the data dictionary views that toad is trying to use no longer exists or after the data dictionary synonym was created the object no longer exists. wierd, i thought synonyms were deleted when their corresponding objects where dropped. best way to fidn the problem is to an anti-join on the synonyms to the data dictionary views. you will need to use a wildcard for the v$ views. im curious about this. please post what you find. From: Satya Prakash Viswanath [EMAIL PROTECTED] Date: 2003/05/29 Thu AM 12:09:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Problem with TOAD Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya Prakash Viswanath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem with TOAD
You will want to repost this to [EMAIL PROTECTED] Many users as well as the TOAD development team are on this list. Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could try http://www.quest.com/support/ HTH! GL! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Satya Prakash Viswanath [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:10 PM To: Multiple recipients of list ORACLE-L Subject: Problem with TOAD Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem with TOAD
Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya Prakash Viswanath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with TOAD
Don't know if this helps but there are a handful of bugs with ORA-980's..with 9i Some of them are inaccessible. I ran into this problem and switched the synonym from private to public per Oracle's advice and got around it for the time being until I could put on the .3 patchset.. or was it from public to private? Not sure. I still haven't gotten the .3 patchset on either. The symptom was that a synonym appears valid by any stretch until it is accessed by a procedure and then the error is thrown. To track down these problems I put each synonym in a 3 line procedure that just did a select count.Maybe Toad is trying to do something other than make a simple connection. On Wed, 28 May 2003 20:09:48 -0800, you wrote: Hi List, I am facing a strange problem with TOAD (ver 7.3.0.0). I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru TOAD. I am getting ORA-00980: synonym translation is no longer valid. I do not know how this correlates with this error while connecting. I am able to connect to any other database thru TOAD. I am able to connect to my database using SQL* PLUS but my comfort level with TOAD is high that I do not want to revert to SQL * PLUS. ;) The things that I will list out are : 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru fine without any problems. 2. Nothing has happnened to my PC/Database since the last time I logged in to my machine. Very normal behavior. 3. I can desribe all my toad specific tables from SQL* PLUS. 4. The strange thing now (after running TOADPREP.sql) is that i can access all user tables but not dba tables(dynamic performance views) 5. Stopped and restarted the servies but to no effect 6. Even reinstalled TOAD but to no effect. 7. I have checked the trace files, seems fine to me. Even though this issue is specific to TOAD, plz help me on this. I am in touch with the support also but I cannot wait for 1 day for their reply. Any pointers? Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Doug INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD
List, I have a developer that I want to grant access to change another schema owner's packages in TOAD. I have granted connect, resource, and roles which incorporate DML on the tables and execute on the packages. When he goes into TOAD he can see the package spec but not the package body. How do I set up his privs to allow him to make changes to another's package bodies thru TOAD? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
toad question
What privileges are needed for a "toad" user to view another users packages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: toad question
Same as Oracle privs ... If you give execute, other user can see only package spec, if you grant 'create any procedure' they can see the package body/procedure/function body as well. * to see procedure/function/package spec you need on of 1. execute (if grant is made to public) 2. execute any procedure 3. create any procedure * to see package body you need "create any procedure" For more details see ALL_SOURCE view definition ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 29, 2003 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: toad question What privileges are needed for a "toad" user to view another users packages. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: toad question
Only 'Execute' right should be enough. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-2576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Jeffrey Beckstrom [EMAIL PROTECTED] gcrta.org Sent by: [EMAIL PROTECTED] 29.01.2003 15:48 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: toad question What privileges are needed for a toad user to view another users packages. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204
Re: strange SQL with TOAD
At 10:34 AM 1/14/2003, Ron Rogers wrote: List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? The ROWID parameter is used by the Oracle ODBC driver (and I assume everyone else's ODBC OLE DB drivers for Oracle) whenever the driver needs to provide functionality like scrolling a resultset (jump to row 1.000.000 without going through the other 999.999) or to update the data in the resultset. In these cases, the driver know that the ROWID will uniquely identify the row, so it just has to remember the set of ROWID's and it can call up any row. Similarly, if it needs to update a row, it can put a 'where ROWID=' clause in the update statement to ensure that only one row gets updated. Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
strange SQL with TOAD
List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange SQL with TOAD
Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ?? -Original Message- Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange SQL with TOAD
Title: RE: strange SQL with TOAD Also, you might try turning off the 'editable queries' in the options. That causes it to do a select rowid, * from table, so that once you edit the grid, it will use the rowid to go back and actually make the update to the data. -Original Message- From: Kevin Lange [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: strange SQL with TOAD Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ?? -Original Message- Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange SQL with TOAD
Ron, Are you using VB with ADO to return XML? ADO does some mighty strange stuff under the covers. If so, then I would guess that this is the cuplrit. My other guess is the VB is doing it in preparation to perform an update using the ROWID column in a where clause. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 14, 2003 12:34 PM To: Multiple recipients of list ORACLE-L List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange SQL with TOAD
Hey Ron! My guess is that the Dev has Show ROWID in data grids checked in the TOAD options, probably in Data Grids - Data if your version of TOAD is recent. Take care of them fine VMS boxes... :) HTH! GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: strange SQL with TOAD List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD ?
Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD ?
Are u running into a specific problem or you just don't know how to set it up? -Original Message- Sent: Friday, August 30, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD ?
Seema, you dont give us enough information, so I am not sure what your problem is, I think you dont have the configuration of your DB in your TNSNAMES.ora file in your desktop, look at your ORACLE_HOME dir and then in /net80/admin (oracle 8.0.x), just configure there your BD and then choose which one to use at TOAD SERVER LOGIN window, (the one that shows up when you open TOAD) I hope this helps you! Gabriel --- Seema Singh [EMAIL PROTECTED] wrote: Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD ?
You need oracel client on your PC can you connect from sqlplus? On Fri, 30 Aug 2002, Seema Singh wrote: Hi I want to use QUEST TOAD software free version.I have Databases on UNIX and I want to connect from my desk top to UNIX DB box but I am unable to.can Some one help me if they have? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD S/w
Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD S/w
Try www.quest.com, I believe this is the company's web site. Bryan -Original Message- Sent: Wednesday, May 22, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD S/w
http://www.quest.com http://www.toadsoft.com http://www.egroups.com/list/toad Quest is the official site. Toadsoft is the original site of the freeware (which is still available!). The TOAD mailing list is run/monitored by Toadman Jim himself, as well as his wonderfully helpful staff. EXCELLENT source for feedback and troubleshooting. HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 3:33 AM To: Multiple recipients of list ORACLE-L Subject: TOAD S/w Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD S/w
On Wed, 22 May 2002 00:33:18 -0800, Vivek Sharma wrote: Any Docs , Links ? O'Reilly has a Toad Pocket Reference in the works. Not sure of the release date. I believe it goes to print sometime in June, probably towards the latter part of the month. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Clob, toad, and a trigger not working
I've encountered a weird error (no it's not my boss). It's on W2K and happens on 8.1.6 an 9i. I've got two tables with clobs CREATE TABLE CLOB_TEST ( EIDNUMBER, CLOB_TEST CLOB ) ; -- CREATE TABLE CLOB_TEST_AFTER ( EIDNUMBER, CLOB_TEST CLOB ) ; and created the following trigger: CREATE OR REPLACE TRIGGER CLOB_TEST_AI AFTER INSERT ON CLOB_TEST FOR EACH ROW DECLARE buffer long; len number(10); eid number; clobber clob; sql_stmt varchar2(100); BEGIN eid := :NEW.EID; clobber := :NEW.CLOB_TEST; len := dbms_lob.getlength(clobber); DBMS_LOB.READ(clobber,len,1,buffer); insert into clob_test_after (eid, clob_test) values (eid, buffer); END; This trigger works fine when I do an insert into the first table from sqlplus but when I do an insert from TOAD or another third party application I get the following error messages: ora-21560 argument 2 is null, invalid, or out of range ora-06512 at sys.dbms_lob line 648 ora-06512 at clob_test_ai line 17 ora-04088 error during execution of trigger clob_test_ai Anyone know why this error occurs from third party stuff and not from sqlplus - or better yet a work around? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD schema browser
Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all works well. I can select from sys' tables and views, but when I start schema browser it shows schema for another user (not sys). Is it TOAD bug? How to fix the problem? -- Best regards, Sergey mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD schema browser
Hello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Sergey V Dolgov [EMAIL PROTECTED] pptus.oilnet.ru Sent by: [EMAIL PROTECTED] 24.04.02 11:58 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: TOAD schema browser Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all works well. I can select from sys' tables and views, but when I start schema browser it shows schema for another user (not sys). Is it TOAD bug? How to fix the problem? -- Best regards, Sergey mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD schema browser
It doesn't work as it shows no items in the list box ..I face the same problem. Thanks and Regards Amit Nagar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/02 04:53 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: TOAD schema browser Hello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Sergey V Dolgov [EMAIL PROTECTED] pptus.oilnet.ru Sent by: [EMAIL PROTECTED] 24.04.02 11:58 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: TOAD schema browser Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all works well. I can select from sys' tables and views, but when I start schema browser it shows schema for another user (not sys). Is it TOAD bug? How to fix the problem? -- Best regards, Sergey mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD schema browser
Hello What version of toad are you using. I downloaded version 7.2 a few days ago. Connected as sys, activated schema browser and got all sys tables in the list. I also got all the users in the drop list to select user. Yechiel Adar Mehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 24, 2002 3:03 PM Subject: Re: TOAD schema browser It doesn't work as it shows no items in the list box ..I face the same problem.Thanks and RegardsAmit Nagar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/02 04:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: TOAD schema browserHello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED] Sergey V Dolgov [EMAIL PROTECTED] pptus.oilnet.ru Sent by: [EMAIL PROTECTED] 24.04.02 11:58 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: TOAD schema browser Hello ORACLE-L,I'm connecting to oracle using TOAD under sys account - all workswell. I can select from sys' tables and views,but when I start schema browser it shows schema for another user(not sys).Is it TOAD bug? How to fix the problem?--Best regards,Sergey mailto:[EMAIL PROTECTED]--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Sergey V DolgovINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: TOAD schema browser
Its telling you to stop signing in as sys. -Original Message- Dolgov Sent: Wednesday, April 24, 2002 2:58 AM To: Multiple recipients of list ORACLE-L Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all works well. I can select from sys' tables and views, but when I start schema browser it shows schema for another user (not sys). Is it TOAD bug? How to fix the problem? -- Best regards, Sergey mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is it possible to remove default (TOAD users)
8.1.6 NT TOAD I have a developer assign a default value to a column, and they don't want it anymore. I can reset the default to be NULL (the default default so to speak) but they are able to see the fact that there is a default in TOAD on that column and of course the other columns don't have a default of NULL on them so they would like it removed - it makes them nervous. Is there any way to just get rid of the default showing up without deleting and re-adding the column? Should I tell them not to meddle anymore? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD and 9i
I just downloaded the free version of TOAD (6.3.11.1g) and it works without any errors on 9i. (9.0.1 on XP Prof./ DELL 8200). Ken Janusz, CPIM
TOAD Login Problem
Oracle 9i (9.0.1) on XP Professional on DELL 8200. TOAD VI freeware ver. 6.3.11.1g I keep gettint this error when I try to connect to 9i: Initialization error. Could not locate OCI dll I can connect using SQL*Plus with no problems. Any idea as to what the problem is with TOAD? Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD Login Problem
In TOAD to can set the path to you OCI dll if you need to. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 26, 2002 6:45 AM Oracle 9i (9.0.1) on XP Professional on DELL 8200. TOAD VI freeware ver. 6.3.11.1g I keep gettint this error when I try to connect to 9i: Initialization error. Could not locate OCI dll I can connect using SQL*Plus with no problems. Any idea as to what the problem is with TOAD? Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: TOAD Software???
I'm with you on all but that last tool (shudder) on the other hand, I usually substitute Macallan for that one and it works equally well --- Jared Still [EMAIL PROTECTED] wrote: While the first four are required low level tools, those following are indeed outsourced from a third party. Though considered by many to be used only in case of emergency, I find that modest application of these tools tends to relieve situations that might otherwise induce panic. Overuse on the other hand, tends to throw a wrench in the works and complicate issues, as third party tools are wont to do. Jared On Monday 14 January 2002 15:51, Robert Eskridge wrote: Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD software???
Hi, have a look at PL/SQL Developer by Allround Automations/NL. We use it for Development and are very happy with it. Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner Weg 22-24 D-52070 Aachen Telefon:+49 241 / 9 18 79-33 Fax:+49 241 / 15 40 38 mailto:[EMAIL PROTECTED] http://www.soptim.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD Software???
[EMAIL PROTECTED] wrote: Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. oh i'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? and i use TOAD as well and am happy with it. but revert to the command line tools and vim for anything more then simple stuff. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. LISP: To call a spade a thpade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
TOra - Toolkit For Oracle is an open source clone of TOAD for Windows and Linux. http://www.globecom.se/tora/ It has many of the same features and a better price(free). :) I have been using the Linux version for quite a while and am very pleased with it. I would be interested in hearing from people using the Windows version. David Miller [EMAIL PROTECTED] 614-693-4337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MILLER, DAVID L (CONTRACTOR) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
It is not free for windows anymore I love it, it is a bit slow, but hey that's fine ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, January 15, 2002 9:30 AM To: Multiple recipients of list ORACLE-L TOra - Toolkit For Oracle is an open source clone of TOAD for Windows and Linux. http://www.globecom.se/tora/ It has many of the same features and a better price(free). :) I have been using the Linux version for quite a while and am very pleased with it. I would be interested in hearing from people using the Windows version. David Miller [EMAIL PROTECTED] 614-693-4337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MILLER, DAVID L (CONTRACTOR) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
Re: TOAD Software???
Bill wrote : oh I'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? I happen to have done some fairly extensive research on the Irish version of these tools :-), but the results are mixed. There isn't much in the way of malts , but being triple distilled does help. All in all though the Scottish versions are more preferable - especially the Lagavullin. (It's a nice distillery - you should go there sometime Jared, you'll love it) Brian. bill thater bthater2@nets To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cape.netcc: Sent by: Subject: Re: TOAD Software??? [EMAIL PROTECTED] om 01/15/02 07:35 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. oh i'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? and i use TOAD as well and am happy with it. but revert to the command line tools and vim for anything more then simple stuff. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. LISP: To call a spade a thpade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD Software???
it tastes like PEAT yuck. and I have done extensive research into the Scottish versions. Dalwhinnie is nice (so is the distillery), Talisker, Oban, Glenmorangie... yum --- [EMAIL PROTECTED] wrote: Bill wrote : oh I'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? I happen to have done some fairly extensive research on the Irish version of these tools :-), but the results are mixed. There isn't much in the way of malts , but being triple distilled does help. All in all though the Scottish versions are more preferable - especially the Lagavullin. (It's a nice distillery - you should go there sometime Jared, you'll love it) Brian. bill thater bthater2@nets To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cape.netcc: Sent by: Subject: Re: TOAD Software??? [EMAIL PROTECTED] om 01/15/02 07:35 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. oh i'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? and i use TOAD as well and am happy with it. but revert to the command line tools and vim for anything more then simple stuff. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. LISP: To call a spade a thpade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You
RE: TOAD Software???
For scenic distilleries you need to go the Talisker distillery on the Isle of Skye. On a loch on the side of the Cuillin mountains. Fantastic. -Original Message- Sent: 15 January 2002 14:51 To: Multiple recipients of list ORACLE-L it tastes like PEAT yuck. and I have done extensive research into the Scottish versions. Dalwhinnie is nice (so is the distillery), Talisker, Oban, Glenmorangie... yum --- [EMAIL PROTECTED] wrote: Bill wrote : oh I'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? I happen to have done some fairly extensive research on the Irish version of these tools :-), but the results are mixed. There isn't much in the way of malts , but being triple distilled does help. All in all though the Scottish versions are more preferable - especially the Lagavullin. (It's a nice distillery - you should go there sometime Jared, you'll love it) Brian. bill thater bthater2@nets To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cape.netcc: Sent by: Subject: Re: TOAD Software??? [EMAIL PROTECTED] om 01/15/02 07:35 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. oh i'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? and i use TOAD as well and am happy with it. but revert to the command line tools and vim for anything more then simple stuff. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. LISP: To call a spade a thpade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
RE: TOAD Software???
Brian wrote but the results are mixed. I do not know ,or care, about the results after an extensive testing, but I certainly will not mix the usage of these tools. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: TOAD Software??? Bill wrote : oh I'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? I happen to have done some fairly extensive research on the Irish version of these tools :-), but the results are mixed. There isn't much in the way of malts , but being triple distilled does help. All in all though the Scottish versions are more preferable - especially the Lagavullin. (It's a nice distillery - you should go there sometime Jared, you'll love it) Brian. bill thater bthater2@nets To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cape.netcc: Sent by: Subject: Re: TOAD Software??? [EMAIL PROTECTED] om 01/15/02 07:35 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. oh i'm not sure about that. i do believe that extensive research is required on this topic. and what about the Irish versions? and i use TOAD as well and am happy with it. but revert to the command line tools and vim for anything more then simple stuff. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. LISP: To call a spade a thpade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
and what about the Irish versions? Ahh the Irish. Old Bushmills Single Malt I think the bottle says 10 years. That is good sippin stuff, all the rest of the Irish are best in coffee. I am surprised at the number of Scotch fans here. All this talk of visiting Distilleries is making me want to take a trip. Well at least a drive to Liqour Store. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TOAD Software???
Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
Been there, done that, BOUGHT it. All our DBA's (4) are working with it. Mind you, this is a tool for DBA. We bought PlSqlDeveloper for the development stuff. A very good Swiss army knife for the dba. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Relika Shetty [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
Well, it is much better than standard SQL*Plusgives u a lot of GUI options and other functionalities. For that matter, most of the products of Quest Software are quite good..especially their performance monitoring tools. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 14 January 2002 12:00 To: Multiple recipients of list ORACLE-L Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TOAD Software???
Hi Relika, I have used Toad. Toad is an excellent replacement for SQL*Plus and has a good PL/SQL development environment. Thanks Jason ~~~ Oracle DB Resources ( http://oracle.dbresources.com) - Online community for Oracle DBAs and Developers - ~~~ --- Relika Shetty [EMAIL PROTECTED] wrote: Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
We use it. I really like it. I also got it purchased for the developers. Small footprint, reasonably priced, new features added all the time, not a lot of bugs. -Original Message- Shetty Sent: Monday, January 14, 2002 4:00 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
TOAD is the one Oracle tool I would refuse to give up. We used to use SQL*Navigator, and I much prefer TOAD. It has a well-thought-out interface, and has useful features for both DBA and Developer. All of our developers and DBAs use it. The support from Toadman and his development group is outstanding. There is a very active mail list (http://www.egroups.com/list/toad) and an active beta program open to ALL registered TOAD owners. I can't recommend TOAD highly enough. Dave -Original Message- From: Relika Shetty [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:00 AM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
Warning: if you are offended by fogeyism or curmudgeonly attitudes, you should not read the rest of this message. Thank you. As for TOAD vs SQL*Navigator, I would certainly agree with you there. TOAD has a much better interface. As for the tools that I would steadfastly refuse to give up, sorry, TOAD doesn't make the cut. Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Not necessarily in that order. Jared schmoldt@fyiow a.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: TOAD Software??? om 01/14/02 01:55 PM Please respond to ORACLE-L TOAD is the one Oracle tool I would refuse to give up. We used to use SQL*Navigator, and I much prefer TOAD. It has a well-thought-out interface, and has useful features for both DBA and Developer. All of our developers and DBAs use it. The support from Toadman and his development group is outstanding. There is a very active mail list (http://www.egroups.com/list/toad) and an active beta program open to ALL registered TOAD owners. I can't recommend TOAD highly enough. Dave -Original Message- From: Relika Shetty [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:00 AM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E
Re[2]: TOAD Software???
Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TOAD Software???
Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. Oh I absolutely agree on the other important tools, though I admit you did have me wondering what the Guiness software suite had to offer. As for TOAD, I would definately give it a thumbs up. I used to work for a client that owned a copy. I admit it was the GUI tool that made me begrudgingly begin to accept GUI tools. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: TOAD Software???
While the first four are required low level tools, those following are indeed outsourced from a third party. Though considered by many to be used only in case of emergency, I find that modest application of these tools tends to relieve situations that might otherwise induce panic. Overuse on the other hand, tends to throw a wrench in the works and complicate issues, as third party tools are wont to do. Jared On Monday 14 January 2002 15:51, Robert Eskridge wrote: Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Toad vs. SQL Navigator
Look at TORA, for the cost ($0.00) it is a nice tool ... not way too many features ... but good ones only ... Look it up at http://www.globecom.net/tora/ Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
TOAD-like tools for UNIX
Are there any Unix/Linux/Solaris tools that work like TOAD or SQL Nav? Venkat Somusetty -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Venkat Somusetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).