What if job aborts after 50% or more is done ?
Posted: Fri Feb 16, 2007 10:57 am
I have a random question just came up in my mind.
For eg.
-Suppose I want to do UPSERT 2M rows in oracle table.
-Now due to some reasons the job is aborted after processing 1M rows.
-Either I can reset the job and run again or look for another option as 50% work is done.
-I will go for another option.
Help me in the logic:
-What if I make a temporary reference table if 50% or more rows are processed and give commit to both tables( original and temp) when job is aborted.
-Now I can use this temp table as look up when I start the job again so alot of time is saved.
Please suggest.
For eg.
-Suppose I want to do UPSERT 2M rows in oracle table.
-Now due to some reasons the job is aborted after processing 1M rows.
-Either I can reset the job and run again or look for another option as 50% work is done.
-I will go for another option.
Help me in the logic:
-What if I make a temporary reference table if 50% or more rows are processed and give commit to both tables( original and temp) when job is aborted.
-Now I can use this temp table as look up when I start the job again so alot of time is saved.
Please suggest.