Error updating materialized view
From: Sashi <smalladi_at_gmail.com>
Date: Mon, 7 Jul 2008 07:11:04 -0700 (PDT)
Message-ID: <c0ce9e28-0eb4-437e-ae18-2b6dccffc891@m3g2000hsc.googlegroups.com>
Date: Mon, 7 Jul 2008 07:11:04 -0700 (PDT)
Message-ID: <c0ce9e28-0eb4-437e-ae18-2b6dccffc891@m3g2000hsc.googlegroups.com>
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 9.2.0.6.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.
Thanks,
Sashi
Received on Mon Jul 07 2008 - 09:11:04 CDT