-
Size of row
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
-
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.
Thanks.
-
How about copying the offending row into a new table, analyzing the table, and reading avg_row_len from user_tables?
-
Hi thanks for that...how do i identify the particular row from the head_row id ??
Thanks..
-
the head rowid is the rowid for the entire row, no?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|