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

Home -> Community -> Usenet -> c.d.o.tools -> Oracle Replication using Triggers

Oracle Replication using Triggers

From: malamut70 <malamut70_at_my-deja.com>
Date: 2000/04/21
Message-ID: <8dqh7j$6cq$1@nnrp1.deja.com>#1/1

I am trying to figure out a replication problem using Oracle triggers. We are using Oracle 7.3.
The trigger is an AFTER DELETE trigger that INSERTS data into one table locally,i.e. on the same server, at a row level. Which means we are using the "for each row" option. My question is, if you are going to replicate would it be better to do a BEFORE DELETE. This, to me, means that you are replicating data BEFORE you commit to a delete. Is seems risky to commit to a DELETE after you want to replicate data to another table. I'm not very experience with triggers, so I am hoping someone with more experience can answer my question or confirm my theory. Thanks for any help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CDT

Original text of this message

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