Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: archiving records

Re: archiving records

From: Daud <daud11_at_hotmail.com>
Date: 28 Aug 2006 03:17:06 -0700
Message-ID: <1156760226.440981.312160@i42g2000cwa.googlegroups.com>


>
> Yes, *exactly*, 'assume'! *NO* guarantee whatsoever
> as
> a) you don't lock the table
> b) you break up your *logical* transaction into multiple *physical*
> transactions
> Basic violations against the ACID concept.
>
> Please do not top post.
>

What do you mean? I don't understand. Why the table has to be locked? Those rows with colA = 'ABC' will not be updated. No rows with colA='ABC' will be inserted. So, why lock the whole table? Received on Mon Aug 28 2006 - 05:17:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US