RE: major blunders

From: Kenneth Naim <>
Date: Wed, 7 Oct 2009 11:57:03 -0400
Message-ID: <006b01ca4766$d52f3ec0$7f8dbc40$_at_com>

When copying and pasting delete and update statements into sqlplus put them on a single line if possible to avoid the possibility of missing the where clause.

-----Original Message-----

From: [] On Behalf Of Freeman, Donald
Sent: Wednesday, October 07, 2009 11:47 AM To: ''; Subject: RE: major blunders

Well, I always use a script to place the database name into the sql prompt. Making changes on the wrong database can ruin your whole day (or life).

So you need "do's" and "don'ts"

Donald Freeman
Database Administrator II
Commonwealth of Pennsylvania
Department of Health
Bureau of Information Technology
2150 Herr Street
Harrisburg, PA 17103  

-----Original Message-----

From: [] On Behalf Of April Sims
Sent: Wednesday, October 07, 2009 11:42 AM To:
Subject: major blunders

Compiling a list of major blunders to avoid:

Don't use the number 8 for scripting or ORACLE_SID due to the wild card character * above it.
Don't use rm *.*

Anyone else have some to contribute?


April Sims
SELECT IOUG Contributing Editor
OCP 8i, 9i, 10g DBA
Southern Utah University



-- Received on Wed Oct 07 2009 - 10:57:03 CDT

Original text of this message