If you are using Oracle, you can do a table reorganize. This compresses the data and gives some level of certainty that the data on the physical device is overwritten.
What do other apps that fall under this umbrella do to clean data from their databases? Also, how is the data removed from other storage mediums (tape, replicated servers, etc)? Axton Grams On 4/27/06, L. J. Head <[EMAIL PROTECTED]> wrote: > In the DOD arena there are times that data needs to 'disappear'. I was > asked by a customer yesterday what options were available for scrubbing of > data. I offered the ability to delete records in audit trails and the asked > a question I had never even considered. Once Remedy issues the Delete > command...and commits the transaction it is deleted out of the table...but > what can be done to ensure the data is gone and not just having the pointer > to the data removed. Those in government are familiar with the 'military > wipe' type of cleaning utilities. We are running SQL Server 2000, are there > DB commands that I can run to perform an online compress or something like > that? TYIA > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
