Re: Dropping tables/Partitions with Purge... is data really gone?
From: rjamya <rjamya_at_gmail.com>
Date: Mon, 8 Apr 2013 15:12:10 -0400
Message-ID: <CAGurbTM9u9pg_aWSE7wji+joeo_KkDht1+uOtQ8vcBUWJYSX-w_at_mail.gmail.com>
I believe purge ensures that table cannot be recovered from recyclebin. The blocks are marked as available for reuse after drop, but it doesnt mean they are reformatted or immediately reused (based on my very limited knowledge).
So, if you dump some of those blocks (if you remember the blocks numbers), you *might* be able to see encrypted data but not entirely sure about that. Unless you drop the datafile, at the file system level it will appear as still full (data) file since extent allocation is handled internally.
Date: Mon, 8 Apr 2013 15:12:10 -0400
Message-ID: <CAGurbTM9u9pg_aWSE7wji+joeo_KkDht1+uOtQ8vcBUWJYSX-w_at_mail.gmail.com>
I believe purge ensures that table cannot be recovered from recyclebin. The blocks are marked as available for reuse after drop, but it doesnt mean they are reformatted or immediately reused (based on my very limited knowledge).
So, if you dump some of those blocks (if you remember the blocks numbers), you *might* be able to see encrypted data but not entirely sure about that. Unless you drop the datafile, at the file system level it will appear as still full (data) file since extent allocation is handled internally.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 08 2013 - 21:12:10 CEST