ORA-600 [Kkzfrfajv_markdml-1] (Doc ID 743766.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

-- Create two users

grant dba to testcase identified by testcase;
grant dba to test identified by test;



-- Connect as testcase
-- Create table / mview log /mviews

sqlplus testcase/testcase

CREATE TABLE MANAGER (
ADRESS_ID_SL NUMBER(10) NOT NULL,
ADRANR_S VARCHAR2(40 byte),
ADRPLZ_S VARCHAR2(10 byte),
ADRORT_S VARCHAR2(50 byte),
CONSTRAINT PK1 PRIMARY KEY(ADRESS_ID_SL)
);

 

CREATE MATERIALIZED VIEW LOG ON MANAGER WITH ROWID (ADRANR_S, ADRORT_S,
ADRPLZ_S), SEQUENCE
INCLUDING NEW VALUES;

 


CREATE MATERIALIZED VIEW MV_MANAGER_ANREDE
REFRESH FAST ON COMMIT AS
SELECT AdrAnr_s, count(AdrAnr_s) as anzahl
FROM manager
GROUP BY AdrAnr_s;

 


CREATE MATERIALIZED VIEW MV_MANAGER_ORT
REFRESH FAST ON COMMIT AS
SELECT adrort_s, count(adrort_s) as anzahl
FROM manager
GROUP BY adrort_s;

 


CREATE MATERIALIZED VIEW MV_MANAGER_PLZ
REFRESH FAST ON COMMIT AS
SELECT adrplz_s, count(adrplz_s) as anzahl
FROM manager
GROUP BY adrplz_s;


-- export testcase schema

exp testcase/testcase file=/tmp/exp.dmp owner=testcase


-- import in test schema

imp test/test file=/tmp/exp.dmp fromuser=testcase touser=test

.
-- Connect as testcase and run following to reproduce the error

SQL>conn testcase/testcase
SQL> insert into manager (adress_id_sl, AdrAnr_s) values (1, null);
.
1 row created.



SQL> commit;
commit
*
ERROR at line 1:
ORA-12048: error encountered while refreshing materialized view
"TEST"."MV_MANAGER_ANREDE"
ORA-00600: internal error code, arguments: [kkzfrfajv_markdml-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