RE: Flashback Schema ... any ideas
From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Wed, 22 Feb 2012 15:53:14 +0000
Message-ID: <7C5A0D167BEADF4C984A9167609E8E0F0F80DFB2_at_CHIMBX5.ad.uillinois.edu>
If you know the timeframe and it's isolated to a specific schema; one could use logminer to find the sql to undo the changes.
Date: Wed, 22 Feb 2012 15:53:14 +0000
Message-ID: <7C5A0D167BEADF4C984A9167609E8E0F0F80DFB2_at_CHIMBX5.ad.uillinois.edu>
If you know the timeframe and it's isolated to a specific schema; one could use logminer to find the sql to undo the changes.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mihajlo Tekic
Sent: Wednesday, February 22, 2012 9:39 AM
To: Kenneth Naim
Cc: oracle-l
Subject: Re: Flashback Schema ... any ideas
Hi Kenneth,
Thanks for the reply.
No we don't want to flashback entire database. Requirement is to rollback changes done to a specific schema.
Thanks,
Mihajlo
On Wed, Feb 22, 2012 at 9:27 AM, Kenneth Naim <kennethnaim_at_gmail.com> wrote:
> How about flashback database? Are changes being made to other schemas?
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 22 2012 - 09:53:14 CST