Refresh fails on MV with CLOB data type [message #505611] |
Wed, 04 May 2011 04:05 |
|
julie_n
Messages: 1 Registered: May 2011
|
Junior Member |
|
|
Hi,
Hope somebody can help me with this issue.
Some materialized views get status broken on refreshment, but only sometime.
When I try to refresh them manually I get following message:
"ORA-01400: cannot insert NULL into...".
But I know for sure that there are no NULL values in the master table, MV and master tables are declared in the same way and all columns in master tables are NOT NULL columns. Another ting is that this error I get only on columns with data type CLOB.
Please, help!
|
|
|
|