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.
10-21-2003, 04:37 PM
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.
10-21-2003, 08:43 PM
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.
10-22-2003, 02:20 PM
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.
10-22-2003, 02:24 PM
Look in the "Supplied PL/SQL Packages and Types Reference" at the "DBMS_REFRESH" package.