What code changes are needed for Materialized Views before upgrding to R12.2.
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