Re: Mview refresh when involved table is locked
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 21 Nov 2013 23:09:24 -0200
Message-ID: <CAJdDhaPrpSjWMkoyKA83J9_C3qrCDxFK59euOYKwabiN7JmRvQ_at_mail.gmail.com>
Phillip,
Date: Thu, 21 Nov 2013 23:09:24 -0200
Message-ID: <CAJdDhaPrpSjWMkoyKA83J9_C3qrCDxFK59euOYKwabiN7JmRvQ_at_mail.gmail.com>
Phillip,
I agree with you, but the scenario is complex even as I spoke. There are many objects locked.
My concern is : all locked objects should be released when the transaction ended and the refresh of the materialized view should occur in sequence ...
But this is not happening ... everything is stopped and only killing the sections is releasing.
Best Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 22 2013 - 02:09:24 CET