Re: RE: Create Table..As Select: Number formats

2003-10-01 Thread Tanel Poder
Thanks to everyone who responded to this thread - Option A is now to persuade the designers to remove the Number formatting from the parttioned table, Option B is to pre-create the working table and populate it with Truncate and Insert /* Append */ Option B will be slower, I think, due to

Re: RE: Create Table..As Select: Number formats

2003-10-01 Thread Tanel Poder
No, option B is as fast as CTAS (as long as you don't have any indexes on the table). Just make sure that your append hint works... Also you have to specify NOLOGGING on table or tablespace level when doing insert /*+ APPEND */ or use NOLOGGING hint if you're on 9i. Tanel. -- Please see

RE: RE: vertical serches on a table - how to

2003-10-01 Thread Susan Tay
Stephane, Fantastic! Appreciate the help. Thanks! susan From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: vertical serches on a table - how to Date: Wed, 01 Oct 2003 08:04:31 -0800 Stephane, Apologize

Re: RE: Using dimensions

2003-09-30 Thread Prem Khanna J
OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp. 30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote: google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands -Original Message- From: Prem Khanna J

RE: Re: Cary's book -- Out of stock !

2003-09-30 Thread DENNIS WILLIAMS
makes me want to abandon study for my last OCP exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 23, 2003 11:40 AM To: Multiple recipients of list ORACLE-L RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows

RE: Re: Cary's book -- Out of stock !

2003-09-30 Thread Stephane Paquette
Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 23, 2003 11:40 AM To: Multiple recipients of list ORACLE-L RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs

RE: RE: Google's architecture -- was Re: paging and google.com

2003-09-30 Thread Bob Metelsky
: Friday, September 26, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Google's architecture -- was Re: paging and google.com I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of google-like behaviour in Oracle queries ? Hemant At 07:24 AM 26-09

RE: RE: Using dimensions

2003-09-30 Thread Jamadagni, Rajendra
Title: RE: RE: Using dimensions I am out sick today ... glad you found the acronyms ... the F is left to your own imagination. Raj -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 30, 2003 5:45 AM To: Multiple recipients of list ORACLE-L

Re: RE: Separate Indexes and Data

2003-09-30 Thread rgaffuri
the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size

RE: RE: Separate Indexes and Data

2003-09-30 Thread Jesse, Rich
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Separate Indexes and Data the defrag paper was written back in 1998 I believe. Uniform extents were a good

RE: RE: Separate Indexes and Data

2003-09-30 Thread rgaffuri
From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 02:09:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Separate Indexes and Data -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30

Re: RE: Separate Indexes and Data

2003-09-30 Thread Rachel Carmichael
Nuh uh, not me... I have never used or experimented with auto-allocate. I separate indexes and tables so that I can reclaim space by rebuilding the indexes into smaller space. I've just completed writing the scripts for the following: we have a data warehouse, partitioned on the biggest table

RE: RE: Separate Indexes and Data

2003-09-30 Thread Jesse, Rich
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Separate Indexes and Data From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 02:09:32 EDT

RE: RE: Separate Indexes and Data

2003-09-30 Thread MacGregor, Ian A.
My criticism of the defrag paper was that it did not address what to do when a segment grew large enough to belong in a tablespace with a larger uniform extent size. Moving the segment creates holes in its original tablespace which may close only in the fullness of time. Physical backups of

RE: RE: Separate Indexes and Data

2003-09-30 Thread JayMiller
But those holes of exactly the right size for new objects to fit into. Since you'll presumably move it once it gets about 1,000 extents or so that isn't a huge amount of space that's being wasted. Jay Miller Sr. Oracle DBA -Original Message- Sent: Tuesday, September 30, 2003 4:45 PM

Re: RE: interesting sql question

2003-09-29 Thread rgaffuri
From: Stephane Faroult [EMAIL PROTECTED] Date: 2003/09/29 Mon AM 09:59:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: interesting sql question - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list

RE: RE: interesting sql question

2003-09-29 Thread Jamadagni, Rajendra
Title: RE: RE: interesting sql question Here is an attempt ... select p.* from persons p where sid in (select sid, count(bid) from bids group by sid having count(sid) = (select count(boad_id) from boats)) / You wanted to find all persons who have booked all boats ... add criteria

RE: RE: interesting sql question

2003-09-29 Thread rgaffuri
a user may request the same boat more than once. not sure that work. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/09/29 Mon AM 10:34:53 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: interesting sql question Here is an attempt ... select p

RE: RE: interesting sql question

2003-09-29 Thread Jamadagni, Rajendra
Title: RE: RE: interesting sql question Hey ... the question wasn't complete ... give us the full statement of the question ... g Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed

Re: RE: interesting sql question

2003-09-29 Thread rgaffuri
you could do this, but i would have concerns over the indexing strategy. select name from person, (select distinct sid, count(*) bid_count from bids group by sid HAVING count(*) = (SELECT COUNT(BOAT_ID FROM BOATS)) bids where person.sid = bids.sid; Now yours bids table is an intersect

RE: RE: interesting sql question

2003-09-29 Thread rgaffuri
, Thomas F [EMAIL PROTECTED] Date: 2003/09/29 Mon PM 12:29:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: interesting sql question yeah! I think it *is* homework :) Tom -Original Message- Sent: Monday, September 29, 2003 12:10 PM

Re: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

2003-09-29 Thread rgaffuri
i thought i read that auto-segment management only handles pctused. you have to handle pctfree yourself? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/29 Mon PM 12:09:46 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on

Re: RE: Using dimensions

2003-09-29 Thread rgaffuri
i think there are examplse in the datawarehouse doc on otn. there is an oracle datawarehouse book that has come recommended(havent read it). tim gorman wrote that one right? Id bet its in there too. you use dimensions with star schema's right? From: Jamadagni, Rajendra [EMAIL PROTECTED]

RE: RE: Using dimensions

2003-09-29 Thread Stephane Paquette
PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Monday, September 29, 2003 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I

Re: RE: x$ constructs and memory

2003-09-29 Thread rgaffuri
i think there are memory structurse that oracle isnt telling us about. wouldnt surprise me if the x$ tables are stored in some place that is not documented. From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/29 Mon PM 02:24:46 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: RE: Using dimensions

2003-09-29 Thread rgaffuri
so basically your saying you use dimensions hand in hand with materialized views. do they have other uses? From: Stephane Paquette [EMAIL PROTECTED] Date: 2003/09/29 Mon PM 02:39:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Using dimensions Using

RE: RE: Using dimensions

2003-09-29 Thread DENNIS WILLIAMS
basically your saying you use dimensions hand in hand with materialized views. do they have other uses? From: Stephane Paquette [EMAIL PROTECTED] Date: 2003/09/29 Mon PM 02:39:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Using dimensions Using

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
Hi Manoj, this is the statistics i got from one of my instance. sql area225 MB library cache 112 MB I was also confused as u were [ i didn't notice this so far ]. but reading the replies of Tanel Steve once again: tanel But what Steve meant (please correct me

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread ManojKr Jha
: Sent by: Subject: Re: RE: SQL AREA and LIBARARY CACHE size? [EMAIL PROTECTED

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
Hi Manoj, to be frank : need to know more basic stuff before i peep into X$ tables. let me get good at fundamentals (a lot to be read explored) first. later i can join u to explore about X$ stuff ;) meanwhile,i'm waiting for someone to explain me about transient chunk recurrent chunk. Jp.

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Tanel Poder
. -- -- Prem Khanna J [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .co.jp cc: Sent by: Subject: Re: RE: SQL AREA and LIBARARY CACHE

Re: RE: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Prem Khanna J
...long long way to go . b4 i reach x$ tables. Tanel, can u brief me about transient chunks recurrent chunks that u were discussing with Steve ? Jp. 26-09-2003 19:54:48, Tanel Poder [EMAIL PROTECTED] wrote: I'd suggest, when possible, not to use any x$ views, but stich with plain old

RE: RE: Re[2]: Cary's book -- Out of stock !

2003-09-26 Thread JayMiller
I just ordered from Bookpool. It's in stock according to their website. Glad I took a few minutes to start cleaning up the listserv email, didn't realize it was out yet. Really looking forward to this one... Jay Miller Sr. Oracle DBA -Original Message- Sent: Wednesday, September 24,

Re: RE: guidance

2003-09-26 Thread rgaffuri
yeah but alot of employers like to see the certifications. so for most of us who are not at the point in our career as some of the senior guys here, we have to do it. Ive noticed that you can get more done if your certified too. Adds credibility to what you say. Especially with management.

RE: RE: guidance

2003-09-26 Thread Cary Millsap
Oh, please don't get me wrong: grades are important! My point is that there's getting perfect grades, and there's knowing what's going on. And sometimes they're different. I believe you're better off with both credentials *and* actual horsepower than with just one or the other. I don't consider

RE: Re[2]: DBA needed in Austin, TX

2003-09-26 Thread Mladen Gogala
What is so special about htat Mongolloid BBQ? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Gennick Sent: Friday, September 26, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: Re[2]: DBA

Re: RE: Google's architecture -- was Re: paging and google.com

2003-09-26 Thread rgaffuri
must have been google like behavior. i dont focus on every word. From: Hemant K Chitale [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:39:53 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Google's architecture -- was Re: paging and google.com I'm confused.

RE: RE: Google's architecture -- was Re: paging and google.com

2003-09-26 Thread Matthew Zito
-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 26, 2003 12:55 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RE: Google's architecture

Re: RE: what causes a memory dump?

2003-09-26 Thread rgaffuri
memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump?

RE: RE: what causes a memory dump?

2003-09-26 Thread Cary Millsap
v$session.type Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent:

RE: RE: what causes a memory dump?

2003-09-26 Thread Mladen Gogala
:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From

RE: RE: what causes a memory dump?

2003-09-26 Thread rgaffuri
ok so what causes the memory to dump? Im stumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 02:39:41 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Depending on the type of process which is dumping. If it's

RE: Re[2]: DBA needed in Austin, TX

2003-09-26 Thread Gene Sais
The Mongolian Wok here in West Palm Beach went out of business, probably b/c Palm Beach County residents can't decide what ingredients to pick :). One thing about Texas, is that they have the highest homeowners insurance fees in the country. They get their share of All of nature's

RE: RE: what causes a memory dump?

2003-09-26 Thread DENNIS WILLIAMS
Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the

RE: RE: what causes a memory dump?

2003-09-26 Thread Mladen Gogala
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: what causes a memory dump? ok so what causes the memory to dump? Im stumped? From

RE: RE: what causes a memory dump?

2003-09-26 Thread rgaffuri
[EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system

RE: RE: what causes a memory dump?

2003-09-26 Thread rgaffuri
what is warp 9? what is the point of dumping memory? I didnt set this up. From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:29:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? There is special mechanism

RE: RE: what causes a memory dump?

2003-09-26 Thread DENNIS WILLIAMS
[EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system

RE: RE: what causes a memory dump?

2003-09-26 Thread Jamadagni, Rajendra
Title: RE: RE: what causes a memory dump? Dennis ... your max_dump_file_size parameter is set that's why you see max 4M. I had some 8G trace files ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views

RE: RE: what causes a memory dump?

2003-09-26 Thread DENNIS WILLIAMS
Raj - Thanks, I forgot about that one. Ryan - you might want to check your value for that parameter. So Raj, was there any value to the 8-gig dump file beyond the first 4-meg of it? Or did you have an error that required you to increase the dump file size in order to diagnose it? Dennis

RE: RE: what causes a memory dump?

2003-09-26 Thread Jamadagni, Rajendra
Title: RE: RE: what causes a memory dump? Dennis, it was a 10046^8 dump for a optimized java program ... Ha !! Couldn't make tkprof to read it though ... even with ulimit unlimited. 16 CPU, 32GB box. We have intentionally left max_dump_file_size to unlimited ... Raj

RE: RE: what causes a memory dump?

2003-09-26 Thread M Rafiq
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where

Re: RE: what causes a memory dump?

2003-09-26 Thread Ryan
. any examples of what causes a memory dump? what is the point to a memory dump? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:19:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct

RE: RE: RAC for download -- re RAC Pricing and Partitioning

2003-09-25 Thread Matthew Zito
Of course, this pricing bears no relation to actual reality. 70% discounts off list, especially on the addons like RAC, are not uncommon. You just have to push a bit. :) Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Tanel Poder
Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list, by pressing the first letter of a command - you'll be navigate to alter command for example if you press a

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Jared . Still
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: 10g: SQL Plus Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Kirtikumar Deshpande
Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: 10g: SQL Plus Hi! Press F7 in windows command line sqlplus to see

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Tanel Poder
Does it work even in sqlplus? Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 10:14 PM Subject: Re: Re[2]: 10g: SQL Plus This can be done with ksh as well. Someone else may

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Jared . Still
by: [EMAIL PROTECTED] 09/24/2003 12:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: 10g: SQL Plus Does it work even in sqlplus? Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple

Re: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Tanel Poder
swear not to order anything from Amazon again, so help me Codd. This was a good one ;) Tanel. -- 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,

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Rachel Carmichael
and I got the notice it was shipped.. which means I'll have it by Friday. Now, since I read the online first chapter, I don't feel so far behind I know what my reading list will be for the weekend! --- Freeman Robert - IL [EMAIL PROTECTED] wrote: I got my book... I got my book! From

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Mladen Gogala
B***ards! They killed Kenny! -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Tuesday, September 23, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: Cary's book -- Out

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Freeman Robert - IL
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Tuesday, September 23, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: Cary's book -- Out of stock ! swear not to order anything from Amazon again, so help me Codd. This was a good one

RE: Re: Cary's book -- Out of stock !

2003-09-23 Thread David Wagoner
Title: RE: Re: Cary's book -- Out of stock ! Well after thumbing through Cary and Jeff'sbook yesterday, I decided to set aside the other 2 tuning books I was reading and plunge into this one. Here's why: Figure 9-14 shows an interesting situation in which a single fast CPU out-performs

Re: Re: Cary's book -- Out of stock !

2003-09-23 Thread Tanel Poder
RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs, for a certain condition; this is exactly the situation I am facing while testing the move of a DB (9.0.1.3.0) from a 2-processor (600 MHz

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Mladen Gogala
and they will not get a cent more. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Tuesday, September 23, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]: Cary's book -- Out of stock

Re: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Tanel Poder
of my money and they will not get a cent more. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Tuesday, September 23, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Orr, Steve
At 1:00PM Seattle time I complained loudly via their online Contact Us form and they got the shipment out before the end of the day and are waiving shipping costs. They tried but were unable to explain why it wasn't shipped out before more recent orders for the same item. They obviously have a bug

RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Mercadante, Thomas F
Sent: Tuesday, September 23, 2003 6:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: Cary's book -- Out of stock ! swear not to order anything from Amazon again, so help me Codd. This was a good one ;) Tanel. -- Please see the official ORACLE-L FAQ: http

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Prem Khanna J
24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote: I just read the first chapter on-line. Now I gotta order the book. Where Tom ? is it on Amazon or bookpool or BN ... ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Wolfgang Breitling
http://www.oreilly.com/catalog/optoraclep/chapter/index.html At 07:34 PM 9/23/2003 -0800, you wrote: 24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote: I just read the first chapter on-line. Now I gotta order the book. Where Tom ? is it on Amazon or bookpool or BN ... ? --

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-23 Thread Mladen Gogala
I believe this should answer your question: Barnes Noble.com Your Order Has Been Shipped Dear MLADEN GOGALA: Your order has been shipped, and the details appear below. Within 24 hours of receiving this email, you may track the delivery status of your order at

Re: RE: Bug in 9.2.0.4

2003-09-22 Thread Prem Khanna J
Ohhh ! ...i don't find 3110923 patch fix for Ms-Win :( 22-09-2003 20:39:52, Nigel Bishop [EMAIL PROTECTED] wrote: Ooops - Sorry Monday morning cut paste error - patch number should read 3110923 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET:

Re: RE: Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
Thanx for the info' Ranganath. it's too late now.i have placed my order. that's okay.i will finish it b4 i come there. it will help me a lot ;) Regards, Jp. 22-09-2003 19:59:24, Ranganath K [EMAIL PROTECTED] wrote: Hi Prem, The book should be out during first week of October. BTW the low

Re: Re: Cary's book -- Out of stock !

2003-09-22 Thread rgaffuri
what was the initial printing? congrats Cary. Hope I can get a copy soon. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/09/22 Mon AM 09:09:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Cary's book -- Out of stock ! It's up to the publisher as to

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread David Wagoner
Title: RE: Re: Cary's book -- Out of stock ! UPS just delivered my copy of Cary's book to the office! Can't wait to read it, but first I plan to finish the books I'm currently reading: - The Art and Science of Oracle Performance Tuning (Chris Lawson) - Oracle SQL High-Performance Tuning (Guy

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread Weaver, Walt
Title: Message And don't forget the new Harry Potter book --Walt Weaver Bozeman, Montana -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: Cary's book

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread DENNIS WILLIAMS
David - You're torturing us man! Lend me your copy so I can read it while you're working your way down to it. Only fair! Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, September 22, 2003 11:00 AM To: Multiple recipients of

Re: Re: Cary's book -- Out of stock !

2003-09-22 Thread KENNETH JANUSZ
Title: Message Also Hillary Rodham Clinton Rodham's book -excellent fiction. Ken Janusz, CPIM - Original Message - From: Weaver, Walt To: Multiple recipients of list ORACLE-L Sent: Monday, September 22, 2003 11:09 AM Subject: RE: Re: Cary's book -- Out

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread Cary Millsap
I'm not sure what's up with Amazon. It was released last week, and it's showing up at people's houses now when purchased from other sources. Consider canceling your Amazon pre-order and buying it direct from oreilly.com. ...I'm pretty sure it's going to be several months before O'Reilly sells

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread Cary Millsap
I'm not sure what's up with Amazon. It was released last week, and it's showing up at people's houses now when purchased from other retailers. Consider canceling your Amazon pre-order and buying it direct from oreilly.com. ..I'm pretty sure it's going to be several months before O'Reilly sells

Re: RE: Offshore protests

2003-09-22 Thread rgaffuri
dba union could be considered a trust. doctors tried doing it and because they are 'independent businesses' its not a union its a trust. they did it to fight high mal-practice suits. From: Orr, Steve [EMAIL PROTECTED] Date: 2003/09/22 Mon PM 12:34:40 EDT To: Multiple recipients of list

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread Jamadagni, Rajendra
Title: RE: Re: Cary's book -- Out of stock ! Yey just received my copies of Cary's and Tom's new books. I'll get Toms autographed no 24th, for Cary's it will have to wait till Hotsos'04. now the sad part ... with the new baby at home, don't know how much time I'll get ... well

RE: RE: Offshore protests

2003-09-22 Thread Weaver, Walt
now. Unions suck, IMHO. Worst career move I ever made was joining a union. --Walt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Offshore protests dba union

RE: RE: Offshore protests

2003-09-22 Thread Mladen Gogala
PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Offshore protests dba union could be considered a trust. doctors tried doing it and because they are 'independent businesses' its not a union its a trust. they did it to fight high mal-practice suits. From: Orr, Steve

RE: RE: Offshore protests

2003-09-22 Thread Mladen Gogala
of list ORACLE-L Subject: RE: RE: Offshore protests Have any DBA's ever been sued for malpractice? I used to belong to a union. One day the union told us to go on strike, and we did. 22 years later, we're still on strike. I'm sure we'll be going back to work any day now. Then I can

RE: RE: Offshore protests

2003-09-22 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: A trust? That is only marginally better then the axis of evil. Do we risk getting bombed if we establish a trust? maybe, but remember some of us can bomb back.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I

RE: RE: Offshore protests

2003-09-22 Thread Brian Dunbar
Weaver, Walt [mailto:[EMAIL PROTECTED] on Monday, September 22, 2003 12:35 PM said; I used to belong to a union. One day the union told us to go on strike, and we did. 22 years later, we're still on strike. I'm sure we'll be going back to work any day now. Then I can quit this temporary IT

RE: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Mladen Gogala
Amazon changed status on my order, saying it will ship on 9/24. Are you sure that O'Reilly didn't use western style stage coach or wagon train as shipping method? Ye-haw! -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: RE: Offshore protests

2003-09-22 Thread Kip . Bryant
: Re: RE: Offshore protests | | | dba union could be considered a trust. doctors tried doing it | and because they are 'independent businesses' its not a union | its a trust. they did it to fight high mal-practice suits. | | | | From: Orr, Steve [EMAIL PROTECTED] | Date: 2003/09/22 Mon PM 12:34:40

RE: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Jesse, Rich
: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]: Cary's book -- Out of stock ! Amazon changed status on my order, saying it will ship on 9/24. Are you sure that O'Reilly didn't use western style

RE: Re: Cary's book -- Out of stock !

2003-09-22 Thread Orr, Steve
I pre-ordered long ago and still have no valid delivery date. When I check the status of my order it just states, We are preparing these items for shipment and this portion of your order cannot be canceled or changed. The where's my stuff page has been saying that for the last 2-3 weeks after

RE: RE: Offshore protests

2003-09-22 Thread Cunningham, Gerald
. Unions suck, IMHO. Worst career move I ever made was joining a union. --Walt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Offshore protests dba union could

Re: Re[2]: 10g: SQL Plus

2003-09-22 Thread Ron Thomas
Cut and paste works just fine using the command line sql*plus and an X window manager. I suppose if you are using the Windows window manager, your milage varies... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

Re: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Jared . Still
Amazon didn't have any, so I cancelled that order and ordered directly from O'Reilly. Jared Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/22/2003 04:45 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Freeman Robert - IL
I got my book... I got my book! From Amazon, delivered today! Woo Hoo looks good Cary!! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/22/2003 7:10 PM Amazon didn't have any, so I cancelled that order and ordered directly from O'Reilly. Jared

Re: RE: download metalink articles - save target as

2003-09-22 Thread Prem Khanna J
Paula, 1.open the article in a new window. 2.right click view source 3.save as *.html this is what i do. Jp. -Original Message- [EMAIL PROTECTED] When I right click on a metalink article to try to save it to a local directory and use save target as - it only provides a blank file.

Re: RE: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Prem Khanna J
Robert, are u the author of 9i RMAN Book by Oracle Press ? sorry for my ignorance. If YES: I have got a doubt in your book. can i mail it to u ? Jp. 23-9-2003 11:44:41, Freeman Robert - IL [EMAIL PROTECTED] wrote: I got my book... I got my book! From Amazon, delivered today! Woo Hoo looks

Re: Re[2]: Cary's book -- Out of stock !

2003-09-22 Thread Mladen Gogala
You got it from the Amazon??? Below is what they replied to me, and I pre-ordered the book on July 13th. I solemnly swear not to order anything from Amazon again, so help me Codd. Of course, the book is available from BN. What is more, Amazon has removed all references to their phone number from

Re: Re: Tempfile weirdness

2003-09-19 Thread Tanel Poder
Hi! Try with 2 dots, you might get the same behviour. Or put a space before every dot. Some old unix mailers considered dot in beginning of the line as end of mail... Tanel. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L

<    3   4   5   6   7   8   9   10   11   12   >