OraFAQ Forum: Server Administration » error in materialized view refresh path

Home » RDBMS Server » Server Administration » error in materialized view refresh path

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error in materialized view refresh path [message #214198]

Mon, 15 January 2007 06:48

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi All,
I have posted the same problem in PL/SQL Expert Forum, but did not get any response so posting it here.
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

Report message to a moderator

Re: error in materialized view refresh path [message #214201 is a reply to message #214198]

Mon, 15 January 2007 06:57

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

There are some good hint here

Do a find for ORA-08103 on that page, and you'll find some thoughts about your issue.

Good Luck

Report message to a moderator

Previous Topic:	Documenting an existing data model
Next Topic:	Getting an "ORA-01031: insufficient privileges" error occasionally

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:23:01 CDT 2024