-
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
B'ham
-
Pao,
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.
Nizar
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|