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: Update on one specific record crashes Oracle Server

Re: Update on one specific record crashes Oracle Server

From: Vjoshi2 <vjoshi2_at_aol.com>
Date: 3 Sep 1998 11:59:52 GMT
Message-ID: <1998090311595200.HAA11557@ladder01.news.aol.com>


Hi.
Perhaps your rollback segment has a problem. Try creating a temporary private rollback segment. Bring it online using

alter rollback segment rolnew online;

And then allocate that rollback segment for your transaction.. set transaction use rollback segment rolnew; update .....where .....

See if that does the trick.. Received on Thu Sep 03 1998 - 06:59:52 CDT

Original text of this message

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