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?
Pao de dabba
Oracle will NOT take the RBS offline until the transactions complete. They either have to be comitted or rolled back. Only then they are taken offline.
Click Here to Expand Forum to Full Width