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:56:18 -0500
Message-ID: <eb64345d0908031156h28387719qe503f2e46ca99d3e_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: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 - 13:56:18 CDT