Materialized View

[r_adusumilli]

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,

[KenEwald]

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.

[slimdave]

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.

[r_adusumilli]

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

[slimdave]

Look in the "Supplied PL/SQL Packages and Types Reference" at the "DBMS_REFRESH" package.