CLOB In Tablespace With Segment Space Management Auto Does Not Reuse Space (Doc ID 401881.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2016***



Symptoms

When creating a table with a CLOB column in a tablespace with Automatic Segment Space allocation, the LOB segment created only grows and space is not reused even if rows have been deleted.

If the table is used extensively, this can lead to the tablespace filling up.
Alter table xxxx shrink space; does not have any effect.  Truncate table works but may not be feasible.

If the same table is created in a tablespace with Manual Segment Space allocation, the space is reused.

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