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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers on Import Data

Re: Triggers on Import Data

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 24 Oct 2005 20:19:18 -0700
Message-ID: <kpWdnamsqeNBPsDeRVn-qw@comcast.com>

"raghu" <raghu_vnin_at_yahoo.com> wrote in message news:1130209524.516560.208760_at_o13g2000cwo.googlegroups.com...
> I am looking to transfer the data from one database to another, both
> having the same structure.
> Which mechanism should be used so that the before insert triggers get
> triggered and act on the data, before it is inserted?
> Can this be achieved through export/import?
>
> Thanks.
>

A before trigger would work on data being imported provided they exist before you add the data.
Jim Received on Mon Oct 24 2005 - 22:19:18 CDT

Original text of this message

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