SQL Insert with large dataset

Question

When running a query like "insert into table " how do we handle the commit size? I.e. are all records from anotherTable inserted in a single transaction OR is there a way to set a commit size?

Thanks very much ~Sri PS: I am a first timer here, and this site looks very good!

Answer 1

In good databases that is an atomic statement, so no, there is no way to limit the number of records inserted - which is a good thing!

Answer 2

In the context that the original poster wants to avoid rollback space problems, the answer is pretty straightforward. The rollback segments should be sized to accpomodate the size of transactions, not the other way round. You commit when your transaction is complete.