Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REFRESH.MAKE

Purpose

To specify the members of a refresh group and the time interval used to determine when the members of this group should be refreshed. For additional information, refer to

Syntax

The parameters for the MAKE procedure are described in Table 12 - 59. The syntax for this procedure is shown below:

DBMS_REFRESH.MAKE(
	name					IN 	VARCHAR2,
	list 				IN 	VARCHAR2,   |
						IN	DBMS_UTILITY.UNCL_ARRAY,
	next_date				IN 	DATE,
	interval 				IN 	VARCHAR2,
	implicit_destroy		IN 	BOOLEAN DEFAULT FALSE,
	lax 					IN 	BOOLEAN DEFAULT FALSE,
	job 					IN 	BINARY INTEGER DEFAULT 0,
	rollback_seg 			IN 	VARCHAR2 DEFAULT NULL,
	push_deferred_rpc 	IN 	BOOLEAN DEFAULT TRUE,
	refresh_after_errors	IN	BOOLEAN DEFAULT FALSE)

parameter description
name Unique name used to identify the refresh group. Refresh groups must follow the same naming conventions as tables.
list Comma-separated list of snapshots that you want to refresh. (Synonyms are not supported.) These snapshots can be located in different schemas and have different master tables; however, all of the listed snapshots must be in your current database.
Instead of a comma separated list, you can supply a PL/SQL table of names of snapshots that you want to refresh using the datatype DBMS_UTILITY.UNCL_ARRAY. If the table contains the names of N snapshots, the first snapshot should be in position 1 and the N + 1 position should be set to null.
next_date Next date that you want a refresh to occur.
interval Function used to calculate the next time to refresh the snapshots in the group. This field is used with the NEXT_DATE value. For example, if you specify NEXT_DAY(SYSDATE+1, ''MONDAY'') as your interval, and your NEXT_DATE evaluates to Monday, Oracle will refresh the snapshots every Monday. This interval is evaluated immediately before the refresh. Thus, you should select an interval that is greater than the time it takes to perform a refresh. For more information on how to specify a refresh interval, see .
implicit_destroy Set this argument to TRUE if you want to automatically delete the refresh group when it no longer contains any members. This flag is only checked when you call the SUBTRACT procedure. That is, setting this flag still allows you to create an empty refresh group.
lax A snapshot can belong to only one refresh group at a time. If you are moving a snapshot from an existing group to a new refresh group, you must set the LAX flag to TRUE to succeed. Oracle then automatically removes the snapshot from the other refresh group and updates its refresh interval to be that of its new group. Otherwise, the call to MAKE generates an error message.
job This parameter is needed by the Import utility. Use the default value, 0.
rollback_seg Name of the rollback segment to use while refreshing snapshots. The default, null, uses the default rollback segment.
push_deferred_rpc Used by updatable snapshots only. Use the default value, TRUE, if you want to push changes from the snapshot to its associated master before refreshing the snapshot. Otherwise, these changes may appear to be temporarily lost.
refresh_after_errors Used by updatable snapshots only. Set this parameter to TRUE if you want the refresh to proceed even if there are outstanding conflicts logged in the DefError view for the snapshot's master.

Table 12 - 59. Parameters for DBMS_REFRESH.MAKE

parameter	description
`name`	Unique name used to identify the refresh group. Refresh groups must follow the same naming conventions as tables.
`list`	Comma-separated list of snapshots that you want to refresh. (Synonyms are not supported.) These snapshots can be located in different schemas and have different master tables; however, all of the listed snapshots must be in your current database. Instead of a comma separated list, you can supply a PL/SQL table of names of snapshots that you want to refresh using the datatype DBMS_UTILITY.UNCL_ARRAY. If the table contains the names of N snapshots, the first snapshot should be in position 1 and the N + 1 position should be set to null.
`next_date`	Next date that you want a refresh to occur.
`interval`	Function used to calculate the next time to refresh the snapshots in the group. This field is used with the NEXT_DATE value. For example, if you specify NEXT_DAY(SYSDATE+1, ''MONDAY'') as your interval, and your NEXT_DATE evaluates to Monday, Oracle will refresh the snapshots every Monday. This interval is evaluated immediately before the refresh. Thus, you should select an interval that is greater than the time it takes to perform a refresh. For more information on how to specify a refresh interval, see .
`implicit_destroy`	Set this argument to TRUE if you want to automatically delete the refresh group when it no longer contains any members. This flag is only checked when you call the SUBTRACT procedure. That is, setting this flag still allows you to create an empty refresh group.
`lax`	A snapshot can belong to only one refresh group at a time. If you are moving a snapshot from an existing group to a new refresh group, you must set the LAX flag to TRUE to succeed. Oracle then automatically removes the snapshot from the other refresh group and updates its refresh interval to be that of its new group. Otherwise, the call to MAKE generates an error message.
`job`	This parameter is needed by the Import utility. Use the default value, 0.
`rollback_seg`	Name of the rollback segment to use while refreshing snapshots. The default, null, uses the default rollback segment.
`push_deferred_rpc`	Used by updatable snapshots only. Use the default value, TRUE, if you want to push changes from the snapshot to its associated master before refreshing the snapshot. Otherwise, these changes may appear to be temporarily lost.
`refresh_after_errors`	Used by updatable snapshots only. Set this parameter to TRUE if you want the refresh to proceed even if there are outstanding conflicts logged in the DefError view for the snapshot's master.