Re: How to avoid rollback during some INSERTs ?

From: Nuno Guerreiro <nuno-v-guerreiro_at_invalid.telecom.pt>
Date: Tue, 09 Feb 1999 11:20:38 GMT
Message-ID: <36c01967.590420099@news.telecom.pt>

On Sun, 31 Jan 1999 14:20:31 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>This probably won't help the original poster.
>Discrete Transactions may not revisit a block they have changed,
>so any attempt to insert a large number of rows into a table with
>2 indexes as a discrete transaction is likely to get oracle error
> ORA- 8175 discrete transaction restriction violated
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>
>kvsraju_at_my-dejanews.com wrote in message
>>
>>Hi,
>>There are transactions called DISCRETE transactions .Which don't use
>rollback
>>segments.
>>rgds
>>kvsraju_at_polaris.co.in
>>
>
>
>
>
>

Would anyone enlighten me on the usage of DISCRETE transactions? How do I tell SQL*Plus, for example, that I want to use DISCRETE transactions?

This would be marvellous in some situations, since I do lots of inserts, updates, deletes in large tables.

Thanks for any help,

Nuno Guerreiro

---

As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Tue Feb 09 1999 - 05:20:38 CST