DELETE is not working in Bi-Diretional Streams Setup
Gurus,
We configured Bi-directional Streams setup between 11gR2 and 10gR2, and everything is working fine except DELETE on bulk records.
We had a table called TEMP in 11gR2, it contains 1200 records, as per the business we deleted 80% of the data and needs to load another set of data into that table. When we issued DELETE at source table..its worked fine. But at the destination side the same table is still showing the 1200 records after 4 hours too.
DBA_APPLY_ERROR does not return anything.
What would the cause and possible solutions for this?
Thanks,
Harry
We configured Bi-directional Streams setup between 11gR2 and 10gR2, and everything is working fine except DELETE on bulk records.
We had a table called TEMP in 11gR2, it contains 1200 records, as per the business we deleted 80% of the data and needs to load another set of data into that table. When we issued DELETE at source table..its worked fine. But at the destination side the same table is still showing the 1200 records after 4 hours too.
DBA_APPLY_ERROR does not return anything.
What would the cause and possible solutions for this?
Thanks,
Harry
0