Error updating materialized view

From: Sashi <>
Date: Mon, 7 Jul 2008 07:11:04 -0700 (PDT)
Message-ID: <>

Hi all,
I'm trying to update a materialized view: EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C'); This commands hangs for a very long time (no idea if it'll ever complete). Hm, reminds me of the halting problem.

When I terminate it with a Ctrl-C, I get the error message: ERROR at line 1:

ORA-12008: error in materialized view refresh path
ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858
ORA-06512: at line 1

My version:
$ sqlplus -version

SQL*Plus: Release - Production

We update this MV regularly (every few weeks) and this is the first time that I'm seeing this.

Any pointers are appreciated.

Sashi Received on Mon Jul 07 2008 - 09:11:04 CDT

Original text of this message