My Oracle Support Banner

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: to
This problem can occur on any platform.


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

-- 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; 

kglsupd atbmod atbdrv opiexe opiosq0 kpooprx kpoal8 ... 



To view full details, 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 a vibrant support community of peers and Oracle experts.