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: tough choices

Re: tough choices

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 18 Jun 2004 20:33:09 +0100
Message-ID: <40d3436c$0$280$cc9e4d1f@news-text.dial.pipex.com>


"Michael Austin" <maustin_at_firstdbasource.com> wrote in message news:LVGAc.1638$XX2.367_at_newssvr23.news.prodigy.com...
> So which is correct? HJR says that "transactions" don't survice only
> the select statements. Howard, isn't a select statement ALWAYS a part of
> a transaction? Daniel, just curious, but have you tested the durability
> and survivability of "transactions" and what were those finding?
> Example: Bank transaction moving $$$ from one account to another... and
> yanking the power cord in the middle etc...

Insert/Update/Delete do not qualify for TAF. (in 9i anyway and I would imagine 10g). Select does. Your example involves modifying data and would not survive. A report on the balances probably would.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Fri Jun 18 2004 - 14:33:09 CDT

Original text of this message

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