Re: Dropping tables/Partitions with Purge... is data really gone?
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 8 Apr 2013 15:18:15 -0400
Message-ID: <CAE-dsO+KdKsdbg9KAToDgaERAzWnNogOAxK-UhGk+XE_YOV_+w_at_mail.gmail.com>
The security people won't know how to dump blocks to the OS. Would they be able to see the data with some kind of scanning tool? I need to use hourly partitions and drop them every hour. I am concerned security may make me use a tablespace for each partition. This will be a serious hassle to manage if I have to do this. btw, I know there will still be encrypted data in the archive logs. This is just about what is in the database files.
Date: Mon, 8 Apr 2013 15:18:15 -0400
Message-ID: <CAE-dsO+KdKsdbg9KAToDgaERAzWnNogOAxK-UhGk+XE_YOV_+w_at_mail.gmail.com>
The security people won't know how to dump blocks to the OS. Would they be able to see the data with some kind of scanning tool? I need to use hourly partitions and drop them every hour. I am concerned security may make me use a tablespace for each partition. This will be a serious hassle to manage if I have to do this. btw, I know there will still be encrypted data in the archive logs. This is just about what is in the database files.
On Mon, Apr 8, 2013 at 3:12 PM, rjamya <rjamya_at_gmail.com> wrote:
> 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:18:15 CEST