My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


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.


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

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