April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed Systems
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,
Start your free trial
Name
DBMS_DEFER_SYS.SET_DISABLED
Synopsis
The SET_DISABLED procedure disables or enables propagation to the specified destination. If you are managing a replicated environment, you might want to disable propagation to a given site while you perform maintenance. If you disable propagation while RPCs are being delivered to the destination database, the delivery will be allowed to complete.
PROCEDURE DBMS_DEFER_SYS.SET_DISABLED
(destination IN VARCHAR2,
disabled IN BOOLEAN := TRUE);Parameters
Parameter Name | Description |
|---|---|
destination | Global name of the destination database |
disabled | Flag indicating whether calls are to be disabled (TRUE) or enabled (FALSE) |
If disabled is set to TRUE, propagation to the destination is disabled, although any transactions in progress are allowed to complete. If disabled is set to FALSE, propagation to the destination is enabled, although this does not call EXECUTE.
Exceptions
Exception Name | Number | Description |
|---|---|---|
NO_DATA_FOUND | –01403 | Specified destination is not in the DEFSCHEDULE data dictionary view. |
Restrictions
You must execute a COMMIT after a call to the SET_DISABLED procedure for the changes to take effect.