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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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