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. 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: 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: 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: 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 (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.ne
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
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
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
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
; > 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. > > > > > > > > > **4 > > > > -- > > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > > -- > > > > Author: Jamadagni, Rajendra > > > > 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). > > > > > > > > -- > 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: 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: 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 >
Re: Fedora (pink hat)
ne so far. oemapp console, sqlplus and > dbca all work fine. > Haven't tried other tools. > > As Joe 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: 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).
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).
