Home » Server Options » Replication » Problem in refreshing MV
Problem in refreshing MV [message #338777] Tue, 05 August 2008 22:53 Go to next message
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 #338790 is a reply to message #338777] Tue, 05 August 2008 23:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please suggest

Post more information.
Table and mv definitions, Oracle version (4 decimals)...

Regards
Michel
Re: Problem in refreshing MV [message #339390 is a reply to message #338790] Thu, 07 August 2008 07:24 Go to previous messageGo to next message
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 #339507 is a reply to message #339390] Thu, 07 August 2008 12:18 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Kumar,

As per your statement, confirm me the below query is correct or not.


SELECT m.*, g.NumberOf_Records FROM   Meta_Data m,
SubTrack g WHERE  m.MetAdAta_Id = g.MetAdAta_Id





Babu

[Updated on: Thu, 07 August 2008 12:24]

Report message to a moderator

Re: Problem in refreshing MV [message #340199 is a reply to message #339507] Mon, 11 August 2008 22:45 Go to previous messageGo to next message
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
Re: Problem in refreshing MV [message #340675 is a reply to message #340199] Wed, 13 August 2008 14:02 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Kumar,

Please confirm me; your materialized view valid/invalid?

If it's invalid then find out reason.

Babu
Previous Topic: ORA-00001: unique constraint violated
Next Topic: Data Replication
Goto Forum:
  


Current Time: Thu Mar 28 06:14:13 CDT 2024