Home » SQL & PL/SQL » SQL & PL/SQL » ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist
ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist [message #346552] Mon, 08 September 2008 19:01 Go to next message
kvignes1
Messages: 33
Registered: September 2007
Member

Hi

DBMS_MVIEW.Refresh('MV_CR_T_ABSTRACT');

FYI, We recently migrated to Oracle 10g RAC.

After that above command stopped working whish is used inside the stored Procedure. when running the Stored Procedure we are getting the following error.

ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 2

But when i describe it i am able to see it. And when I do a select on the same MV I am able to see the data. Pls let me know the issue.

SQL> show user
USER is "CRAPPASUGS"
SQL> desc MV_CR_T_ABSTRACT
Name
---------------------------------
ID_ABSTRACT
ID_USER
ID_CREATIVITY_TEAM
Re: ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist [message #346553 is a reply to message #346552] Mon, 08 September 2008 19:05 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SELECT OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_NAME = 'MV_CR_T_ABSTRACT'

Re: ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist [message #346554 is a reply to message #346553] Mon, 08 September 2008 19:14 Go to previous messageGo to next message
kvignes1
Messages: 33
Registered: September 2007
Member

My Result:
OBJECT_TYPE
-------------------
TABLE
Re: ORA-23401: materialized view "CRAPPASUGS"."MV_CR_T_CONTACTS" does not exist [message #346606 is a reply to message #346552] Tue, 09 September 2008 02:14 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you look at the error message, it's not the Mviw MV_CR_T_ABSTRACT that's giving you problems.
Your problem is that the Mview MV_CR_T_CONTACTS does not exist.

1) Are you sure that this error happens when you refresh MV_CR_T_ABSTRACT and that you've not got the wrong command?

2) Is everything ok with MV_CR_T_CONTACTS?
Previous Topic: Function Overloading
Next Topic: replace column data wserching tab
Goto Forum:
  


Current Time: Sat Dec 10 01:33:44 CST 2016

Total time taken to generate the page: 0.10914 seconds