Snapshots Vs Materialized views. Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Snapshots Vs Materialized views.

  1. #1
    Join Date
    Jan 2001

    The snapshots in 8i are know as materialized views-Right. If that is so, then Oracle 8i standard edition does not support materialized views but supports basic replication- which is single master/multi snapshot/updatable snapshots etc.

    I fail to understand, if the materialized views are not allowed in 8i, how does it create a snap shot.

    Please clarify.

    There is always a better way to do the things.

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    well I guess what is not available as Materialized View in standrd edition is it does not support Query Rewrite?

    but if you are using MV as snapshots then you can work with it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width