This discussion is archived
2 Replies Latest reply: Oct 10, 2012 11:05 AM by sb92075 RSS

Row chaining and row migration in Oracle 10g R2/11g R2

neemin Newbie
Currently Being Moderated
Hi,

Due to the business rule changes, one of the numeric column in a large table (20 millions rows) will be expanded from number(8) to number(10). Also, the values of this column of each row will be updated from 6 digits to 10 digits. All the indexes that use this column will be dropped and recreated after update. I would like to know if there is any row chaining or row migration issue in Oracle 10g R2 /11g R2.

Thanks for your help
  • 1. Re: Row chaining and row migration in Oracle 10g R2/11g R2
    sb92075 Guru
    Currently Being Moderated
    neemin wrote:
    Hi,

    Due to the business rule changes, one of the numeric column in a large table (20 millions rows) will be expanded from number(8) to number(10). Also, the values of this column of each row will be updated from 6 digits to 10 digits. All the indexes that use this column will be dropped and recreated after update. I would like to know if there is any row chaining or row migration issue in Oracle 10g R2 /11g R2.

    Thanks for your help
    It depends.

    what you do observe after TESTING against the Development DB?
  • 2. Re: Row chaining and row migration in Oracle 10g R2/11g R2
    jgarry Guru
    Currently Being Moderated
    [url http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1856720300346322149]More digits means more storage. Whether this results in rows not fitting in blocks (migration) depends on how much free space is in each block and how big exactly the numbers expand. The best way to know for sure is to test it and look for migration.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points