> Thanks Julio.>> dba_tab_modifications returns no rows with today's timestamp :)>>>>>> *From:* Julio Aguilar-Chang [mailto:jachang_at_lanl.gov]> *Sent:* Monday, August 03, 2009 2:39 PM> *To:* Jiang, Lu> *Cc:* ORACLE-L> *Subject:* Re: Find which table's data has been changed in last five> hours.>>>>> Try dba_tab_modifications. It has columns such as the table_owner,> table_name, number of inserts/updates/deletes, and the timestamp.>>>> Jiang, Lu 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>>>> -->>>> *****************************************>> Julio Aguilar-Chang>> jachang_at_lanl.gov>> (505) 667-1004 - work>> *****************************************>>