RE: Find which table's data has been changed in last five hours.
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: "Roger Xu" <wellmetus@xxxxxxxxx>
- Date: Mon, 3 Aug 2009 14:29:51 -0400
Version 10.2.0.3. Undo retention should be 24 hours I think, let me
double check.
Thanks,
Lu
From: Roger Xu [mailto:wellmetus@xxxxxxxxx]
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@xxxxxxxxxxxx> 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
Other related posts:
