Adding new column for large table with online redefinition
From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Fri, 30 May 2014 19:07:03 +0000
Message-ID: <BAY173-W19971590C9C950AAD4EE0985270_at_phx.gbl>
Lists
We are adding a new column for a real large table (60+ million rows) and will update the column value from another table based on a matching condition. With normal update and merge statement, its taking around 70 and 58 hours respectively. We are exploring an option using online redefinition method. Is it possible to using the SQL on the column mapping string. Any suggestions or insights will be much helpful for us. Thanks for you help.
ThanksPrabhu
Date: Fri, 30 May 2014 19:07:03 +0000
Message-ID: <BAY173-W19971590C9C950AAD4EE0985270_at_phx.gbl>
Lists
We are adding a new column for a real large table (60+ million rows) and will update the column value from another table based on a matching condition. With normal update and merge statement, its taking around 70 and 58 hours respectively. We are exploring an option using online redefinition method. Is it possible to using the SQL on the column mapping string. Any suggestions or insights will be much helpful for us. Thanks for you help.
ThanksPrabhu
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 30 2014 - 21:07:03 CEST