As a replication is a transactional process, you cannot suspend a single task. Either
alter remote subscription <name> reset;
which removes the subscription from being read, hence you must start with an initial load to bring the data back to the current & consistent state.
or
alter remote source <rs name> suspend capture;
alter remote source <rs name> resume capture;<br>
which pauses all subscriptions and hence does not cause data inconsistencies between the tables, thus can be resumed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.