Hi all,
When there is a change to an existing row in a block, or an insertion of a row to a block, does Oracle re-write the whole block (causing a rearrangement/packing of the rows in the block) ?
Assuming, In a block, I have
[row 1] [xxx] [row2] [xxxx] [row3] [xxxxxxxxx]
whereby xxx are freespaces created due to previous deletes.
q1) If i need to update row1 and it requires 5 * x of space, how will row1 looks like in the block (given that it has only 3x of space trailing it, but there are plenty of spaces around) in that particular block
Regards,
Noob