I am using SQL Loader to load a text file into an Oracle table. This works ok.

I have a trigger set up to insert into an audit table whenever I insert into the other table when I do the load.

However, it is writing an audit record as many times as sql loader commits during the load.

I realise I ccould increase the amount of records loaded before sql loader commits, but I dont want to put a huge strain on the rollback segments.

Are there any suggestions. I am thinking that I may have to do a bit of tricky coding with the trigger!

Here is my trigger code. Pretty simple.

create or replace trigger sales_data_trig
after insert on detail_rep
begin
if inserting then
insert into sales_audit values( sales_audit_seq.nextval, 'LOAD SALES DATA', sysdate, 'N');
end if;
end;