Size of row

[Chucks_k]

Hi all,

We have a case of chained rows in one of our tables. I have the head_rowid of the offending row from the chained_row table. How do i go about finding the actual size of the row and then copying that particular row into a temporary dummy table?

Thanks in advance,
Chucks_k

[DaPi]

All that just for ONE row?

[Chucks_k]

I would just like an idea on how to do it..It might come in handy at a later stage.

Thanks.

[slimdave]

How about copying the offending row into a new table, analyzing the table, and reading avg_row_len from user_tables?

[Chucks_k]

Hi thanks for that...how do i identify the particular row from the head_row id ??

Thanks..

[slimdave]

the head rowid is the rowid for the entire row, no?