EXPIRE and DUE are date fields in table PARTS
All the values in DUE column are null (it's a newly added column)
For status='Active' the values for due should be populated with corresponding expire column values.
Doing this by
1.creation of temporary table
2.dropping indexes,triggers etc on old table and running them on this temp table
3. drop old table and rename temp table to actual table name
the above method is not acceptable by them.
I tried with simple update statement -- plz see code snippet but i may get rollback segment issue
when commit all the update records at once.
the rows matching the where condition are 12 million and the total rows in the table are 70 million
Please help me out with this.