space management in datablock on row updation

[shekhar pandey]

when a row's column value is updated [such as its length increases in length] so does this row push its adjacent row to create the space in order to accomodate the upated value , with in a data block

[davey23uk]

if there is not enough space in the row, you will get row migration - i.e the whole row moved and a pointer left to it

[shekhar pandey]

with in a block rows are filled up from bottom to up and they are adjacent to eac other , then if a row's size increases then does that row pushes its adjacent row to create space to accomodate the value

[shekhar pandey]

lets talk abt row migration , if rows are stored in datablock from bottom to up faishon then say if a row which is in bottom its increases in size due to updation then will that updated row be migrated or will it push its adjacent row and that its adjacent row and so on and the row in top will be migrated

[PAVB]

lets talk abt row migration , if rows are stored in datablock from bottom to up faishon then say if a row which is in bottom its increases in size due to updation then will that updated row be migrated or will it push its adjacent row and that its adjacent row and so on and the row in top will be migrated

Oh man… wouldn’t that particularly intriguing strategy migrate all rows? How did you manage to come out with such an idea? Think for a moment, relax… if you were designing Oracle, what would you do? Yes! just the affected row gets migrated!

[dba_shekhar]

with in a datablock rows are stored adjacent to eah other , when a size of row increases due to updation , does that row pushes its adjacent row to create space or how that updated value is stored with in the row ,

[davey23uk]

whole row migrated, pointer to it left in the original place