Thanks for that info.

For batch deletes:

I set the rollbacksegment to a large one ("Large_RBS").

I run a procedure to delete the records for a table, and still to be on a safer end, I commit at the end of 1000 records.(inside the procedure)

Does this stop using the "Large_RBS".

Badrinath

While doing this