Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete data from table without rollback/logging?
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
-- Resources for OracleT: www.geocities.com/howardjr2000 ========================================= "Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0110060607.73094eaf_at_posting.google.com...Received on Sat Oct 06 2001 - 17:22:20 CDT
> 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.
![]() |
![]() |