Re: Rollback

"Shredder" <shred_at_shredder.com> wrote in message news:d6Djf.122$%j.90_at_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
>
>

Another Note; This is running on a Netware 5.1 Server. Received on Thu Dec 01 2005 - 07:47:08 CST