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

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


*****************************************



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