Re: How to avoid rollback during some INSERTs ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 31 Jan 1999 14:20:31 -0000
Message-ID: <917792417.26141.0.nnrp-03.9e984b29@news.demon.co.uk>

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
>
Received on Sun Jan 31 1999 - 08:20:31 CST