Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to remove data from disk
I have a table with some sensitive customer data in it. I am now
keeping all the data in another table, and encrypting it. I want to
get rid of the original unencrypted data and be sure that it is no
longer anywhere on disk. Should I drop the table, or first delete the
rows and then clear the redo logs? I'm not sure how to know if the
data is actually physically deleted from disk, or if it's still there,
but just in blocks that get marked as available. Any guidance would
be greatly appreciated.
Thanks,
Bruce
Received on Thu May 06 2004 - 18:14:54 CDT