Table: DBA_SNAPSHOTS
All snapshots in the database
| Column Name | Description |
|---|---|
| CAN_USE_LOG | If NO, this snapshot is complex and will never use a log |
| CR_OPERATIONS | If REGENERATE, then the complete refresh operations have not been generated |
| ERROR | The number of failed automatic refreshes since last successful refresh |
| FR_OPERATIONS | If REGENERATE, then the fast refresh operations have not been generated |
| LAST_REFRESH | SYSDATE from the master site at the time of the last refresh |
| MASTER | Name of the master table that this snapshot is a copy of |
| MASTER_LINK | Database link name to the master site |
| MASTER_OWNER | Owner of the master table |
| MASTER_ROLLBACK_SEG | Rollback segment to use at the master site |
| MASTER_VIEW | View of the master table, owned by the snapshot owner, used for refreshes |
| NAME | The view used by users and applications for viewing the snapshot |
| NEXT | The date function used to compute next refresh dates |
| OWNER | Owner of the snapshot |
| PREBUILT | If YES, this snapshot uses a prebuilt table as the base table |
| QUERY | The original query that this snapshot is an instantiation of |
| REFRESH_GROUP | All snapshots in a given refresh group get refreshed in the same transaction |
| REFRESH_METHOD | The values used to drive a fast refresh of the snapshot |
| REFRESH_MODE | This indicates how and when the snapshot will be refreshed |
| START_WITH | The date function used to compute next refresh dates |
| STATUS | The status of the contents of the snapshot |
| TABLE_NAME | Table the snapshot is stored in -- has an extra column for the master rowid |
| TYPE | The type of refresh (complete,fast,force) for all automatic refreshes |
| UPDATABLE | If NO, the snapshot is read only. Look up REPLICATION |
| UPDATE_LOG | The table which logs changes made to an updatable snapshots |
| UPDATE_TRIG | The name of the trigger which fills the UPDATE_LOG |