Dropping tables/Partitions with Purge... is data really gone?
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Apr 2013 14:58:45 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
