My Oracle Support Banner

ORA-00600 [Qkebcreateconstantopn1] on Distributed Materialized View Create Statement (Doc ID 788816.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Information in this document applies to any platform.


ORA-600 [QKEBCREATECONSTANTOPN1] when creating a materialized view on a remote object after the table has been alterred to add a column or columns with not null and a default value.

create table block_preferences (
user_id number,
min_age integer,
max_age integer,
gender_id integer, 
constraint block_pref_pk primary key (user_id));

Table created.

alter table block_preferences add one_click number(1) default 0 not
null constraint block_pref_one_click_ck
check (one_click in (0, 1));


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.