ORA-600 [ktsircinfo_num1] And Consequences

Last updated on AUGUST 26, 2017

Applies to:

Symptoms

ORA-00600: [KTSIRCINFO_NUM1] DURING SHRINKING OF TABLE IN EXFSYS SCHEMA

-- without cascade shrink runs fine
SQL> alter table EXFSYS.RLM$SCHACTLIST shrink space;

Table altered.

-- with cascade it fails
alter table EXFSYS.RLM$SCHACTLIST shrink space cascade;
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktsircinfo_num1], [0], [0], [0]

Call Stack
==========
ktsircinfo_main <- 556 <- kkbptsi_pack_tbl_seg_info
<- atb_shk_nt_get_info <- atb_shk_nested_tabl <- atb_shk_drv <- es
<- atbdrv
<- opiexe <- opiosq0 <- opipls <- opiodr <- rpidrus

Changes

 Upgraded to Oracle 11.2 version

Cause