Or you could open the database read only... RF Robert G. Freeman Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press) Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf ----- Original Message ---- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx> To: "joe_dba@xxxxxxxxxxx" <joe_dba@xxxxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, August 26, 2009 7:41:37 PM Subject: RE: how to make a delete statement fail How about: alter tablespace <tablespace_where_that_table_lives> read only; Obviously, not good on a production system, but since you mentioned this is to test a code path and (presumably) in a development instance, it should work. -Mark ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith [joe_dba@xxxxxxxxxxx] Sent: Wednesday, August 26, 2009 21:20 To: oracle-l@xxxxxxxxxxxxx Subject: how to make a delete statement fail How do I make a correct DELETE statement fail? I have a developer that wants to test a code branch and he needs a delete statement to fail. It can’t be locked ( shared or exclusive ) from a separate session or be an incorrect statement or return “0 rows deleted.” It has to be “delete from table where col = value”. How can I force that to fail? thanks. ________________________________ Windows Live: Keep your friends up to date with what you do online. Find out more.<http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009> -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l