| exec dbms_mview.refresh('mviewname','c','atomic_refresh=>FALSE) is giving error [message #434582] |
Wed, 09 December 2009 16:20  |
bhanunadendla@yahoo.co.in
Messages: 3
Registered: December 2009
|
Junior Member |
|
|
Hi All,
I am trying to refresh the materialized view using
exec dbms_mview.refresh(MVIEWNAME','c',atomic_refresh=>FALSE)
and getting the following error message:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 1
First I thought there is as issue with the MVIEW script as soon I drop and recreate the mview then the above refreshmview commands works fine for this view and it is giving the same error for another mview.
I have investigated a lot but so far I don't have any soultion why it Oracle is giving this error message.
I am using Oracle 10gR2
Thanks in Advance
Bhanu
|
|
|
|
|
|
|
|
| Re: exec dbms_mview.refresh('mviewname','c','atomic_refresh=>FALSE) is giving error [message #434747 is a reply to message #434582] |
Thu, 10 December 2009 08:48  |
bhanunadendla@yahoo.co.in
Messages: 3
Registered: December 2009
|
Junior Member |
|
|
Hi Sajith,
I have tried to enable the SQL trace but it says Insufficient privelliges.
I am pretty sure that it is not the table missing issue as I able to run the Select part of the query without any issues.
If I drop and recreate the Materialized view then the dbms_mview.refresh job will work fine and when move to next view then again the same error.
The work aorund is droping and recreating them all the time but I have like around 50 Materialized views per environment and I have aound 20 environments.
Thanks
Bhanu
|
|
|
|
| Re: exec dbms_mview.refresh('mviewname','c','atomic_refresh=>FALSE) is giving error [message #434749 is a reply to message #434582] |
Thu, 10 December 2009 08:51 |
bhanunadendla@yahoo.co.in
Messages: 3
Registered: December 2009
|
Junior Member |
|
|
Hi Michel Cadot,
[Michel]Are you sure it is a mview?
[Bhanu]Yes I am sure it is a Materialized views
[Michel]Are you sure the underlying table exists?
[Bhanu]Yes I am sure the underlying table exists. I tried running the select clause of the query and it ran fine.
[Michel]Post your version with 4 decimals.
[Bhanu]you mean Oracle version? it is as follows.
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 09:25:10 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
