Database Administration (MOSC)

MOSC Banner

How to reclaim LOB column occupied space on table space?

edited Apr 20, 2011 3:06AM in Database Administration (MOSC) 6 commentsAnswered

Hello, 

As most of you know once we allocate BLOB( in my case) column  assign the table with in same table space,  delete operation doesn't free up the space on tablespace. 

even it doesn't show on dba_segments view as well. 

ever one can see the space is there but even though we got the ORA-01653: unable to extend table 

environment is 10gR2. on AIX
in my shop we are not using ASM. ( where I can't use shrink option too)


I have a work around that we can delete/ truncate the table and recreate it ... but I can't do that on production. 

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