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