Home » Server Options » Replication » Refresh fails on MV with CLOB data type (Oracle 11g)
Refresh fails on MV with CLOB data type [message #505611] Wed, 04 May 2011 04:05 Go to next message
Messages: 1
Registered: May 2011
Junior Member

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!

Re: Refresh fails on MV with CLOB data type [message #506127 is a reply to message #505611] Fri, 06 May 2011 11:02 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Is it normal behavior in replication. Have you tried dbms_defer_sys.execute_err?

Previous Topic: Applying DB Structure changes without downtime
Next Topic: Advanced Replication (ASR) Got Stuck
Goto Forum:

Current Time: Sun Aug 14 22:31:51 CDT 2022