Rollback - How to avoid..

Is there a way to disable rollback ? I seem to be wasting a lot of time in writing
PL/SQL scripts to update huge tables because the rollback segments would fill up.

What I am looking for is this:

SQL>  SET rollback off;
SQL> UPDATE huge_table  SET  col_name =  silly_function(col_name);
SQL>  CREATE another_huge_table as SELECT *  FROM huge_table;
SQL>  COMMIT;

TIA! Ajit Received on Sat Nov 07 1998 - 21:36:03 CET