DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Materialized View

  1. #1
    Join Date
    Sep 2003
    Posts
    15

    Materialized View

    Hi,

    Can any one please explain on how to create a materialized view group and are there any advantages in creating a group and refreshing the group.

    I have some issues with refreshing materialized views,some one suggeste dto break up the queries and create a group and refresh the group.

    I have looked into some of the documentation and it was not that clear as they were talking abt managing Materialized Views on remote databases.

    any help in this regeard i sappreciated.

    Thank You,

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Create a refresh group if you have a group of MV's that you either want/need to refresh together. A good reason is refresh timing (daily, weekly, monthly, etc.).

    I hate to say it, but the MV docs are perty good at tahiti.oracle.com

    Have a nice day.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    One major advantage of refresh groups is that they allow an option for complete refreshes to begin with a delete, rather than a truncate. In the event of an error during the refresh process, you can issue a rollback to recover the previously stored data set -- with a truncate, of course, you can't do this.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Sep 2003
    Posts
    15
    Thank You for the info,

    can any one please post the syntax to create the groups.
    I ma not trying to be lazy to read the documentation but i cannot find it properly.

    Thank You

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Look in the "Supplied PL/SQL Packages and Types Reference" at the "DBMS_REFRESH" package.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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