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:39 PM, Julio Aguilar-Chang <jachang@xxxxxxxx>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@xxxxxxxx
> (505) 667-1004 - work
> *****************************************
>
>

Other related posts: