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