I have a query:
u get ora-1562 error. u checked v$rollstat table and found
that a rollback segment has status 'FULL'. now, if u make that roll back
segment offline, and then online, the status 'FULL' will be removed. My
question is, during the course of this period, what will happen for those
uncommitted transactions residing in this rollback segment?