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 22.214.171.124 to 126.96.36.199 [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!