Hello ,
Oracle 9.0.1.0.0 on HP-UX 11.11
I am testing Procedural Replication in Multimaster Replication
Environment. (Asynchronous)
Package PACK_1 with a PROC_1 does insert in TAB_1. The procedure does
a simple insert in tab_1.
I mark PACK_1,PROC_1 for replication (Multimaster replication)
After starting replication , I execute procedure
execute proc_1 on Inst_1
But somehow this execution is not captured by replication & hence does
not fire on inst_2 which is second master site. I cannot see inserted
row in second instance.
AM I missing something ? I cld not find details on Procedural
Replication in manual except saying procedures need to be part of
package .
The reason I am looking at Procedural Repl is that I have many tables
which do not have primary key . So I cannnot use table level
replication for those tables.
Any help/pointers in this regad are highly appreciated ....
Thanks & Regards,
Mahesh Hardikar
Oracle 9.0.1.0.0 on HP-UX 11.11
I am testing Procedural Replication in Multimaster Replication
Environment. (Asynchronous)
Package PACK_1 with a PROC_1 does insert in TAB_1. The procedure does
a simple insert in tab_1.
I mark PACK_1,PROC_1 for replication (Multimaster replication)
After starting replication , I execute procedure
execute proc_1 on Inst_1
But somehow this execution is not captured by replication & hence does
not fire on inst_2 which is second master site. I cannot see inserted
row in second instance.
AM I missing something ? I cld not find details on Procedural
Replication in manual except saying procedures need to be part of
package .
The reason I am looking at Procedural Repl is that I have many tables
which do not have primary key . So I cannnot use table level
replication for those tables.
Any help/pointers in this regad are highly appreciated ....
Thanks & Regards,
Mahesh Hardikar