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: Problem with Rollback segment

Re: Problem with Rollback segment

From: <vacharya_at_umi.com>
Date: 1998/03/25
Message-ID: <6faun3$3hu$1@nnrp1.dejanews.com>#1/1

In article <eSVR.198$pK1.408627_at_ptah.visi.com>,   dtang_at_minn.net wrote:
>
> 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
>
>

The size of your rollback segment is not the problem in this case. Please verify that there aren't other queries updating the tables that your query is accessing.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 25 1998 - 00:00:00 CST

Original text of this message

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