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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald Sent: Wednesday, October 07, 2009 11:47 AM To: 'sims@xxxxxxx'; oracle-l@xxxxxxxxxxxxx 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 dofreeman@xxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of April Sims Sent: Wednesday, October 07, 2009 11:42 AM To: oracle-l@xxxxxxxxxxxxx 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? thanks April Sims SELECT IOUG Contributing Editor http://aprilcsims.wordpress.com OCP 8i, 9i, 10g DBA Southern Utah University sims@xxxxxxx 940-484-4276 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l