maximum insert prior to commit

Anyone know what the maximum insert one can do prior to doing a commit? Is this dependence on the amount of rollback segment?

What are other alternatives that has been implemented to being able to rollback a large amount of insert? One suggestion has been to create a temporary
table and do a commit on the temporary table after each insert. if the user decides to commit the changes then the records are copied into the production table. otherwise the records in the temporary table are deleted.

Any solution/ideas?
Mark Walter
markw_at_fujiamerica.com Received on Thu Jun 05 1997 - 00:00:00 CDT