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

Last updated on FEBRUARY 27, 2013

Applies to:

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

Symptoms

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms