Re: Find which table's data has been changed in last five hours.

From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 3 Aug 2009 13:28:17 -0500
Message-ID: <eb64345d0908031128r64f0eda1l30a1ca3437d4b50a_at_mail.gmail.com>



Which Oracle version? It depends on the undo you have ... What is the undo retention setting?

On Mon, Aug 3, 2009 at 1:15 PM, Jiang, Lu <Lu.Jiang_at_umassmed.edu> wrote:

> Hi DBA gurus,
>
>
>
> I need to flashback our EBS database to 10 hours ago, also hope the last
> five hours data can be recovered with export/import. Is there a way to find
> which table's/schema's data has been changed in last five hours, so that I
> could export the schemas/tables before flashback and import them after
> flashback?
>
>
>
> Thanks,
>
> Lu
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 03 2009 - 13:28:17 CDT

Original text of this message