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

From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 3 Aug 2009 13:55:16 -0500
Message-ID: <eb64345d0908031155p55fa0227v9a2613d0c0bb12eb_at_mail.gmail.com>

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:39 PM, Julio Aguilar-Chang <jachang_at_lanl.gov>wrote:

>
> 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-Changjachang_at_lanl.gov
> (505) 667-1004 - work
> *****************************************
>
>

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

Received on Mon Aug 03 2009 - 13:55:16 CDT