Re: Overwriting/deleting blobs

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 22 Feb 2013 22:44:26 -0600
Message-Id: <531B6FDD-6603-4810-ADC9-56041CF11B8D_at_gmail.com>



Could you use the empty_lob() function in an update?

Chris

Sent from my mobile device. Please ignore any typos.

On Feb 22, 2013, at 10:36 PM, wblanchard_at_oshkoshcorp.com wrote:

>
> 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
>
>

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

Original text of this message