Setup a new mviewsite
I am trying to setup a new mview site, say mvsite2 based on a master site say m1. m1 already has a mvsite, say mvsite1 registered to it. Now my mvsite2 should be exact replica of mvsite1.
DB version is 9.2.0.8
Master site m1 has a master group, say mg1. All the mv's at mvsite1 are registered under this mg1. There are mv logs for all the table which have mv's at mvsite1
Mvsite1 has all the mv's and there are two refresh groups say rg1, rg2 on this site. Some of the mv' are under rg1 and some on rg2. rg1 refreshes every 2 mins and rg2 refreshes every 15 mins. All the mv's are fast refreshed via the refresh groups.