Dropping tables/Partitions with Purge... is data really gone?
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 8 Apr 2013 14:58:45 -0400
Message-ID: <CAE-dsOK7ed3hTm4SOvTnkJcdPSZsLCYmj+mBe2Nr9v_EA1vTrg_at_mail.gmail.com>
2 versions: Oracle 10.2, Oracle 11.2 (different DBs). OS: Redhat, Solaris, HP, IBM AIX (not sure on versions, but could be on any of these OSs).
If we drop a partition with the purge option, is the data gone? When you do a delete from the OS (particularly in windows) it is possibly to recover the data.
I have sensitive data that needs to be permanently gone. We are encrypting the data using transparent data encryption. However, some security guys will probably run some tools to look at the hard drives to make sure the data cannot be recovered.
Date: Mon, 8 Apr 2013 14:58:45 -0400
Message-ID: <CAE-dsOK7ed3hTm4SOvTnkJcdPSZsLCYmj+mBe2Nr9v_EA1vTrg_at_mail.gmail.com>
2 versions: Oracle 10.2, Oracle 11.2 (different DBs). OS: Redhat, Solaris, HP, IBM AIX (not sure on versions, but could be on any of these OSs).
If we drop a partition with the purge option, is the data gone? When you do a delete from the OS (particularly in windows) it is possibly to recover the data.
I have sensitive data that needs to be permanently gone. We are encrypting the data using transparent data encryption. However, some security guys will probably run some tools to look at the hard drives to make sure the data cannot be recovered.
When oracle drops a table or a partition with purge it does a DDL, so I know it updates the data dictionary tables, but what does it do to make sure the data is really gone from the datafiles? To pass a security check I need to make sure the data is really gone.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 08 2013 - 20:58:45 CEST