Re: UNDO and Rollback tablespace

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
>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK
>*****************************************
>Please include version and platform
>and SQL where applicable
>It makes life easier and increases the
>likelihood of a good answer
>
>******************************************
>"David" <davidlee_at_diamond.com> wrote in message
>news:aetlv1$b9j1_at_imsp212.netvigator.com...
>> Hi all,
>> I read the manual and know that in Oracle9i, there is UNDO tablespaace
>> (instead of the rollback tablespace). Should I use UNDO in 9i? What are
>the
>> disadvantages in using UNDO? It seems that there are so many advantages
>with
>> UNDO tablespace.
>>
>> Thanks
>> David
>>
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Jun 26 2002 - 09:47:53 CDT