What is snapshot in oracle?

          

What is snapshot in oracle?

<<Previous  Next>>

Oracle - What is snapshot in oracle? - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

What is snapshot in oracle?

A snapshot is a recent copy of a table from db or in some cases, a subset of rows/cols of a table. They are used to dynamically replicate the data between distributed databases.

Oracle - What is snapshot in oracle? - April 10, 2009 at 11:00 AM

What is snapshot in oracle?  

It is a read only copy of a table or a subset of a table.

Oracle - What is snapshot in oracle? - June 18, 2009 at 18:00 PM

A recent copy of a table or a subset of rows or cols of a table is called as snapshot in oracle. A snapshot is more useful in distributed computing environment. We can create snapshot in oracle using command create snapshot. We can specify refresh interval while creating snapshot.

Oracle - What is snapshot in oracle? - June 27, 2009 at 22:00 PM

It is the read-only copy of a master table on a remote node which is refreshed periodically refreshed to reflect changes made to the master table. 

What is snapshot log?  

Snapshot log table maintains a record of modifications to the master table in a snapshot.

Also read

What is snapshot in oracle?

A recent copy of a table or a subset of rows or cols of a table is called as snapshot in oracle. A snapshot is more useful in distributed computing environment. We can create..........

What is a JOIN? Explain types of JOIN in oracle.

A join is a query that extracts data from two or more tables, views or snapshots.........

Oracle replication

Read only replication creates local copy of table data originating from one or more remote master tables. An application can query the data in a read-only table snapshot...............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring