This content has been marked as final. Show 1 reply
ORA-26687 indicates that the apply does not know the scn of source table at which the target table was instantiated. If you used datapump to instantiate the data from the source to the target database the instantiation scn should have been set automatically as part of the import. The datapump export/import should take place after the capture is created and the rules are added to capture for those tables to be replicated.
If you used some other method to instantiate the data at the target database, then hopefully you know the source scn at which you copied the data. Then, using that scn you use the dbms_apply_adm.set_table_instantiation_scn to let the apply know the source table scn. This is how Streams identifies the point at which to start applying changes.