RE: Find which table's data has been changed in last five hours.
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: "Julio Aguilar-Chang" <jachang@xxxxxxxx>
- Date: Mon, 3 Aug 2009 14:52:00 -0400
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:
