|
-
quote
-----------
One of the objects is the materialized view definition itself. The other is the actual table that holds all the rows. I'm not sure why your version does not list this properly. I'm using 9.2 and I get:
-------------
there is lot of difference between 8i Materialized views and 9i materialised views
some of the features which i noticed is
8i does not support automatic refresh on its own . where as 9i does support . we need to do manual refresh in 8i .
i think in 8i it is a concept of snapshot which is called materialized views in 9i . ofcourse even in snapshots it creates materialized views.
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|