GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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:

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center