11 Mayıs 2014 Pazar

ORA-01595: error freeing extent (3) of rollback segment



Problem:
------------

SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (198))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [12], [2], [], [], [], [


Solution:
-----------
Adding more undo space should solve the problem.


Following link explain add undo tablespace:
-------------------------------------------

http://dbafix.blogspot.com.tr/2010/08/how-to-drop-and-recreate-undo.html

Hiç yorum yok:

Yorum Gönder