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

From: Jiang, Lu <Lu.Jiang_at_umassmed.edu>
Date: Mon, 3 Aug 2009 14:29:51 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890E536506_at_edmtpmail01.ad.umassmed.edu>

Version 10.2.0.3. Undo retention should be 24 hours I think, let me double check.  

Thanks,

Lu  

From: Roger Xu [mailto:wellmetus_at_gmail.com] Sent: Monday, August 03, 2009 2:28 PM
To: Jiang, Lu
Cc: ORACLE-L
Subject: Re: Find which table's data has been changed in last five hours.  

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:29:51 CDT