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