| Problem in refreshing MV [message #338777] |
Tue, 05 August 2008 22:53  |
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
|
Member |
|
|
Hi,
I have a materialized view which was working fine earlier but since last week it is not refreshing and throwing the error while trying to refresh:
ORA-12018: following error encountered during code generation for "GPS_MM_LDC_FRAME"."MV_META_DATA" ORA-00913: too many values ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430 ORA-06512: at line 1
I tryied to compile and it throws compilation error. But if i run the query then the query is working fine.
Please suggest
Thanks
Harsh
|
|
|
|
|
|
| Re: Problem in refreshing MV [message #339390 is a reply to message #338790] |
Thu, 07 August 2008 07:24  |
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
|
Member |
|
|
We are using Oracle 10.2.0.2 on Solaris 5.9.
CREATE MATERIALIZED VIEW "GPS_MM_LDC_FRAME"."MV_META_DATA" TABLESPACE "GPS_MM_LDC_FRAME" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING USING NO INDEX REFRESH FORCE START WITH to_date('08-07-2008 13:40:42','MM-dd-yyyy hh24:mi:ss') NEXT SYSDATE+1 AS SELECT m.*, g.numberof_records
FROM meta_data m, subtrack g
where m.metadata_id=g.metadata_id
The above is the MV's DDL.
Thanks
Harsh
|
|
|
|
|
|
| Re: Problem in refreshing MV [message #340199 is a reply to message #339507] |
Mon, 11 August 2008 22:45 |
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
|
Member |
|
|
Hi Babu,
Yes it is correct. While i am running the query:
SELECT m.*, g.NumberOf_Records FROM Meta_Data m,
SubTrack g WHERE m.MetAdAta_Id = g.MetAdAta_Id
It is running fine but while trying to refresh the MV then it throws error. Even if i am trying to compile in OEM then it shows that ' compiled successfully' but state of compilation shows 'compilation error'.
Please suggest.
Harsh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
