Overwriting/deleting blobs

From: <wblanchard_at_oshkoshcorp.com>
Date: Fri, 22 Feb 2013 22:36:31 -0600
Message-ID: <94A6F6A0-54E8-4119-B3B5-C0CD4CF228BA_at_oshkoshcorp.com>


Greetings,

I've been asked by our security department if there's a way to overwrite a blob in the database but I don't know of any way to do it. I asked my trusted coworker Google if there was a way to do it but he didn't have any good ideas either. I would love to ask Oracle but this app didn't think purchasing support from Oracle was important. So, I come to the most knowledgable DBAs in the world to ask for help.

Something tells me that it's not just as easy as inserting a new blob in the table as I would guess that it would have to be the exact same size as the current blob. Also, could I guarantee that it would be placed in the exact same blocks/segments that the current blob is in.

So, is there a way to "securely" overwrite/delete the current blob? What are my options, if any.

Thank you,

WGB WGB Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, please contact the sender immediately, delete this material from your computer and destroy all related paper media. Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties. Thank you.

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 23 2013 - 05:36:31 CET

Original text of this message