Update Conflict Resolution for Oracle Streams
edited Feb 17, 2010 10:26PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hello,
I want to setup an Update Conflict Resolution for Oracle Streams. I set an update resolution for the tables that have single primary key column like this:
What should I do with tables that have a composite primary keys??? Please advice with an example.
Thanks,
I want to setup an Update Conflict Resolution for Oracle Streams. I set an update resolution for the tables that have single primary key column like this:
DECLARE
cols DBMS_UTILITY.name_array;
BEGIN
cols (1) := 'COM_PARTNUM';
cols (2) := 'MAN_ID';
DBMS_APPLY_ADM.set_update_conflict_handler (
object_name => 'CM.PASSIVE_PART_LEADFREE',
method_name => 'OVERWRITE',
resolution_column => 'MAN_ID',
column_list => cols
);
END;
/
What should I do with tables that have a composite primary keys??? Please advice with an example.
Thanks,
0