SQL> desc dba_apply_error
select APPLY_NAME,LOCAL_TRANSACTION_ID,SOURCE_COMMIT_SCN,MESSAGE_NUMBER,ERROR_MESSAGE from dba_apply_error;
得到SOURCE_COMMIT_SCN
3、然后在源库执行
SQL> begin
2 DBMS_APPLY_ADM.set_table_instantiation_scn(source_object_name => ''BASECONF.PUB_USER'',
3 source_database_name => ''BILLBJ.CHINACACHE'',
4 instantiation_scn => 34327911302);
5 end;
6 /
4、在目标库执行即可
BEGIN
DBMS_APPLY_ADM.EXECUTE_ERROR(
local_transaction_id => ''14.39.3430485'',
execute_as_user => FALSE,
user_procedure => NULL);
END;