Re: Overwriting/deleting blobs

  • From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • To: "wblanchard@xxxxxxxxxxxxxxx" <wblanchard@xxxxxxxxxxxxxxx>
  • Date: Fri, 22 Feb 2013 22:44:26 -0600

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@xxxxxxxxxxxxxxx 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.
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: