Yah, you could do it view a view and instead of trigger but it would be somewhat slower...


ops$tkyte@ORA9I.WORLD> create table t ( x int primary key, y varchar2(25) );

Table created.

ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> create or replace view v as select * from t;

View created.

ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> create trigger v_trigger
  2  INSTEAD OF INSERT on V
  3  begin
  4          insert into t values ( :new.x, :new.y );
  5  exception
  6          when dup_val_on_index then
  7                  update t set y = :new.y where x = :new.x;
  8  end;
  9  /

Trigger created.

ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> insert into t values ( 1, 'hello' );

1 row created.

ops$tkyte@ORA9I.WORLD> insert into t values ( 2, 'hello' );

1 row created.

ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> REM here is the "load"
ops$tkyte@ORA9I.WORLD> 
ops$tkyte@ORA9I.WORLD> insert into v
  2  select 1, 'goodbye' from dual
  3  union all
  4  select 3, 'hello' from dual
  5  /

2 rows created.

ops$tkyte@ORA9I.WORLD> select * from t;

         X Y
---------- -------------------------
         1 goodbye
         2 hello
         3 hello

 

darn.  I did it in 817

LOAD DATA
INFILE *
INTO TABLE OPS$TKYTE.V
REPLACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'"
trailing NULLCOLS
(x,y)
begindata
1,4
3,5

I just did that and it works for me.  I tried in 816 and sure enough, ORA-04043 object does not exist.

Sorry, I would go with the first method I suggested I guess.