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:15:44 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890E5364D5_at_edmtpmail01.ad.umassmed.edu>

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,

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 03 2009 - 13:15:44 CDT

This message: [ Message body ]
Next message: Matthew Zito: "RE: Does ocssd.bin started from 11gASM home support diskgroups mounted by 10g ASM instance"
Previous message: sanjeev m: "Re: Does ocssd.bin started from 11gASM home support diskgroups mounted by 10g ASM instance"
Next in thread: Roger Xu: "Re: Find which table's data has been changed in last five hours."
Reply: Roger Xu: "Re: Find which table's data has been changed in last five hours."
Maybe reply: Jiang, Lu: "RE: Find which table's data has been changed in last five hours."
Maybe reply: Roger Xu: "Re: Find which table's data has been changed in last five hours."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message