Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

What code changes are needed for Materialized Views before upgrding to R12.2.

edited Aug 20, 2021 10:14AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

Hello,

We are in the process of upgrading from R12.1.3  to R12.2

This is a question regarding what needs to be done to the existing custom materialized views BEFORE upgrading to 12.2.

Are there any steps to prepare the custom materialized views BEFORE UPGRADING to R12.2 (Edition based redefinition) ?

Please note this is only before upgrading (and NOT after)

For Example :-

I have a custom materialized view

create materialized view xxxx as

select col1, col2,col3 from table a.

Is the above syntax ok before upgrading to R12.2 or does this needs to be changed to something like this, PRIOR to upgrading to R12.2

Tagged:

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