RE: delete one tablespace from all backups
Date: Thu, 25 Sep 2014 08:50:34 -0700
Message-ID: <029801cfd8d8$7294e590$57beb0b0$_at_comcast.net>
I think I would ask "What is the purpose of this request?"
I have had many odd requests from legal and compliance organizations and in the end they normally are looking for a way to solve a perceived problem but are trying to choose a way that does not match legal or compliance law or rules.
IMHO you should step back and have the question answered first, then you could discuss the how the perceived problem could be solved.
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jeremy Schneider
Sent: Thursday, September 25, 2014 6:12 AM
To: Oracle-L
Subject: delete one tablespace from all backups
someone asked me recently if it's possible to completely remove the data in one tablespace from all historical backups of a database. my knee-jerk response was simply "no" - thinking that even if you had the tablespace backups in their own backupsets, you couldn't remove data from undo and redo streams.
nonetheless I'm curious if anyone else on the list has ever thought about this and what you've come up with. if there was a business requirement to do this, then how close could you come?
-Jeremy
--Received on Thu Sep 25 2014 - 17:50:34 CEST
<http://about.me/jeremy_schneider> http://about.me/jeremy_schneider
-- http://www.freelists.org/webpage/oracle-l