My Oracle Support Banner

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

Last updated on JANUARY 29, 2022

Applies to:

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


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

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,'');


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


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.