Database DataWarehousing (MOSC)

MOSC Banner

MV Log used by three databases

edited Jul 3, 2012 11:39PM in Database DataWarehousing (MOSC) 4 comments
My scenario is as follows:
I have the table "X" in database "A" and created a MV log with the command:
CREATE MATERIALIZED VIEW LOG ON X WITH PRIMARY KEY, ROWID;

Now, I created in the database "B" a MV with the command:
CREATE MATERIALIZED VIEW "MVX_B"   
   REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/720
   WITH PRIMARY KEY 
   AS SELECT * FROM X@A;

And created in the database "C" a MV with the command:
CREATE MATERIALIZED VIEW "MVX_C"
    REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/720
    WITH PRIMARY KEY
    AS SELECT * FROM X@A;

Finally I created in the database "D" a VM with the command:

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