Re: How to avoid rollback during some INSERTs ?

The best guide to it is in the tuning guide, roughly though

    set a flag in the init.ora something like:

        discrete_tranactions_enabled = true     Use a PL/SQL block, and start with a call to

        dbms_transaction.begin_discrete_transaction     Set an exception handler on the block to catch

        dbms_transaction.discrete_transaction_failed     and repeat or rollback the transaction in the exception handler

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Nuno Guerreiro wrote in message <36c01967.590420099_at_news.telecom.pt>...
>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.
Received on Tue Feb 09 1999 - 14:34:59 CST