Re: Serializable transactions

> At the beginning of transaction 1 there were 3 rows in table
> ref_table_1. But at the time the delete takes place there
> are only two rows in that table therefore ORACLE knows
> that there have been changes during the transaction and the
> update is refused.
But why? The updated data are not concerned by the update... So my question changes : what defines the consitency of the data. In other words, when oracle decide to refuse a transaction? On a whole table when one single row has been updated? Thoms Received on Mon Jun 05 2000 - 00:00:00 CEST