Re: Rollback

From: Shredder <shred_at_shredder.com>
Date: Thu, 01 Dec 2005 13:43:37 GMT
Message-ID: <d6Djf.122$%j.90@tornado.ohiordc.rr.com>

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2005.12.01.04.07.33.175299_at_sbcglobal.net...
> On Wed, 30 Nov 2005 20:32:36 +0000, Shredder wrote:
>
>> Is it the size of a tablespace that limits the rollback segment?
>
> It's not about the size of the rollback segment, it's about how you use
> it.
> Show me your rollback segment, I'll show you mine.
>
> --
> http://www.mgogala.com
>

I Appologize, this stuff is pretty new to me. I have done some simple queries using SQL in the database but nothing very technical at all. This is a purge procedure that I am executing that was developed by our people that installed our system and are no longer in business. I guess it is time to start learning more about this. Can anyone reccomend some good books for entry level? Here is the error and again this is oracle 8i.

SQL> exec OPS_ARCHIVE_ALL;

begin

OPS_ARCHIVE_ALL; end;

ORA-01562: failed to extend rollback segment number 21

ORA-01628: max # extents (121) reached for rollback segment OBVIOUS3

ORA-06512: at "SYSADM.OPS_ARCH_AND_PURGE", line 36

ORA-06512: at "SYSADM.OPS_ARCHIVE_ALL", line 5

ORA-06512: at line 2 Received on Thu Dec 01 2005 - 07:43:37 CST