Oracle Database Discussions

Hi All,

I was wondering is there any fast method for updating 8 million records out of 10 million table?

For eg :

I am having a customer table of 10m records and columns are cust_id, cust_num and cust_name.

i need to update 8m records out of 10m customer table as follows.

update customer set cust_id=46 where cust_id=75;

The above statement will update 8m records. And cust_id is indexed.

But if i fire the above update statement we'll face rollback segment problem..

Even if i use ROWNUM and commit after 100K records still its gonna take huge time and also i know CTAS will be lot lot faster but for this scenario i guess its not possible.. Right?

Any help is much appreciated...
Thanks.