Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Difference between Snapshots (user_snapshots) and Views (user_views) in Oracle
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
![]() |
![]() |