status of rollback segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: status of rollback segment

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    23
    hello, every one here
    I altered a rollback segment to offline and found that the status of this segment in dba_rollback_segs was online,it was because that an active transaction was on this segment.So I rollbacked this transaction,and the status of this segment is still be online.
    I had thought it should be offline soon after the active transaction on it finished.

    Is there anyone can tell me why?
    Thanks in advance

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    If you rolled back the transaction, you would have to issue the command again to take it offline.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width