Originally posted by abhaysk
Will Undo Store Blocks Or Rows Or Data Spcific to Columns?

I wonder, how it will just keep the data pertaining to the Column/s In Question for Updates?

Does Oracle Break the block and peep into it, find the row, and then find the column/columns and keep only that data in UNDO?
Yes, that's exactly what it does.

Will Undo Store Blocks Or Rows Or Data Spcific to Columns?
Rows or data specific to couluns - depending what operation has been performed (DELETE or UPDATE). For INSERT it stores only ROWID of the inserted row.

If this is the case, then I would assume I dunno a bit of Oracle.
You said that.