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: Using triggers to populate history tables in Oracle 8, should I?

Re: Using triggers to populate history tables in Oracle 8, should I?

From: <coakleyj_at_hotmail.com>
Date: Wed, 10 Feb 1999 09:39:49 GMT
Message-ID: <79rk54$37i$1@nnrp1.dejanews.com>


Hi there.
entire transaction and
recovery should not be an issue.
(via SQL*Loader or insert /*+append*/ ), Equally well, if the table is in nologging mode, direct produce redo log entries and consequently recovery will not be this may be what your colleague was referring to. <79pko9$cmj6_at_musky.state.wi.us>,
<jeffedw_at_dhfs.state.wi.us> wrote:
new to Oracle 8. In Rdb I routinely
when records in the primary table
with some Oracle experience tells me I
Oracle 7/8 because if the database fails "trigger written" records will not be written Will an experienced Oracle DBA give me the straight dope on this? If true it
> sounds like a severe limitation to me.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 10 1999 - 03:39:49 CST

Original text of this message

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