ORA-00600 [KKZGBTCOLS] While Creating Materialized View (MView) (Doc ID 1446216.1)

Last updated on SEPTEMBER 11, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms


ORA-00600 [kkzgbtcols] occurs when creating materialized view in 11.2.0.3

See the scenario below:
On database 10.2.0.4
----------------------

1. Create schema user in Oracle 10.2.0.4 database.

CREATE USER test1
IDENTIFIED BY MYPASSWORd
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CONNECT TO test1;
GRANT RESOURCE TO test1;
ALTER USER test1 DEFAULT ROLE ALL;
GRANT ANALYZE ANY TO test1;
GRANT CREATE ANY TABLE TO test1;
GRANT CREATE SESSION TO test1;
GRANT DROP ANY TABLE TO test1;
GRANT UNLIMITED TABLESPACE TO test1;
ALTER USER test1 QUOTA UNLIMITED ON USERS;
ALTER USER test1 QUOTA UNLIMITED ON TEMP;


2. Create source table in Oracle 10.2.0.4 database (Sample script attached).

@create_table.sql

3. Create materialized view log.
create materialized view log on test1.COROW with primary key;


4. Create Indexes on the table (Sample script attached).

@create_index.sql


On database 11.2.0.3
-----------------------

1. Create Database link.

create public database link to_mydblink connect to test1 identified by MYPASSWORd using 'MYDBLINK';


2. Create database user at target.

CREATE USER test2
IDENTIFIED BY MYPASSWORD
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;


3. Grant roles for user test2.

ALTER USER test2 DEFAULT ROLE ALL;
GRANT EXECUTE ANY TYPE TO test2;
GRANT UNLIMITED TABLESPACE TO test2;
GRANT CREATE SESSION TO test2;
GRANT SELECT ANY DICTIONARY TO test2;
ALTER USER test2 QUOTA UNLIMITED ON USERS;
ALTER USER test2 QUOTA UNLIMITED ON USERS;
ALTER USER test2 QUOTA UNLIMITED ON USERS;
GRANT EXECUTE ON SYS.DBMS_ALERT TO test2;


4. Execute the create materialized view statement.

CREATE MATERIALIZED VIEW test2.COROW
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD DEFERRED
REFRESH FAST ON DEMAND
WITH ROWID
AS
SELECT cono
, rowpos
, rowsubpos
, rowseq
, reqshipdate
, ackshipdate
, reqdeldate
, ackdelivdate
, partno
, partdescr1
, partdescr2
, unit
, qtyres
, qtydet
, tourno
, weekdayno
, corowamt
, orderedpartno
, corowdisc1
, corowdisc2
, corowdisc3
, grsprice
, qtyco
, prpricelist
, prsales
, replind
, stocknopu
, stocknosu
, unitsell
FROM corow@to_mydblink;


5. The above statement will result in the error ORA-00600.

CREATE MATERIALIZED VIEW test2.COROW
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkzgbtcols], [28], [29], [], [],[], [], [], [], [], [], []

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