replication is not working when i did DML opetation
Posted on 2009-05-13
i have a problem with replication (one way)
I created a one-way table replication using streams. The replication would propagate to the target database almost immediately whenever a DML change was made on the source table. I then tried to pause the replication by stopping the apply process at the target database. I then proceeded to insert rows into the source table; and then restarted the apply [ e.g., dbms_apply_adm.start_apply( STRMS_APPLY_HB ) ]. The Streams subsystem is no longer propgating DML changes to the target table.
Did I miss something thats preventing this replication from being paused?
can any one help me