RE: 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 15:35:02 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890E536620_at_edmtpmail01.ad.umassmed.edu>



Thanks Roger. Run query against flashback_transaction_query takes a while, it returns over 12 hours transaction.

Our problem is caused by an Oracle apps patch, now Oracle ask us to apply another patch to fix it. If this will not work then I would do the recovery.

Thanks again for the help.    

From: Roger Xu [mailto:wellmetus_at_gmail.com] Sent: Monday, August 03, 2009 2:56 PM
To: Jiang, Lu
Cc: Julio Aguilar-Chang; ORACLE-L
Subject: Re: Find which table's data has been changed in last five hours.  

DBA_TAB_MODIFICATIONS describes modifications to all tables in the database that have been modified since the last time statistics were gathered on the tables. Try flashback_transaction_query ...

On Mon, Aug 3, 2009 at 1:52 PM, Jiang, Lu <Lu.Jiang_at_umassmed.edu> wrote:

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
*****************************************
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 03 2009 - 14:35:02 CDT

Original text of this message