Oracle Distributed Systems

Name

DBMS_SNAPSHOT.REGISTER_SNAPSHOT (Oracle8 Only)

Synopsis

Generally, the registration and unregistration of snapshots is automatic if both the master and snapshot databases are Oracle8. However, in case the snapshot site is running Oracle7 or if the automatic registration fails, you can use the Oracle8 procedure, REGISTER_SNAPSHOT, to register the snapshot manually.

One of the most significant improvements in Oracle8 is the automatic registration of snapshots at the master site. In Oracle7, there was no easy way to determine the location—or even the existence—of snapshots with master table(s) in your instance. But when you create a snapshot in Oracle8, Oracle puts a record in the DBA_REGISTERED_SNAPSHOTS data dictionary view. Similarly, when you drop a snapshot, Oracle deletes the record from DBA_REGISTERED_SNAPSHOTS.

The REGISTER and UNREGISTER procedures let you manually maintain the DBS_REGISTERED_SNAPSHOTS data dictionary view, shown here:

Column Name	Description
OWNER	Snapshot owner.
NAME	Snapshot name.
SNAPSHOT_SITE	Global name of database where snapshot resides.
CAN_USE_LOG	If YES, then snapshot refreshes can use snapshot log.
UPDATABLE	If YES, then snapshot is an updateable snapshot.
REFRESH_METHOD	Refresh method; either ROWID or PRIMARY KEY.
SNAPSHOT_ID	Unique ID of snapshot used for fast refreshes.
VERSION	Version of the snapshot. Possible values are REG_UNKNOWN, REG_V7_GROUP, REG_V8_GROUP, and REG_REPAPI_GROUP.
QUERY_TXT	Text of the snapshot’s query.

The registration of snapshots is not mandatory; ...