Problem with Rollback segment

From: <dtang_at_minn.net>
Date: 1998/03/24
Message-ID: <eSVR.198$pK1.408627@ptah.visi.com>#1/1

Hi:

I got a very serious problem. I have a huge query to update a large table. It runs several hours, then dead with oraerr 01555. Snapshot too old, the rollback segment R05 is too samll. Then I creat a large rollbak segment O08, then use set Transaction use rollback segment r08, and run that query again.
After hours , it died again with same error 01555, but it still say: "roll segment Ror (or whatever other than R08) is too small".

I don't understand why the engine doesn't usr rollback segment I specified. Does anyone has any idea.

If anyone has experience running a large query, could you help me put on this one. My email address is dtang_at_minn.net

Thanks ahead

Dong Received on Tue Mar 24 1998 - 00:00:00 CST