Table: DBA_REGISTERED_SNAPSHOTS
Remote snapshots of local tables
| Column Name | Description |
|---|---|
| CAN_USE_LOG | If NO, this snapshot is complex and cannot fast refresh |
| NAME | The name of the snapshot |
| OWNER | Owner of the snapshot |
| QUERY_TXT | Query defining the snapshot |
| REFRESH_METHOD | Whether the snapshot uses rowid, primary key or object id for fast refresh |
| SNAPSHOT_ID | Identifier for the snapshot used by the master for fast refresh |
| SNAPSHOT_SITE | Global name of the snapshot site |
| UPDATABLE | If NO, the snapshot is read only |
| VERSION | Version of snapshot |