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

Thanks Julio.  

dba_tab_modifications returns no rows with today's timestamp :)

 

 

From: Julio Aguilar-Chang [mailto:jachang@xxxxxxxx] 
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@xxxxxxxx
(505) 667-1004 - work
*****************************************

Other related posts: