Re: Rollback segment problem
From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/13
Message-ID: <8i58au$610$1_at_mailint03.im.hou.compaq.com>#1/1
Date: 2000/06/13
Message-ID: <8i58au$610$1_at_mailint03.im.hou.compaq.com>#1/1
or try to delete small set of rows
delete mytable
where ......
and rownum < XXXX
where XXXX depends of row ad rollback's size.
-- be happy Eugenio [Quoted] remove _nospam from reply address [Quoted] Opinions are mine and do not necessarily reflect those of my company ======================================================= Kari Pannila wrote in message <394621BA.D99691B4_at_tietoenator.com>...Received on Tue Jun 13 2000 - 00:00:00 CEST
>
>
>Paolo Polce wrote:
>
>>
>> When I try to delete a huge number of rows in a table, I do sometimes
get
>> a message from oracle telling me that I reaced the maximum extent (100)
for
>> my rollback segment.
>> What I do is a "alter rollback segment myrbs shrink" then I retry the
>> operation and it goes...
>>
>> But... how should I fix the problem?
>>
>
> Increase the MAXEXTENTS for your rollback segments. Check also
> that there is enough space for the new extents in the tablespace.
>
>regards Kari
>
>(Mr.) Kari Pannila
> Oracle DBA (OCP)
>--
>
>PS. Delete X from my mail address , it (X) is only for SPAMMERS.
> Poista X mail-osoitteen edestä, se on SPAMmereita varten.
>
>