DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Size of row

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    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

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Question

    All that just for ONE row?

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    I would just like an idea on how to do it..It might come in handy at a later stage.

    Thanks.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    How about copying the offending row into a new table, analyzing the table, and reading avg_row_len from user_tables?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Dec 2001
    Posts
    337
    Hi thanks for that...how do i identify the particular row from the head_row id ??

    Thanks..

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    the head rowid is the rowid for the entire row, no?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width