Home » SQL & PL/SQL » SQL & PL/SQL » Refresh Path error in Materialized view
Refresh Path error in Materialized view [message #213483] Thu, 11 January 2007 00:03
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi All,
Very often I could see the below list of error messages in the alert.log
What could be the problem?

Error Message:
Wed Jan 10 10:26:56 2007
...skipping...
ORA-12008: error in materialized view refresh path
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Wed Jan 10 15:53:26 2007


I do not get the error when I try to refresh the same materialized view using
SQL> execute dbms_refresh.refresh('"DEVELOPMENT"."DEV_BLUE_BOOK_YIELD_REP_MV"');


Please help.

Thanks in advance
qA
Previous Topic: Identifying Similar Set of Rows in a table
Next Topic: UTL_SMTP attached file ends with blank line
Goto Forum:
  


Current Time: Fri Dec 09 00:04:10 CST 2016

Total time taken to generate the page: 0.13640 seconds