Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback

Re: Rollback

From: Shredder <shred_at_shredder.com>
Date: Thu, 01 Dec 2005 13:47:08 GMT
Message-ID: <w9Djf.126$%j.48@tornado.ohiordc.rr.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US