Re: 11.2.0.3 drop materialized view weirdness
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Sat, 22 Oct 2011 23:54:51 +0800
Message-ID: <CAM_ddu9qv8FzhDS0+tkn5a70UORP-fXPajTHkNK=dRsUhK9KQA_at_mail.gmail.com>
hi chris,
what's the special indexes? function or bitmap indexes. i'm curious.
Date: Sat, 22 Oct 2011 23:54:51 +0800
Message-ID: <CAM_ddu9qv8FzhDS0+tkn5a70UORP-fXPajTHkNK=dRsUhK9KQA_at_mail.gmail.com>
hi chris,
what's the special indexes? function or bitmap indexes. i'm curious.
--quote from the note--
If there are special indexs on a Materialized View container table then self deadlocks can occur while attempting to drop such MVs.
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 22 2011 - 10:54:51 CDT