Re: Find which table's data has been changed in last five hours.
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: Lu.Jiang@xxxxxxxxxxxx
- Date: Mon, 3 Aug 2009 13:56:18 -0500
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@xxxxxxxxxxxx> wrote:
> 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:
