Re: !!Please Read - Oracle-L is moving!!
Ref: Fix subscription errors after Final Confirmation message I'm on Yahoo. The workaround is to send the Final Confirmation message (with that //job stuff) back using the Forward button (not Reply). You have to cut-paste the address. The problem with Reply is caused by HTML formatting in the Reply scrollable window, which may add a CR to the command and fail. However, if you use Forward instead of Reply there is no editing nor formatting and it works! Good luck, see you there... Regards, Mike Thomas Oracle-L will be hosted by freelists.org, effective immediately. -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/. Searchable archives - http://www.freelists.org/archives/oracle-l __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Spool to Excel File
Hi, Years ago, I stole this idea from: http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm I've used it a few times, mostly to impress bystanders. It's got size limitations, but kinda cool anyhow. QUOTE Getting SQL Query Results into an Excel Spread Sheet By Pavel Luzanov This months script will help users get SQL query results into an Excel spread sheet. SET LINESIZE 999 VERIFY OFF FEEDBACK OFF SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF DEFINE table_name = 1 SPOOL table_name..xls SELECT * FROM table_name; SPOOL OFF SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON SET LINESIZE 80 VERIFY ON FEEDBACK ON REM Use this command to start Excel from char-mode sqlplus REM HOST start table_name..xls REM Use this command to start Excel from GUI-mode sqlplus HOST start excel.exe table_name..xls \QUOTE Regards, Mike Thomas --- Mudhalvan, Moovarkku [EMAIL PROTECTED] wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: table reorganizations
Hi, Guys, in this case can we chill (in a friendly way) about the naive questions. At least her company has a job posting for Senior Oracle DBA. E.g.: http://pella.kenexa.com/pellav4/newhr/jobdesc.asp?ID=1194 Maybe they really do need help? Sorry, their web site is really slow, too. ;-) HTH. Regards, Mike Thomas --- Nuno Pinto do Souto [EMAIL PROTECTED] wrote: Shrake, Jolene [EMAIL PROTECTED] wrote: I'm surprised at these responses. I'm asking what sql statement most people use to identify tables that need reorganization because of holes. You don't have to be. There is plenty of material available today online that demonstrates the futility of religious (meaning: dictated by dogma) reorganizations. We had an Oracle consultant here and he uses A con-sultant, perheaps? What sql statement is used by others? None. There is no such thing as a statement that will pinpoint a need for a reorg. Unless you can prove to yourself that reorganizing any given table will improve anything in your system, then just going through the motions because there is a hole is useless. Holes are not necessarily the same as disasters. If you are using a reasonably recent version of Oracle (something you should ALWAYS mention upfront is the version you are running), then you can get all the information you need from the data in the dictionary as well as the statistics info. And guess what: that is also all the information Oracle itself needs and uses to work around any potential problems holes might have caused in the past. Bottom line: only reorganize if you have a specific reason, purpose and target for doing so. Just doing it because a con-sultant's SQL statement says so, is turning yourself into a cookie-cutter DBA. Which may give your boss a very warm feeling about your position, but achieves preciously nothing in real terms. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: table reorganizations
Using iSQL*Plus, I like to run 'select * from dba_objects' as my 'TPC for dummies' test in the lab. Hehehe. In isolation (LAN/DB), the query completes in just over 45 seconds, weighing in at a 250MB RAM IE session on W2K client. Agreed its not probably the type of thing to do in production, nor at work on the DB or LAN. Regards, Mike Thomas --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: select * from dba_objects where object_id in (select obj# from sys.obj$ sample (5)) / ps: this is not a serious answer ... don't try this on your production system. 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 ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: oracle client on PC's
Hi, I'm in Raleigh, so DataDirect is right nearby. Also, I know their current managers, etc. I worked with them on my last contract, and know something about their stuff. We needed an ODBC driver from our ETL DataStage UNIX server to an Sybase Adaptive Server Anywhere (old version) client running on Windows NT. The DataDirect guys really helped us out, especially with contact info for Sybase ASA. As I remember, the ETL DataStage wire-protocol was considered anything 'provided' with their product, e.g. Sybase 11. Therefore, 'non' wire-protocol was 3rd party like our Sybase ASA ODBC driver. We could still use the DataStage Driver Manager to configure the 3rd party ODBC. Too much information. Sorry. Whatever... :-) Send me an email and maybe I can help with info. Regards, Mike Thomas --- Jared Still [EMAIL PROTECTED] wrote: Ah, Merant is just down the street, sort of. Maybe they'll loan me one. :) Thanks for the explanation. The concept isn't new, but the terminology is. Jared On Tue, 2004-01-06 at 14:09, Grant Allen wrote: -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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).
Price is right
http://www.halfpricecomputerbooks.com/book/059600527X+ I just noticed the price of Cary/Jeff's new book is FREE. Of course this must be a mistake. But, its funny. There should be no excuses now. ;-) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Has anyone used this Perl Module? Oracle-Trace-1.06
Hi, Thanks, very much. I found about the same things. I'm curious if you got any farther than me? I'm on Cygwin-W2K, and I've tried plenty of tricks. e.g. ... (1) an old version of Data-Dumper-2.101.tar.gz (not even sure I needed it), and (2) vi Oracle/Trace.pm add line 12, use FileHandle; - Now I'm stuck at 'make test', my best results are: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/TraceName main::a_ftr used only once: possible typo at t/Trace.t line 26
Re: Has anyone used this Perl Module? Oracle-Trace-1.06
Sorry, the last email got truncated for some reason. Here is the rest: - Now I'm stuck at 'make test', my best results are: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/TraceName main::a_ftr used only once: possible typo at t/Trace.t line 26 t/Traceok 3/8 # Failed test (t/Trace.t at line 29) # expected 4 entries (26 - (header + children)) got: 0 t/Traceok 5/8 Can't call method statement on an undefined value at t/Trace.t line 43. # Looks like you planned 8 tests but only ran 7. # Looks like your test died just after 7. t/Tracedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4, 6, 8 Failed 3/8 tests, 62.50% okay Failed Test Stat Wstat Total Fail Failed List of Failed --- t/Trace.t255 65280 84 50.00% 4 6 8 Failed 1/1 test scripts, 0.00% okay. 3/8 subtests failed, 62.50% okay. make: *** [test_dynamic] Error 2 It looks like these results are scrambled because I don't see test1, test2, test7 but I'm getting credit as passed. I figure only 3 and 5 really passed. I stopped here, trying to decide if I should update the perl version on my server, to continue. If you got a good 'make test' then I'll proceed. Regards, Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Has anyone used this Perl Module? Oracle-Trace-1.06
Thanks. It's amazing how you did that. ;-) The last two updates on CPAN were both on Wednesday, e.g. 17DEC03, 24DEC03. And, today is Wednesday. So anyone that depends on BCHR over 99% might expect that the next release would be ... today! :-O I stumbled into the Oracle-Trace package while configuring my instance with chkalert/email from your 'Perl for Oracle DBAs' book. Chkalert is a cool program. Happy holidays! Regards, Mike Thomas --- Jared Still [EMAIL PROTECTED] wrote: Tha author says to use vs. 1.07. CPAN however only has vs. 1.06. I've asked the author how to obtain 1.07, haven't heard yet. Jared On Wed, 2003-12-31 at 02:14, Michael Thomas wrote: Sorry, the last email got truncated for some reason. Here is the rest: - Now I'm stuck at 'make test', my best results are: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/TraceName main::a_ftr used only once: possible typo at t/Trace.t line 26 t/Traceok 3/8 # Failed test (t/Trace.t at line 29) # expected 4 entries (26 - (header + children)) got: 0 t/Traceok 5/8 Can't call method statement on an undefined value at t/Trace.t line 43. # Looks like you planned 8 tests but only ran 7. # Looks like your test died just after 7. t/Tracedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4, 6, 8 Failed 3/8 tests, 62.50% okay Failed Test Stat Wstat Total Fail Failed List of Failed --- t/Trace.t255 65280 84 50.00% 4 6 8 Failed 1/1 test scripts, 0.00% okay. 3/8 subtests failed, 62.50% okay. make: *** [test_dynamic] Error 2 It looks like these results are scrambled because I don't see test1, test2, test7 but I'm getting credit as passed. I figure only 3 and 5 really passed. I stopped here, trying to decide if I should update the perl version on my server, to continue. If you got a good 'make test' then I'll proceed. Regards, Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Has anyone used this Perl Module? Oracle-Trace-1.06 (or 1.07)
Google'izing, you can find 1.07 here: http://cpan.oss.eznetsols.org/authors/id/R/RF/RFOLEY/Oracle-Trace-1.07.tar.gz My best results with 'make test' are now: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/Traceok 1/8 Name main::a_ftr used only once: possible typo at t/Trace.t line 26. t/Traceok 2/8 # Failed test (t/Trace.t at line 21) ) s_hdr(RFI t/Traceok 3/8 # Failed test (t/Trace.t at line 29) # expected 4 entries (26 - (header + children)) got: 0 t/Traceok 5/8 Can't call method statement on an undefined value at t/Trace. t line 43. # Looks like you planned 8 tests but only ran 7. # Looks like your test died just after 7. t/Tracedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4, 6, 8 Failed 3/8 tests, 62.50% okay Failed Test Stat Wstat Total Fail Failed List of Failed --- t/Trace.t255 65280 84 50.00% 4 6 8 Failed 1/1 test scripts, 0.00% okay. 3/8 subtests failed, 62.50% okay. make: *** [test_dynamic] Error 2 DOH? What failed between test2 and test3? This is with Perl 5.8.1 on Cygwin/W2K, etc.. Please advise if you get better results. Regards, Mike Thomas PS. Otherwise, see ya next week. ;-) --- Michael Thomas [EMAIL PROTECTED] wrote: Thanks. It's amazing how you did that. ;-) The last two updates on CPAN were both on Wednesday, e.g. 17DEC03, 24DEC03. And, today is Wednesday. So anyone that depends on BCHR over 99% might expect that the next release would be ... today! :-O I stumbled into the Oracle-Trace package while configuring my instance with chkalert/email from your 'Perl for Oracle DBAs' book. Chkalert is a cool program. Happy holidays! Regards, Mike Thomas --- Jared Still [EMAIL PROTECTED] wrote: Tha author says to use vs. 1.07. CPAN however only has vs. 1.06. I've asked the author how to obtain 1.07, haven't heard yet. Jared On Wed, 2003-12-31 at 02:14, Michael Thomas wrote: Sorry, the last email got truncated for some reason. Here is the rest: - Now I'm stuck at 'make test', my best results are: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/TraceName main::a_ftr used only once: possible typo at t/Trace.t line 26 t/Traceok 3/8 # Failed test (t/Trace.t at line 29) # expected 4 entries (26 - (header + children)) got: 0 t/Traceok 5/8 Can't call method statement on an undefined value at t/Trace.t line 43. # Looks like you planned 8 tests but only ran 7. # Looks like your test died just after 7. t/Tracedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4, 6, 8 Failed 3/8 tests, 62.50% okay Failed Test Stat Wstat Total Fail Failed List of Failed --- t/Trace.t255 65280 84 50.00% 4 6 8 Failed 1/1 test scripts, 0.00% okay. 3/8 subtests failed, 62.50% okay. make: *** [test_dynamic] Error 2 It looks like these results are scrambled because I don't see test1, test2, test7 but I'm getting credit as passed. I figure only 3 and 5 really passed. I stopped here, trying to decide if I should update the perl version on my server, to continue. If you got a good 'make test' then I'll proceed. Regards, Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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
Has anyone used this Perl Module? Oracle-Trace-1.06
Hi, I was wondering if anyone has used this Perl module successfully, and what you thought? http://search.cpan.org http://search.cpan.org/~rfoley/Oracle-Trace-1.06/ I noticed its relatively new. Happy Holidays. Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: large pl/sql table sucking up all memory on a server
, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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 === message truncated === __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Risk of knowing password hash value (Was: OEM permissions)
Hi, Okay. I'm almost a believer of this as a problem. How about 9.2.0.4 on RH9.3. 1) What does anyone/everyone get for my this query (my results shown): connect system/[EMAIL PROTECTED]; alter user scott identified by tiger; -- select password from dba_users where username = 'SCOTT'; PASSWORD F894844C34402B67 2) If you all get the same, then I'm concerned. Regards, Mike Thomas --- Yong Huang [EMAIL PROTECTED] wrote: Jared, I see you log out and log back in as SYSTEM to DB2. But how do you know the password for SYSTEM to log back in with after you change it? What if you don't log out? When I tried that (i.e. not logging out), I got ORA-1017. Yong Huang --- Jared Still [EMAIL PROTECTED] wrote: Environment: DB1: RH 8.0 with Oracle EE 9.2.0.4 DB2: Win2k SP3 with Oracle EE 9.2.0.1 SYSTEM user on each database initially have different passwords. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: 10g new features question for beta testers
I was in Reston last night, too. Also, Tom repeatedly emphasized RMAN, which I've not spent enough time mastering, will be even more important in 10g. Does everyone here use RMAN that is using 9i currently? BTW. Tom mentioned SAME, as you say, but I can not remember what he said about it. Sorry. Maybe Ryan remembers? As far as ASM, I thought it was interesting that ASM was supposed to run as additional PMON/SMON processes with separate dynamic V$ views as the API. I was pretty impressed that Tom was spending the week before holidays travelling around and doing Oracle presentations. He is really amazing. Regards, Mike --- Goulet, Dick [EMAIL PROTECTED] wrote: That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: OEM permissions
A possibly related question: I'm curious if everyone allows your developers to see V$SQL... views? If not, then ... whatever ... no comment. I'm disappointed with some perspectives in these threads regarding developers. Rather than close doors, why not use 'development' instances, and role based privs on the 'production' instance and grant the access required to the developers. E.g. Help them determine which Data Dictionary tables support their development? Good luck. --- Yong Huang [EMAIL PROTECTED] wrote: Hi, Raj, 9i doesn't allow a user with select any table privilege to view any object owned by SYS. So the sys.link$ risk is gone. But select any dictionary, a new privilege in 9i, allows that. In practice, I always grant select_catalog_role to any developer, but refrain from granting select any dictionary or select any table. As DBAs, we should encourage developers to make full use of data dictionary views and open the database to them as much as they can study it. I would help the consultant in your case instead of just throw back a NO to him. Yong Huang Jamadagni, Rajendra wrote: Dennis, select any table has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for ... One of our groups hired a new consultant and he (claimed to have DBA background) immediately shot off an email saying he needed select any table and select catalog role to do his work. We shot off reply Thanks for your email, while we appreciate your requirements for development, the privileges you are requesting are a tad different than we grant other developers. However we request that you submit a justification for these privileges and tell us how your development would be affected without these and we will accommodate your request. This was 3 months ago and we _still_ haven't heard back. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Fedora (pink hat)
mentioned, puschitz.com is the place to go for installation instructions, which include downloading a couple of patches from metalink. Rgds, Dave [EMAIL PROTECTED] wrote: Hi, I have attempted to install 9.2 on Fedora. If you follow the www.puschitz.com instructions for RHAS 3, it installs. I haven't created a new DB yet, but have mostly been looking at the OEM tools. Which, by the way, only partialy work. At least I haven't gotten them to fully work yet. The management packs seem to have issues. -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Table recovery from RMAN backup
My Question: I just tried to locate the web site for Joe's scripts, and I got an error or something. Wasssup? My Contribution (xmas season and all...): http://www.secunia.com/internet_explorer_address_bar_spoofing_test Is it too early to wish merry xmas to all? Thanks in advance. Regards, Mike Thomas --- Joe Testa [EMAIL PROTECTED] wrote: Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Fedora (pink hat)
If no one fesses up by tonight, I will spend 2 hours and do it myself. Quite a simple task. I will install the 9.2.0.4 Enterprise with all optional S/Q for the test. Does anyone have special requests? E.g. Number of disk drives? Amount of RAM? Database type (DW,OLTP,GENERAL,etc)? Character set? Anything else practical? Gotta go, but I'll check replys when I get back tonight. Hey, I'm still looking for Joe Testa's scripts. If anyone already has installed on Fedora, you can volunteer and save me a couple minutes tonight? Regards, Mike Thomas --- Ron Rogers [EMAIL PROTECTED] wrote: Come on Mladen, Since when do you not want to be first? Ron [EMAIL PROTECTED] 12/12/2003 3:19:33 PM Has anyone actually installed Oracle on Fedora? I don't want to be the first one. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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).