Andreas Korneliussen wrote: > Problem: > For holdable cursors, we will release the table intent lock when doing > commit on the transaction for the cursor. > > The table intent lock, prevents the system from doing a compress of the > table, causing all RowLocations to be invalid. In addition, it prevents > reuse of RowLocation for deleted + purged rows.
I think this last paragraph is an incorrect assuption. The table intent lock prevents other transactions from doing a compress, but not the transaction holding the lock. I think there are other situations where the RowLocation will become invalid, such as the transaction deleteing the row. Dan.
