Hi All,

I have a table that has 90 million records and all I want to do is a simple update, add a flag to each record based on the criteria of the update statement but it keeps on crashing on me. I can't believe that Oracle 8i can't handle 90 million records so there must be something else going on. Can anyone tell me what I am doing wrong or whether there is something happening in the background that is causing the update statement to crash?

Thanks,
Edward