While Creating Materialized View Then ORA-00600 [kkzcsn:on-commit and on-demand bits set] Occurs

(Doc ID 1277607.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 07-dec-2012

Symptoms

Once migrated from 10.2.0.4 to 11.2.0.1 release, then the MView creation fails with the error:

ORA-00600: internal error code, arguments: [kkzcsn:on-commit and on-demand bits set].


For example:

SQL> CREATE MATERIALIZED VIEW "GECCO"."MVW_TIPO_EMPRESA" ("CO_TIPO_EMPRESA",
"ID_DESCRIPCION", "ID_USUARIO_ALTA", "FH_ALTA", "ID_USUARIO_MODIFICACION",
"FH_MODIFICACION", "ES_DESCRIPCION", "CAT_DESCRIPCION", "EUS_DESCRIPCION",
"GA_DESCRIPCION", "VA_DESCRIPCION") USING ("MVW_TIPO_EMPRESA", (8, 'DESA00',
2, 0, 0, "GECCO", "UGE_DESCRIPCION", '2009-11-24 11:49:18', 0, 146879,
'2009-11-24 13:05:13', '', 0, 3671995720, 0, NULL, 1, "GECCO",
"UGE_TIPO_EMPRESA", '2009-11-24 11:49:18', 0, 147062, '2009-11-24 13:04:19',
'', 0, 3671995720, 0, NULL), 2138177, 8, ('1950-01-01 12:00:00', 677, 0, 0,
3671995720, 0, 0, 0, NULL, NULL)) REFRESH FORCE AS SELECT tab.*,
des.es_descripcion, des.cat_descripcion, des.eus_descripcion,
2 des.ga_descripcion, des.va_descripcion
3 FROM uge_tipo_empresa tab, uge_descripcion des
4 WHERE des.id_descripcion = tab.id_descripcion;
CREATE MATERIALIZED VIEW "GECCO"."MVW_TIPO_EMPRESA" ("CO_TIPO_EMPRESA",
"ID_DESCRIPCION", "ID_USUARIO_ALTA", "FH_ALTA", "ID_USUARIO_MODIFICACION",
"FH_MODIFICACION", "ES_DESCRIPCION", "CAT_DESCRIPCION", "EUS_DESCRIPCION",
"GA_DESCRIPCION", "VA_DESCRIPCION") USING ("MVW_TIPO_EMPRESA", (8, 'DESA00',
2, 0, 0, "GECCO", "UGE_DESCRIPCION", '2009-11-24 11:49:18', 0, 146879,
'2009-11-24 13:05:13', '', 0, 3671995720, 0, NULL, 1, "GECCO",
"UGE_TIPO_EMPRESA", '2009-11-24 11:49:18', 0, 147062, '2009-11-24 13:04:19',
'', 0, 3671995720, 0, NULL), 2138177, 8, ('1950-01-01 12:00:00', 677, 0, 0,
3671995720, 0, 0, 0, NULL, NULL)) REFRESH FORCE AS SELECT tab.*,
des.es_descripcion, des.cat_descripcion, des.eus_descripcion,
*
ERROR en l´┐Żnea 1:
ORA-00600: internal error code, arguments: [kkzcsn:on-commit and on-demand bits set].

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