Re: rollback segment too small

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Sat, 13 Jun 1998 22:32:38 +0200
Message-ID: <6lumi2$pb9$1@news.worldonline.nl>

Ong Chin Hui wrote in bericht <35820845.273903144_at_butler.psa>...
>I have an application that keep hitting 'rollback segment too small'
>problem. The reason is likely due to a large table with a lots of
>update/insert.

Try selecting 10000 records at a time:
  select ...
   ... where rownum < 10000

And run the program a few times untill all is processed.

1 Gbyte rollback is quite large. Are u sure u dont get "snapshot too old" error (1555) ?

Good luck, Roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife Received on Sat Jun 13 1998 - 15:32:38 CDT