Re: How not to generate information of rollback?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 21 Jul 2001 21:24:26 GMT
Message-ID: <9hskas01a1e@drn.newsguy.com>

In article <3B40CA0C.89F054AA_at_d2mail.de>, Martin says...
>
>Have a look at discrete transactions. There are some restrictions but they will
>not generate rollback but redolog only.
>
>Martin
>
>

discrete transactions are depricated in Oracle8i (hidden init.ora parameter to even get them enabled).

They are only appropriate for single row inserts/updates/delete as you cannot revisit a block twice.

Very not appropriate for mass updates and inserts.

>
>none_at_inet.org wrote:
>>
>> For example, for a import or a massive update, I don´t generate
>> rollback information...
>>
>> like this?
>>
>> COMMIT;
>> SET TRANSACTION READ ONLY;
>> ...
>> ...
>> ...
>> COMMIT;
>>
>> thanx for your help!!!
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sat Jul 21 2001 - 16:24:26 CDT