Error updating materialized view
Date: Mon, 7 Jul 2008 07:11:04 -0700 (PDT)
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
$ sqlplus -version
SQL*Plus: Release 126.96.36.199.0 - 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