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

Home -> Community -> Mailing Lists -> Oracle-L -> sqlloader question re triggers

sqlloader question re triggers

From: John Dunn <john.dunn_at_sefas.co.uk>
Date: Thu, 30 Nov 2000 13:15:03 -0000
Message-Id: <10696.123315@fatcity.com>


I have amended a table to add a column that is now updated via a inser trigger.

I want to unload data from the current version of the table(which does not have this field), and reload into the version of the table.

If I omit the new field in my sqlloader control file, will loading data with sqlloader cause insert triggers to be executed, and thus this column to be updated?

John Received on Thu Nov 30 2000 - 07:15:03 CST

Original text of this message

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