Difference between 'materialized vews' and snapshots
204773Aug 14 2006 — edited Aug 16 2006Hello,
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.