Table Redefinition is Failing With ORA-00600 [kkzucmvl_ChkMVLog: kkzlglnm] (Doc ID 1453443.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

Getting following ora-600 error while running table redefinition:

ORA-00600: internal error code, arguments: [kkzucmvl_ChkMVLog: kkzlglnm], [],dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=adrj28qhkg8qy) -----
declare
col_mapping varchar2(2000);
begin
col_mapping :='CIS_ID CIS_ID,VCIS_ID VCIS_ID,CIPR_PRIORITY CIPR_PRIORITY,CIPR_STATUS_DATE CIPR_STATUS_DATE,CIT_ID CIT_ID,MGRP_ID MGRP_ID,CIPR_DATE_CREATED CIPR_DATE_CREATED,CIPR_USER_CREATED CIPR_USER_CREATED,CBL_ID CBL_ID,CIPR_BATCH_DELIVERY CIPR_BATCH_DELIVERY,VCIS_FAST_ID VCIS_FAST_ID,CIPR_DATE_MODIFIED CIPR_DATE_MODIFIED,CIPR_USER_MODIFIED CIPR_USER_MODIFIED,THREAD_ID THREAD_ID,ORIGINAL_STATUS ORIGINAL_STATUS,ORIGINAL_STATUS_DATE ORIGINAL_STATUS_DATE,CIPR_LAST_EXPORTED CIPR_LAST_EXPORTED';
dbms_redefinition.start_redef_table('MSTMFG','CNT_ITEM_PATENTS_ROUTER','CNT_ITEM_PATENTS_ROUTER_REDF',col_mapping);
end;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x102d4a4850        52  package body SYS.DBMS_REDEFINITION
0x102d4a4850      1646  package body SYS.DBMS_REDEFINITION
0x103e7ba9d8         5  anonymous block

----- Call Stack Trace -----


Function List   (to Full stack)   (to Summary stack)

    skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
       <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE
        <- 2131 <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv
         <- kgeasnmierr <- kkzucmvl_ChkMVLog <- kkzusord <- kkzisord <- spefcmpa
          <- spefmccallstd <- pextproc <- PGOSF589_peftrust <- PGOSF633_psdexsp <- rpiswu2
           <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL
            <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe
             <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
              <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
               <- ssthrdmain <- main <- libc_start_main <- start

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