Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between 'materialized vews' and snapshots

204773Aug 14 2006 — edited Aug 16 2006
Hello,
i have two questions:
what the difference between 'materialized vews' and snapshots? In fact, in create thoses Oracle Objects:
create materialized view log on T1
/
Create materialized view T1_MV
Build immediate
Refresh fast on commit
As Select COL1,COL2 from T1
/
Create snapshot T1_SNAPSHOT
Build immediate
Refresh fast on commit
As Select COL1,COL2 from T1
/

and in find that T1_MV and T1_SNAPSHOT have the same caracteristics in dba_tables and DBA_SNAPSHOTS and DBA_MVIEWS.

seconde question: what's the difference between DBA_SNAPSHOTS
and DBA_MVIEWS tables?

I work under oracle 9i

thinks for response.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2006
Added on Aug 14 2006
7 comments
491 views