Re: Update view problem

In my sample, I get an error message:
update bobv set x='new' where x='old'

       *
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view Can you be more specific?

Could you not just simply run two updates?

    Update t1_at_db1
    set x='new'
    where x='old';

    Update t1_at_db2
    set x='new'
    where x='old';

Or if timing is a problem, then do one at a time.... Create a list of the x's which are old, then LOOP through the list doing the two updates for each individual item in the list... doing a COMMIT every 1 - n rows (as you see fit).

Also remember that your view is defined as UNION, which will sort and remove duplicates...you may want UNION ALL instead.

Robert Proffitt
Beckman Coulter
Brea, California

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 11:16:28 CST