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
Example24.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');