Re: Create materialized view group hanging

Hi Amir,
That did it. Thank you very much.
If in Toronto area give me a ring - I am buying you lunch.

Regards, Ranko

On 10/26/06, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> 9.2.06/Solaris 9. I'll try bounce.
>
>
> On 10/26/06, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> > What is the DB version? We recently hit a bug with MV that caused
> > deadlock on the "row cache lock" situation and we ended up bouncing the
> > instance. We are 9.2.0.6 (64-bit)/Solaris9
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic
> > Sent: Thursday, October 26, 2006 1:33 PM
> > To: oracle-l
> > Subject: Create materialized view group hanging
> >
> > Hi,
> > I am trying to create materialized view group with 28 views in there and
> > dbms_refresh.make command is hanging.
> > Same procedure was executed successfully in many other environments.
> > Any ideas , suggestions ?
> >
> > --
> > Regards,
> > Ranko Mosic
> > Contract Senior Oracle DBA
> > B. Eng, Oracle 10g, 9i Certified Database Professional
> > Phone: 416-450-2785
> > email: mosicr_at_rogers.com
> > http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMo
> > sicMain.html
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Regards,
> Ranko Mosic
> Contract Senior Oracle DBA
> B. Eng, Oracle 10g, 9i Certified Database Professional
> Phone: 416-450-2785
> email: mosicr_at_rogers.com
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>

-- 
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l