UNREGISTER_PROPAGATOR Procedure

To unregister a user as the propagator from the local database. This procedure:

• Deletes the specified propagator from DEFPROPAGATOR.
• Revokes privileges granted by REGISTER_PROPAGATOR from the specified user (including identical privileges granted independently).
• Drops any generated wrappers in the schema of the specified propagator, and marks them as dropped in the replication catalog.

Syntax

DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR (
   username  IN  VARCHAR2
   timeout   IN  INTEGER DEFAULT DBMS_LOCK.MAXWAIT);

Parameters

Table 14-30 UNREGISTER_PROPAGATOR Procedure Parameters  

Parameter	Description
username	Name of the propagator user.
timeout	Timeout in seconds. If the propagator is in use, then the procedure waits until timeout. The default is DBMS_LOCK.MAXWAIT.

Exceptions

Table 14-31 UNREGISTER_PROPAGATOR Procedure Exceptions  

Parameter	Description
missingpropagator	Specified user is not a propagator.
propagator_inuse	Propagator is in use, and thus cannot be unregistered. Try later.