Snapshot

From Oracle FAQ
Jump to: navigation, search

A snapshot is a copy of a table on a remote database.

History[edit]

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[edit]

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 #