Re: Uncommitted Data

The only thing i am not clear about is, If the data files contains following dirty blocks

update table set col1=2 where col1=3
update table set col1=4 where col1=5
Check point
update table set col1=6 where col1=7

Database crashes

Then i believe with the checkpoint information in the Log file only first two will be rolled forward and the third will be lost since it is niether followed by commit or checkpoint.  if the above is true, then what happens during the crash whick makes redo log roll forward the dirty blocks even though they are in the datafiles. Received on Thu Jun 16 2005 - 02:38:02 CDT