Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: delete data from table without rollback/logging?

Re: delete data from table without rollback/logging?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 7 Oct 2001 08:22:20 +1000
Message-ID: <3bbf83c2$1@news.iprimus.com.au>


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...

> 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.
Received on Sat Oct 06 2001 - 17:22:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US