Advance Replication Conflicts

27 Aug

menurut http://download-east.oracle.com/docs/cd/B13789_01/server.101/b10732/repconfl.htm , jika menggunakan Advance Replication maka akan terjadi Conflict, type – tye conflict yang mungkin terjadi adalah :
1. Uniqueness Conflicts
2. Update Conflicts
3. Delete Conflicts

contoh Uniqueness Conflicts
misalkan pada saat bersamaan [selisih milli second / second / belum sampai schedulle push terjadi] di sisi kantor pusat [sid = orcl1] dengan kantor cabang [sid = orcl2], dilakukan insert data dengan kolom PK yang sama
SQL> conn scott/tiger@orcl1
SQL> insert into dept values (60,’orcl1′,’orcl1′);
SQL> commit;

SQL> conn scott/tiger@orcl2
SQL> insert into dept values (60,’orcl2′,’orcl2′);
SQL> commit;

maka akan terjadi Uniqueness Conflicts
replikasi_conflicts_01

replikasi_conflicts_02

replikasi_conflicts_03

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: