| LOB Segments not releasing space [message #388412] |
Tue, 24 February 2009 11:14  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
Hi
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 #388420 is a reply to message #388412] |
Tue, 24 February 2009 12:00  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
