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@xxxxxxxxx> wrote:
9.2.06/Solaris 9. I'll try bounce.


On 10/26/06, Hameed, Amir <Amir.Hameed@xxxxxxxxx> 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxx > http://ca.geocities.com/mosicr@xxxxxxxxxx/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@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html



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


Other related posts: