Can't drop UNDO tablespace - active rollback. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Can't drop UNDO tablespace - active rollback.

  1. #11
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    It was the active transaction somehow 'stuck' in the offline (corrupted) undo TBS. As the segment held an active transaction the DB kept trying to resolve it and wouldn't let me drop the TBS.

    As you say - weird.

  2. #12
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    (12) Check the alert log for any errors - if all looks pukka then shutdown and take another backup. (You know it makes sense)
    Is that a relative of the Kabuki dance?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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