Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle blob
Someone wrote once:
May be this is a bug in oracle? Here is what I found out.
When you read this blob, you'll see that blob size is returning a size of 1MB. And the worst thing is, the blob stream in addition to the new file, has old files junk characters in the end.
So once a empty blob is used to store some data, it should not be modified and used to store another set of data. To resolve this issue, I delete the record and insert a new record in order to update the blob field with the new data.
If I use null as blob value, then I loose the reference,
to other records in other tables.
If I use empty blob, I dont gain free space, which is my goal. (see upper
message)
How can I get rid of the blob data, without loosing the structure?
I am talking about 160 Gbyte blob Data, which must be dropped somehow…and also quick, since we are running out of space here, so please answer as soon as possible,
Many many thanks in advance,
kostas Received on Thu Jul 22 2004 - 11:39:56 CDT