Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LOB Segment Shrink on Oracle 9

634510Jul 15 2008 — edited Jul 15 2008

I have a table containing a blob column in oracle 9. This is tied to a lobsegment which has been growing regularly and is now up to 19 GB. I deleted rows from the table so that it should have also deleted the blob reference in the lobsegment. However, the space is still allocated for 19 GB. How do I shrink it back down to the space it is using without having to trunc the table?

I know oracle 10 has the modify lob (data) (shrink space) command to shrink a lob segment but is there a similar command in oracle 9?

Please help as I am running out of disk space for the server.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2008

Added on Jul 15 2008

#general-database-discussions

1 comment

2,000 views