This discussion is archived
11 Replies Latest reply: Feb 11, 2013 7:28 AM by Munish RSS

rollback issue

Munish Newbie
Currently Being Moderated

We have 8.1.7 oracle EE database running.
I got a message saying that RBS could not be extended , I looked into it and found out that the disk was out of space.
I created another RBS02 on another disk and shutdown the DB and restarted it.

Now there are errors in the alert.log that says RBS20 cannot be extended "ORA-1562" ERRORS.

I tried to take RBS20 offline, it says statement processed but it never takes it offline. It will not let me drop rollback segment. Now when I try to go into an application I get ORA-01562 ERRORS.

I tried to see if there was anything in these rollback segments and there is nothing. It is empty.

How can I remove them or fix them.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points