CLOB In Tablespace With Segment Space Management Auto Does Not Reuse Space
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 220.127.116.11 to 18.104.22.168 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2016***
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.
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