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: UNDO and Rollback tablespace

Re: UNDO and Rollback tablespace

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 26 Jun 2002 21:57:37 +0100
Message-ID: <3d1a2ac3$0$8511$cc9e4d1f@news.dial.pipex.com>


"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:afck6p01eqh_at_drn.newsguy.com...
> In article <3d19c937$0$225$ed9e5944_at_reading.news.pipex.net>, "Niall
says...
> >
> >If you have code that issues set transaction use rollback segment blah
you
> >might get unexpected behaviour from your app.
> >
> Not if you set UNDO_SUPPRESS_ERRORS=TRUE in your (preferably server)
parameter
> file you shouldn't. The statement (and the error) are just ignored then.
>
> Pete

Thanks for the info. sounds a little too 'magic bullet' like to me but worth knowing.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Jun 26 2002 - 15:57:37 CDT

Original text of this message

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