Rollback segments & Transactions

Hi

I have the following problem, can anyone help?

We are trying to delete the contents of a tables, but it is quite large so therefore the rollback segment is either not large enough or I require some additional rollback segments.

After looking through Oracle manuals etc. I found that in order to estimate the number of rollback segments I should apply the formula below:

No. of Transactions/Transactions per rollback segment

How do I define a transaction, is it every commit that is made, or is it every database command made?

Also, how do I decide upon how large I should make the rollback segment?

Thanks

Paul Received on Fri May 10 1996 - 00:00:00 CEST