Name
repl_purge — purges transactional replication logs for specified account
Synopsis
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
Example 24.340. 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');