Hi DBAs

Following Update SQL takes more than 8 hours.

Update TABLE1
set Date1=Date2;



Date1 and Date2 are from same table TABLE1 and of DATE type.

Machine Config is P4 with 512 MB RAM no other big Processes are running.
TABLE1 is having 78 lakh records.


can any body tell me alternarte way to do this update.


Thanks & Regards,
Dinesh G.

Oracle LazyDBA home page