Database DataWarehousing (MOSC)

MOSC Banner

Setup a new mviewsite

edited Apr 8, 2011 5:48AM in Database DataWarehousing (MOSC) 3 commentsAnswered
Hi

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center