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,
All that just for ONE row?
I would just like an idea on how to do it..It might come in handy at a later stage.
How about copying the offending row into a new table, analyzing the table, and reading avg_row_len from user_tables?
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio
Hi thanks for that...how do i identify the particular row from the head_row id ??
the head rowid is the rowid for the entire row, no?