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.

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

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`.

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