| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to put egg on your face
>
> sqlloader script and forgetting, among other things, to change "REPLACE"
to
> "APPEND". That's what I get for making shortcuts on no sleep. Never again.
agg...that was my VERY "1st" (many more afterward) mistake. sssheee...I was
on IBM OS2, oracle...
what a nightmare...
patrick
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Weaver,
Walt
Sent: Tuesday, November 14, 2000 7:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to put egg on your face
Man, tell me about it. Today I did the stupidest work-related thing I've done in 20 years. I deleted every row in a customer's table by cloning a sqlloader script and forgetting, among other things, to change "REPLACE" to "APPEND". That's what I get for making shortcuts on no sleep. Never again. 20 years ago, when I was an air traffic controller, I did something really stupid that, um, compromised our vow of "world-class customer service". I'm not going to say anything more (no, nobody was killed, and I didn't lose my job).
Anyway, I feel like an idiot tonight, while I'm doing the recovery thing. Tomorrow, I may be looking for a job. Anybody know any good truck-driving schools?
--Walt Weaver
Bozeman, Montana, USA
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 11/14/2000 5:55 PM
Here's a new recipe I discovered today for putting egg on my face:
(you can see where this is going, right<grin>).
3. Call up Oracle Support about a completely different problem.
4. While on the phone with the support analyst, "bounce" database instance to change a parameter setting.
5. Discover that instance won't start because files are missing.
6. Mutter various words that should be deprecated from the English language<grin>.
7. Defer discussion of original problem until you can rebuild the database.
8. Imagine support analyst laughing after she hangs up the phone.
It's very important to do steps 4-7 while on the phone with a knowledgeable Oracle professional, so that you can maximize the exposure of your utterly stupid act of deleting your database files while your database is running.
I should know better. It was a test database, and because of that I got a bit too cavalier with it. I paid by spending a couple of hours recreating the database from scratch. On the positive side, the support call involved some database links that I couldn't seem to drop. Trashing the entire database took care of that problem quite nicely<grin>.
Best regards,
Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: jonathan_at_gennick.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: wweaver_at_rightnow.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 mayReceived on Fri Nov 17 2000 - 10:03:54 CST
 |
 |