Re: archiving records

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 Aug 2006 12:05:18 +0200
Message-ID: <arf5f21pen1qi26i6bfhkn6lddk3ts8fsr@4ax.com>

On 28 Aug 2006 02:50:57 -0700, "Daud" <daud11_at_hotmail.com> wrote:

>Actually, I have over simplified the code too much. Here a slight
>modification to it.
>My concern is whether I have archived the same rows that have been
>deleted from the primary table. Assume that no new rows with colA =
>'ABC' will be inserted/updated when the code runs.
>
>Daud

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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Aug 28 2006 - 05:05:18 CDT