Difference between Snapshots (user_snapshots) and Views (user

Home -> Community -> Usenet -> c.d.o.misc -> Difference between Snapshots (user_snapshots) and Views (user_views) in Oracle

From: Cathy Hui <kaka.hui_at_gmail.com>
Date: 24 Jan 2007 12:27:50 -0800
Message-ID: <1169670470.549548.264190@s48g2000cws.googlegroups.com>

What is the different between Snapshots and View? I am trying to understand it's concept and make sure i am understanding it correctly.

Questions of Snapshot:
Can Snapshot also be created on a view?
When user update the table, does the snapshot become invalid immeidately?
When a snapshot become invalid, does this snapshot still stay in the database?

Questions of View:
Is a view static or dynamic (i.e. will the user able to view the changes made to the table(s) associate with the view)? When a view become invalid, does the view still stay in the database?

Beside these questions I asked above, also feel free to add more comment / remarks regarding the difference between a snapshot and a view.

Thank you!!!! Received on Wed Jan 24 2007 - 14:27:50 CST