URGENT - ORA-12008: error in materialized view refresh path

[balajiyes]

Hi ALL,
Iam getting this error when i refresh the mview.
can some one throw light on this

ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [kksfbc-new-child-thresh-exceeded],
[], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 814
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: at line 2

Cheers!

[slimdave]

there's an article on metalink addressing this. what version are you at?

[balajiyes]

hi this is wht i get for
select * from v$version;

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Solaris: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production

Cheers!