repl_purge
purges transactional replication logs for specified account
repl_purge
(in server varchar,
in account varchar);
Description
This procedure purges transactional replication logs for specified account.
Logs whose start replication level lags more than
REPL_MAX_DELTA (1000000000) transactions behind current replication level of
a specified account are removed. After repl_purge() is
finished next repl_purge() run is scheduled
using SYS_SCHEDULED_EVENT facility.
Account sync requests from subscribers are delayed while
repl_purge() is running for this account.
Parameters
server –
The server name of the publisher.
account –
The name assigned to the publication.
Example
Purging transactional replication logs
The following shows purging transactional replication logs for
pushback account for updateable subscription 'demopub' from 'demoserver':
SQL> repl_purge ('demoserver', '!demopub');