Oracle Standard Edition 11g X Materialized View Fast Refresh
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".
0