Re: delete data from table without rollback/logging?

[Quoted] On Sun, 7 Oct 2001 08:22:20 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

>Yes, and the hidden parameter is called _enable_discrete_transactions.
>Clearly, in 8i and above, they've made it less of a cloak-and-dagger affair
>that it used to be by knocking up a package that does what the parameter
>used to do. Big deal: you'll appreciate that discrete transactions have
>specific uses, and are unsuited for "regular" DML activity however they are
>enabled. In particular, they are designed to be used for short transactions
>that modify only a few blocks, and which never change an Oracle block more
>than once. That is not "regular DML" in my book, and doesn't sound like the
>kind of thing our original poster was wanting to do in any case.
>
>HJR
In addition to autonomous transaction, this discrete transaction thing is kinda interesting. From the doc, it says dbms_transaction.begin_discrete_transaction() is used to start a [Quoted] discrete transaction (how to end?), but no details. I need to know if this is suitable for deleting 1 million records from a 50 million records table without undo. Thanks in advance.

Dino Received on Sun Oct 07 2001 - 08:22:20 CEST