| Problem with LOB Deallocation [message #109569] |
Fri, 25 February 2005 22:40  |
omprasad
Messages: 4
Registered: February 2005
|
Junior Member |
|
|
Hi,
I have a table that contain a blob column and i have around 200,000 records in the table.The table has crosed the max tablespace size that it can extend.
So I deleted some of the records and then tried to add some more records,But I was not able to add any more records. I think the space allocated out of line for the Blob is was not deallocated.
The exact error message is
java.io.IOException:ORA-01691:Unable to extend lob segment
comming to my question..Is there any any to free the space allocated for lob segment(which are stored out ofline) as these are not released when i delete the rows from the table.
|
|
|
|
| Re: Problem with LOB Deallocation [message #117086 is a reply to message #109569] |
Sun, 24 April 2005 17:40  |
rhardman
Messages: 25
Registered: April 2005
|
Junior Member |
|
|
A bit late on the response, but I wanted to post in case you were still running into an issue. This was a known issue on certain versions. Check your db version against bugs on the issue in Metalink. If you can't track it down, log a ticket with support and point them to forum entry 23177.996 on Metalink where the analyst references the problem. There are a number of bugs available for different version that point to the same issue too.
-Ron
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
