Run SQL without transactions

It is posible to run a large sql statement without be a transaction. In other words, one statement that write to rollback segments (update, delete or insert) and need a commit, it is posible that i can execute these statement without need to do a commit.
I need this for a large statement that move data between two tables and causes that the rollback segment be fully and return back without do the statement.
If it is posible, how I can do it?

Thanks. Received on Mon May 29 2000 - 00:00:00 CDT