What is Snapshot in oracle 9i and what is different between view and Snapshot?

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions