Need to control the query

[polina]

Hi

I have this routine that copies one big table into another.
How would I control the process, so that in case something happens I could roll back the changes in the tables or do something else to make sure that all the data has been copied, etc.

Please if anybody has that routine, could you share?

I need urgently.

THanks a lot