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

Thread: Snapshots Vs Materialized views.

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    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.

    Badrinath
    There is always a better way to do the things.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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