I need to update a huge table with many years of data.
The data I need to update is for year 2004. The script I wrote is:

update /*+PARALLEL */ facttable f set (a, b) = (select a, b from load_facttable)
where c=f.c)

This script would update the whole table. How could I make it only update data only for year 2004?

Thanks.