| MV referesh error [message #441120] |
Thu, 28 January 2010 21:58  |
prejib
Messages: 126
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 #441182 is a reply to message #441178] |
Fri, 29 January 2010 04:40  |
prejib
Messages: 126
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 .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
