My Oracle Support Banner

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

Last updated on AUGUST 08, 2018

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.




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

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.