help: update statement fill up rollback segment

Hi there,

I have the following update statement:

UPDATE table_name t1 SET a1 =
(SELECT b1 FROM other_table t2
 WHERE t1.a2 = t2.b2
 AND t1.a1 <> t2.b1);

The table has 10M rows and (t1.a1 <> t2.b1) is 90%+ true in the table. So it just fill up the rollback segment without finishing it. I thought about increasing the rollback segment but I don't think it's worth to create that huge space just for rollback. I would like to know is there a way to make the update commit in a certain interval or just simply make it doen't use rollback?

Thanx in advance.

Ed

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 17:10:05 CST