Hi,
Have set up a nice database link to a sql server box from an Oracle 9i server. My mission is to populate a sql server table with an record from an oracle table after an insert. Is the best way to do this just a insert trigger or is there a better way ? Only expect about 100 records a day but the "live" timing is critical.
Thanks, Steve.
Have set up a nice database link to a sql server box from an Oracle 9i server. My mission is to populate a sql server table with an record from an oracle table after an insert. Is the best way to do this just a insert trigger or is there a better way ? Only expect about 100 records a day but the "live" timing is critical.
Thanks, Steve.