You are talking about updating a HUGE table and then "pausing" the process for a week?

Do you plan on doing a COMMIT during this process? Otherwise, you'll have issues with UNDO with this transaction.

I honestly don't think this is the best way to do this. As davey23uk mentioned, you should do the update in chunks.