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
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!

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
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

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

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


Current Time: Thu Mar 28 17:47:03 CDT 2024