Hi raghu,
Lakshmi srinivasan is correct. So when u give commit Oracle finds another rollback segment and starts writing to that. So it is not enough if u have a single rollback segment bigger. If u have space u can have two rollback segments of the same size. Or else u should specify to which rollback segment oracle has to write the next transaction.
Karthi




Reply With Quote