Hi

Try it in the following way..

Select 'all the columns you need to keep', date1 date2 into newtable
from oldtable

Then remove the oldtable, if required rename the new table to old table
name.


Thanks
Sim


-----Original Message-----
From: dgaikwad
[mailto:oracledba-ezmlmshield-x54511279.[Email address protected]
Sent: Monday, October 08, 2007 9:28 AM
To: LazyDBA Discussion
Subject: Update Takes Lot Of Time

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.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page