REGISTER_SNAPSHOT procedure

This procedure enables the administration of individual snapshots.

Syntax

DBMS_SNAPSHOT.REGISTER_SNAPSHOT (
   snapowner   IN   VARCHAR2,
   snapname    IN   VARCHAR2,
   snapsite    IN   VARCHAR2,
   {snapshot_id IN   DATE | BINARY_INTEGER,
   flag        IN   BINARY_INTEGER,}
   qry_txt     IN   VARCHAR2,
   rep_type    IN   BINARY_INTEGER := DBMS_SNAPSHOT.REG_UNKNOWN);

Note: This procedure is overloaded. The snapshot_id and flag parameters are mutually exclusive.

Parameters

Table 8-313 REGISTER_SNAPSHOT Procedure Parameters

Parameter	Description
sowner	Owner of the snapshot.
snapname	Name of the snapshot.
snapsite	Name of the snapshot site for a snapshot registering at an Oracle8 or greater master. This name should not contain any double quotes.
snapshot_id	The identification number of the snapshot. Specify a version 8 snapshot as a BINARY_INTEGER. Specify a version 7 snapshot registering at an version 8 or greater master sites as a DATE.
flag	PL/SQL package variable indicating whether subsequent CREATE or MOVE statements are registered in the query text.
query_txt	The first 32,000 bytes of the snapshot definition query.
rep_type	Version of the snapshot. Valid constants that can be assigned include reg_unknown (the default), reg_v7_group, reg_v8_group, and reg_repapi_group.

Usage Notes

This procedure is invoked at the master site by a remote snapshot site using a remote procedure call. If REGISTER_SNAPSHOT is called multiple times with the same SNAPOWNER, SNAPNAME, and SNAPSITE, then the most recent values for SNAPSHOT_ID, FLAG, and QUERY_TXT are stored. If a query exceeds the maximum VARCHAR2 size, then QUERY_TXT contains the first 32000 characters of the query and the remainder is truncated. When invoked manually, the values of SNAPSHOT_ID and FLAG have to be looked up in the snapshot views by the person who calls the procedure.

If you do not want the snapshot query registered at the master site, then call the SET_REGISTER_QUERY_TEXT procedure with the option set to FALSE. To see the most recent setting of the option, call the GET_REG_QUERY_TEXT_FLAG function at the snapshot site before issuing the DDL.