Home » RDBMS Server » Server Administration » LOB's and Disk SPace
LOB's and Disk SPace [message #224518] Wed, 14 March 2007 09:08 Go to next message
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??
Re: LOB's and Disk SPace [message #224524 is a reply to message #224518] Wed, 14 March 2007 09:38 Go to previous messageGo to next message
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.
Re: LOB's and Disk SPace [message #225194 is a reply to message #224518] Mon, 19 March 2007 01:14 Go to previous message
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 (...))
Previous Topic: Deleted REDO02.LOG (ORA-00313)
Next Topic: How: Script archive log transfer to standby db
Goto Forum:
  


Current Time: Sat Dec 03 17:59:38 CST 2016

Total time taken to generate the page: 0.06994 seconds