Database Administration (MOSC)

MOSC Banner

Can I use "Shrink Table" to de-allocate unused blocks after deleting LOBs in Oracle 11g Standard Edi

edited Dec 9, 2017 4:02AM in Database Administration (MOSC) 2 commentsAnswered

Hi,

I am trying to de-allocate unused space, after deleting LOBs from a table using the following command

ALTER TABLE OWNER.TABLE_NAME MODIFY LOB (COLUMN_NAME) (SHRINK SPACE);

But, It only free few megabytes of space, while I have deleted around 100GB data. Also the table is not reusing the free blocks. It gives an error that can't extend the LOB segment.

Would anybody please advise, how to de-allocate the free blocks or reuse it. Is there any limitation on 11g Standard Edition 1.

Due to insufficient Hard disk space, I can't move the whole table data to a new tablespace to reduce the tablespace size.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center