My Oracle Support Banner

Not Able To Create Virtual Pk On Nullable Columns (Doc ID 430662.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Lite - Version 10.2.0.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 25-July-2012***

Oracle


Symptoms

-- Problem Statement:
On 10.2.0.2 in Production:
When attempting to create a Publication Item with a Virtual PK
the following error occurs:

ERROR
ORA-01449 column contains NULL values; cannot alter to NOT NULL


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
msql <USER>/<PASSWORD> @jdbc:oracle:thin:@<HOST>:PORT:<DB>

create table <TABLENAME> (col1 number, col2 varchar2(100));

insert into <TABLENAME> (col1,col2) values(1,'');

commit;

Start MDW:
create a new Project.

Add the Virtual PK on the Both Columns of the table <USER>.<TABLENAME>.

create the publication Item <PUBLICATION ITEM> in fast refresh mode
select the table <USER>.<TABLENAME> with the two columns -> it will fails with the Error: CONS-10049:
Consolidator Exception: ORA-01449:column contains NULL values; cannot alter to NOT NULL


Cause

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
Symptoms
Cause
Solution

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