Home » Server Options » Replication » MV referesh error (Oracle,10g,Unix)
MV referesh error [message #441120] Thu, 28 January 2010 21:58 Go to next message
prejib
Messages: 119
Registered: March 2009
Location: India
Senior Member
Hi,

During the MV referesh we are getting the following error and not able to fix it .

SQL> EXECUTE DBMS_MVIEW.REFRESH('EMP','F');
BEGIN DBMS_MVIEW.REFRESH('EMP','F'); END;

*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-01400: cannot insert NULL into ("XYZ"."EMP"."DESCRIPTION")
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

The above column:- Emp.Description is a 'CLOB NOT NULL' .

We have created the MV using the below script

create materialized view EMP refresh on demand for update as select *from ABC.EMP@DBLINK;

Please help to resolve the issue

Re: MV referesh error [message #441178 is a reply to message #441120] Fri, 29 January 2010 04:20 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member


Descripe your table & materialized view
Re: MV referesh error [message #441182 is a reply to message #441178] Fri, 29 January 2010 04:40 Go to previous message
prejib
Messages: 119
Registered: March 2009
Location: India
Senior Member
Both Table and MV are having the same structure as given below

Name Null? Type
---------------------- -------- ---------------------
TRANSLATION_ID NOT NULL VARCHAR2(40)
DISPLAY_NAME NOT NULL VARCHAR2(254 CHAR)
LONG_DESCRIPTION CLOB
DESCRIPTION NOT NULL CLOB
DELIVERY_FLAG VARCHAR2(255)
SHORT_DESC NOT NULL VARCHAR2(255)
PICKER_DESCRIPTION NOT NULL VARCHAR2(255)
PROMO_TYPE NOT NULL VARCHAR2(255)
SKU_COLOR VARCHAR2(255)

This error was getting from the time when we have started to use the dblink.Before both the table and MV were in the same DB and seperate schema. Now these are in Different DB .

Previous Topic: HOW to check the refresh rate of existing MView
Next Topic: One way replication from MS sql server to Oracle 10g
Goto Forum:
  


Current Time: Mon Jul 28 00:17:57 CDT 2014

Total time taken to generate the page: 0.08840 seconds