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: