Home » RDBMS Server » Server Administration » LOB Segments not releasing space (10.2)
LOB Segments not releasing space [message #388412] Tue, 24 February 2009 11:14 Go to next message
Messages: 120
Registered: November 2005
Senior Member
My table is monthly partition. Each partition goes to a seperate Month. It has blob column into it. So it has data from last year partition (Aug 08) and parition from Aug 09. I truncated partition Aug08 and there is no data is Aug09. But still cannot claim all spaces, means cannot shrink all datafiles belong this 1008 tablespace. Those datafiles cannot be shrink, which contains the lob segment and lob index. Can anyone please help me shrinking the datafiles?
Re: LOB Segments not releasing space [message #388415 is a reply to message #388412] Tue, 24 February 2009 11:18 Go to previous messageGo to next message
Messages: 24975
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
So we can help you & please be consistent & correct in your postings.
Re: LOB Segments not releasing space [message #388420 is a reply to message #388412] Tue, 24 February 2009 12:00 Go to previous message
Michel Cadot
Messages: 63945
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to SHOW us what you say.
Copy and paste the statements you executed to come to the conclusions you posted. We have to see them in order to know if you didn't misinterpret the results.

Before read OraFAQ Forum Guide, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Previous Topic: Port number
Next Topic: ASM - Unable too see Candidate Disks
Goto Forum:

Current Time: Fri Oct 28 08:58:13 CDT 2016

Total time taken to generate the page: 0.14355 seconds