Snapshot
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A snapshot is a copy of a table on a remote database.
History
Starting with Oracle 8i, "snapshots" were redefined as "materialized views":
- "CREATE MATERIALIZED VIEW" should be used instead of "CREATE SNAPSHOT"
- "CREATE MATERIALIZED VIEW LOG" should be used instead of "CREATE SNAPSHOT LOG"
- Dictionary views were renamed, for example: DBA_SNAPSHOTS is now called DBA_MVIEWS
- If you create a snapshot or materialized view, it will now show "Materialized View created" instead of "Snapshot created".
Also see
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
