Hi All,
Have one query. This was asked in one of the interview and I couldn't answer so well. Need your expertise in understanding this process.
What is the best way to do the archiving process for large set of data.
Ex : I have to move 50 Million rows from Table A and insert into Table B and then delete those records from Table A. Its a transaction table(Table A) where the DMLs are happening and meanwhile need to carry the archive process. And the interviewer said, during the insertion to table B, how we can avoid getting the same records updated (which are getting inserted to table B) .
Thank you.