Database DataWarehousing (MOSC)

MOSC Banner

Oracle Standard Edition 11g X Materialized View Fast Refresh

edited Jan 14, 2010 1:12AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hello!
I have some doubts regarding MViews and Oracle Standard Edition.

I want to have an environment with the following architecture:

A central database with Oracle Standard Edition 11g and ten departamental databases running Oracle Standard Edition One 11g or Oracle XE (I don't know yet, but want to force SE1).
The central database will have some read only MViews (with FAST REFRESH, mlogs on the tables) that will receive the information of 1 or 2 tables from each departamental database. On the departamental databases I will have also a MView (with FAST REFRESH, mlogs on the tables) that will receive informations from 1 or 2 tables from the central database. The tables involved on the 2 different types of MViews are not the same, so I won't have "2 way" replication neither "updatable mviews".

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