prakash2906

 Profile Answers by prakash2906 

• Dec 27th, 2005

 

A snapshot is a table that contains the
    results of a query of one or more tables or views, often located on
    a remote database.

Narender Reddy

• Jan 4th, 2006

 

In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.

Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to prevent access from users on complete data on table. whenever we will access the view that brings the data from tables only not from view(it wont store any kind of data).

but the snapshot itself store the query result data. usually we will use to get remote data to replicate the changes made at remote site.