ORA-00600:[kkbrcupfind2] while dropping a column (Doc ID 1487527.1)

Last updated on MARCH 01, 2019

Applies to:

Symptoms

An attempt to drop a column from a table generates:-

ORA-00600: internal error code, arguments: [kkbrcupfind2], [], [], [], [], [], [], [], [], [], [], []

Alert log
=========
Mon Aug 06 12:11:02 2012
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_17688.trc (incident=47767):
ORA-00600: internal error code, arguments: [kkbrcupfind2], [], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_47767/<instname>_ora_17688_i47767.trc
Mon Aug 06 12:11:30 2012
Dumping diagnostic data in directory=[cdmp_20120806121130], requested by (instance=1, osid=17688), summary=[incident=47767].
Mon Aug 06 12:11:31 2012
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Aug 06 12:11:32 2012
Sweep [inc][47767]: completed
Sweep [inc2][47767]: completed
Mon Aug 06 12:50:34 2012
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_17878.trc (incident=47839):
ORA-00600: internal error code, arguments: [kkbrcupfind2], [], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_47839/<instname>_ora_17878_i47839.trc

Failing Statement
==================

alter table <schema>.<table_name> drop column <column_name>;

Call Stack
===========
kgeasnmierr <- kkb_rencol_update_f <- uncindices <- kglsscn <- atbUpdDefaultVal
         <- 320 <- kglsscn <- atbdcolsub <- atbdrpcol <- atbdrv
          <- opiexe <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
           <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.