I remember VMS having a switch /ERASE on the DELETE command which would wipe the affected area. Otherwise it would just remove the reference to the file you were deleting. I'm open to work-arounds, even. I was just thinking that maybe CTAS and then deleting the original data might be a way. I haven't tested it yet, though. It still would be time consuming in production but we could incrementally do it. From: rajendra.pande@xxxxxxx [mailto:rajendra.pande@xxxxxxx] Sent: Thursday, March 07, 2013 11:35 AM To: hemantkchitale@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx; kevin.lidh@xxxxxxxxx Subject: RE: TDE for data previously unencrypted Yes _____ From: Hemant K Chitale [mailto:hemantkchitale@xxxxxxxxx] Sent: Thursday, March 07, 2013 1:34 PM To: Pande, Rajendra Cc: oracle-l@xxxxxxxxxxxxx; kevin.lidh@xxxxxxxxx Subject: RE: TDE for data previously unencrypted Ah ok. You mean an additional keyword to MOVE, DROP and TRUNCATE commands that would call special code only when needed. _____ No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2899 / Virus Database: 2641/6138 - Release Date: 02/28/13 Internal Virus Database is out of date. -- //www.freelists.org/webpage/oracle-l