| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
