General Question on altering table without locking it [message #673551] |
Fri, 23 November 2018 08:47 |
srinivas.k2005
Messages: 404 Registered: August 2006
|
Senior Member |
|
|
Hi,
We have an application which access a table 24/7. We are trying to add new columns to the table and populate the data, it has 9 million data. I need to do this operation with zero downtime.Can you suggest any new functionality introduced in 11gR2 which add columns and populates the value offline without impacting or locking the table.
Normally we follow below options:
1. Create a copy of table add new columns and rename the table, this has two disadvantage as the data will be live i may miss few data and renaming of 10 million records may take more than 1 minute
Your suggestions are appreciated
Thanks,
SRK
|
|
|
|
|
|