Database DataWarehousing (MOSC)

MOSC Banner

Cannot use fast refresh of materialized views after EBS upgrade to 12.2

edited Jan 14, 2017 4:00AM in Database DataWarehousing (MOSC) 1 commentAnswered

We are running EBS 12.2 application and after the upgrade we are unable to have Materialized views to be created with fast refresh over db link. We need to have fast refresh for performance. EBS 12.2 requires to have #views on top of the tables for online patching. How we can combine this functionality with fast refresh?

Steps :

in EBS database

1. Create table xxabc.blah1 (I NUMBER);

2. create EDITIONING VIEW xxabc.BLAH1# as select I from xxabc.blah1;

3. create EDITIONABLE synonym apps.blah1 for xxabc.BLAH1#

4. create materialized view log on xxabc.blah1 with rowid

5. create editionable synonym apps.MLOG$_BLAH1 forxxabc.MLOG$_BLAH1;

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