My Oracle Support Banner

Not Null Constraints Are Not Replicated If Snapshot Is Based On A Union (Doc ID 341295.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Lite - Version and later
Information in this document applies to any platform.


The problem is that when using the NOT NULL CONSTRAINT ON A TABLE in order to synchronize them on
the olite DB
by doing the following :
- create a Publication and publication Item based on tables which have NOT NULL CONSTRAINTs Using a Complexe Snapshot Definition with UNION
- Synchronize

The Constraints are not replicated when the publication item is complexe (based on two table
using an Union)

- This happens with those versions :
mobile Server 10G R2
- Therefore, the problem to solve is to be able to Synchronize all the not null constraints


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.