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

From: Adam Musch <ahmusch_at_gmail.com>
Date: Mon, 3 Aug 2009 16:31:00 -0500
Message-ID: <516d05a0908031431o67009e88u32b5129e6f809c0_at_mail.gmail.com>

If the table is being monitored (ALTER TABLE .... MONITORING, which the default statistics job sets on your behalf) and one executes dbms_stats.flush_database_monitoring_info, then all the tables which appear in the
*_TAB_MODIFICATIONS view have had DML or been truncated since the last time statistics were gathered. If one doesn't run DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO, the information in the *_TAB_MODIFICATIONS views can be stale.

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
>
> *****************************************

-- 
Adam Musch
ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 03 2009 - 16:31:00 CDT