Materalized View Refresh after upgrade - Oracle 11g to 12c

From: Gokul Kumar Gopal <gokulkumar.gopal_at_gmail.com>
Date: Tue, 22 Sep 2020 22:12:00 +0530
Message-ID: <CAEVfUVm17j7bywojQNPnGVoe_+qotUoeMV9xfcmbDwywu6tJrw_at_mail.gmail.com>

Hello,

We are currently migrating from 11.2.0.4 to 12.2.

There are about 150 materialized view logs on the basetables.

Several consumers refresh the MVs using these MV logs (on demand fast refresh).

We are now told that due to migration, the MVs will have to be refreshed in FULL, because all the old references are no longer valid.

I have not found anything in the documentation to this effect.

I would like to confirm with the experts in the forum if this is the case.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 22 2020 - 18:42:00 CEST

This message: [ Message body ]
Next message: manikandan: "Re: goldengate logdump"
Previous message: dimensional.dba_at_comcast.net: "RE: Any tips for switching between programming languages"
Next in thread: Jonathan Lewis: "Re: Materalized View Refresh after upgrade - Oracle 11g to 12c"
Reply: Jonathan Lewis: "Re: Materalized View Refresh after upgrade - Oracle 11g to 12c"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message