OraFAQ Forum: Server Administration » LOB's and Disk SPace

Home » RDBMS Server » Server Administration » LOB's and Disk SPace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOB's and Disk SPace [message #224518]

Wed, 14 March 2007 09:08

gkornacki
Messages: 6
Registered: January 2007
Location: Florida

Junior Member

Hello,

I'm looking to free up some disk space and I have a ton of LOB data I can get rid of. The problem is when I delete the records the space doesn't get reclaimed for the LOB index. Does this index have to be rebuilt? Can anyone show me how to do it and have the LOB column still available? I'm on 9.2.0.5

I thought of the old trusty export the table, drop table import table, but there must be another way??

Report message to a moderator

Re: LOB's and Disk SPace [message #224524 is a reply to message #224518]

Wed, 14 March 2007 09:38

gkornacki
Messages: 6
Registered: January 2007
Location: Florida

Junior Member

Nevermind I found out. Thanks for looking.

alter table <table name> modify lob (<lob column name>) (deallocate unused);

There it is if anyone is interested.

Report message to a moderator

Re: LOB's and Disk SPace [message #225194 is a reply to message #224518]

Mon, 19 March 2007 01:14

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

You can move the lob segment

alter table xxx modify lob () store as (tablespace ... storage (...))

Report message to a moderator

Previous Topic:	Deleted REDO02.LOG (ORA-00313)
Next Topic:	How: Script archive log transfer to standby db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:43:14 CST 2024