Hi Experts,
I got a doubt regarding the concept of 'Row Migration'.
From http://www.akadia.com/services/ora_chained_rows.html :
Migrate a row when an update to that row would cause it to not fit on the block anymore (with all of the other data that exists there currently)
But I'm getting confused is -- all the blocks will be of same size right (say 4 kb). Then migrating a row(say of 8 Kb) to another block (again of same 4 Kb), how 'll that help?
I can understand the concept of 'Row Chaining' where data is shared/divided into multiple blocks.
A nice article by Hans Forbich (but still not getting Row migration properly) -- https://forums.oracle.com/message/1806755#1806755
Am I getting the concept of 'Migration' wrongly? Please rectify me.
Help much appreciated.
Thanks,
Ranit