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: Sat, 6 Oct 2001 15:09:20 +1000
Message-ID: <3bbe91a2@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.
>
> Yong Huang
> yong321_at_yahoo.com
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:<3bbd8038_at_news.iprimus.com.au>...
> > Nope. It is utterly impossible to ever prevent rollback from being
> > generated by DMLs.
Received on Sat Oct 06 2001 - 00:09:20 CDT

Original text of this message

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