Disable Rollback Segments

Hello friends,
1) can I say to Oracle not to use the Rollback segments since I am updating huge Number of records.
2) Is it possible to cache a huge table (say with 10 million records) using dbms_...keep.
Please let me know your response as soon as possible
Regards,
Kumar

Replay

Hi,
You can make a PL/SQL with a commit interval, for example :
========================================================
declare
i number := 0;
cursor s1 is SELECT * FROM tab1 WHERE col1 = 'value1'
FOR UPDATE;
begin
for c1 in s1 loop
update tab1 set col1 = 'value2'
where current of s1;
i := i + 1; -- Commit after every X records
if i > 1000 then
commit;
i := 0;
end if;
end loop;
commit;
end;
========================================================
Before this, you can force to use a big rollback segment like this :
SQL>set transaction use rollback segment rbsbig;
Hope that help you.
gnom92.