Re: Rollback segment problem

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/13
Message-ID: <8i58au$610$1@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
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Kari Pannila wrote in message <394621BA.D99691B4_at_tietoenator.com>...


>

>

>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.

>

>

Received on Tue Jun 13 2000 - 00:00:00 CDT