Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterviewDefine a snapshot in the context of an Oracle database.
course 5

Define a snapshot in the context of an Oracle database.

Oracle uses snapshots, which are also known as materialized views, in order to replicate data to the non-master sites in a replicated environment. Snapshots are also used to cache the “expensive” queries in a data warehouse environment. So in short, a snapshot is nothing but a copy of the target master table from a single point in time.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...