ORA-00600 [16613] when shrinking space in LOB column. (Doc ID 808071.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

alter table <table_name> modify (<column_name>) shrink space;

TEST CASE
---------
-- Create table
create table T1(col1 number, col2 clob);

-- Shrink LOB space requires row movement enabled.
alter table T1 enable row movement;

-- Shrink LOB space:
alter table t1 modify (col2) shrink space;
==> ORA-00600 [16613] 

ORA-00600: internal error code, arguments: [16613], [0x3E5E27130], [2], [], [], [], [], []
Current SQL statement for this session:
alter table T1 enable row movement; 

CALL STACK
----------
kglsupd atbmod atbdrv opiexe opiosq0 kpooprx kpoal8 ... 




 

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