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. |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access