Re: delete data from table without rollback/logging?

[Quoted] 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 [Quoted] 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 [Quoted] enabled. In particular, they are designed to be used for short transactions [Quoted] that modify only a few blocks, and which never change an Oracle block more [Quoted] than once. That is not "regular DML" in my book, and doesn't sound like the [Quoted] kind of thing our original poster was wanting to do in any case.

HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Yong Huang" <yong321_at_yahoo.com> wrote in message
news:b3cb12d6.0110060607.73094eaf_at_posting.google.com...


> No. I mean discrete transactions. You use BEGIN_DISCRETE_TRANSACTION


> procedure. It's in Chapter 16 of the Concept manual (8.1.7 or 8.1.6

> documentation).

>

> Yong Huang

> yong321_at_yahoo.com

>

> "Howard J. Rogers" <howardjr_at_www.com> wrote in message

news:<3bbe91a2_at_news.iprimus.com.au>...


> > There is a hidden parameter that allows that to happen, 'tis true (it


didn't


> > used to be hidden, but it is in 8i and 9i, -and we all know what hidden


> > parameters mean: "unsupported, and on your own head be it").

> >

> > But in any case, "regular" old DMLs can't make use of it, even so.

> > Regards

> > HJR

> > --

> > Resources for OracleT: www.geocities.com/howardjr2000

> > =========================================

> >

> >

> > "Yong Huang" <yong321_at_yahoo.com> wrote in message

> > news:b3cb12d6.0110052022.653b49dd_at_posting.google.com...

> > > I don't have real experience. But the documentation seems to say

> > > discrete transactions do not generate undo.