Tuesday, September 20, 2011

Oracle Streams Apply

To tell Apply Process from Oracle Streams to ignore old values for columns at update or delete time: 

begin
dbms_apply_adm.compare_old_values(
object_name => '[nume_schema].[nume_tabela]',
column_list => '*',
operation => '*',
compare => FALSE);
end;
/

No comments:

Post a Comment