Name
DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR (Oracle8 Only)
Synopsis
The UNREGISTER_PROPAGATOR procedure revokes the privileges granted to make a particular user the local database propagator.
PROCEDURE DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR
(username IN VARCHAR2,
timeout IN INTEGER DEFAULT dbms_lock.maxwait);I recommend using the same username as the propagator at all database sites. Also, make sure that the account is the same as the replication administrator (REPADMIN) account.
Parameters
Parameter Name | Description |
|---|---|
username | Name of the account for which privileges are to be revoked |
timeout | Number of seconds to wait if the propagator account is in use when the call to UNREGISTER_PROPAGATOR is made |
Exceptions
Exception Name | Number | Description |
|---|---|---|
missingpropagator | –23357 | User username is not a propagator. |
propagator_inuse | –23418 | The propagator account is in use, and timeout seconds have elapsed. |