Rollback segment problem

From: <tony.adolf_at_viaginterkom.de>
Date: Mon, 29 Mar 1999 09:27:57 GMT
Message-ID: <7dnh2n$oka$1@nnrp1.dejanews.com>

My database shitdown with the following error message in the alert log:

ORA-1595 error freeing extent(2) of rollback segment(9)
ORA-0604 error occured at recursive SQL level 1
ORA-1594 attempt to wrap into rollback segment 9 extent 2 which is being freed

I can see/guess that a rollback segment fails to get released and when an attempt is made to reuse it oracle falls over, but why?

Any clues.

thanks in advance

Tony Adolph

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 29 1999 - 03:27:57 CST